Page History

...

1. Open the btibSQL palette.
   
   
   
   
2. Drag and drop the block to your dataflow strategy.
   
   
   
   
3. Double-click on the block and fill the parameters.
   Image Removed
   Image Added
   
   

 Properties

• Target : The Next Target not used here.
• Enabled: Whether the block is enabled or not. 
• Last Timestamp : The The last export timestamp. Any record before this timestamp won't be exported.
• Batch Size: The size of the batches to be processed.
• Batch Delay : Time to wait between batches.
• Destinations : Last export destinations.
• Export Policy: 
  • Single Table: export all data ° and tags into one table, each tags will be represented as column.
  • Multi Table: Tags and value will be exported in separate table tables and mapped using relations/.
• Sql Connector : The sql connector to use.
• Table Prefix: The name of the destination table.
  • In the case of a single table export, this will be name of the table
  • In the case of multi table, this will be used as the prefix for the tag and the relation tables.
• Date Suffix: Add If set to true, adds the today suffix to the destination .
  
  

...