Summary
SQL Export Block is a terminal dataflow block that exports data using an SqlTSConnector.
Implementation
- Open the btibSQL palette.
- Drag and drop the block to your dataflow strategy.
- Double-click on the block and fill the parameters.
Properties
- Target : The Next Target not used here.
- Last Timestamp : The last export timestamp.
- 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 ° tags into one table, each tags will be represented as column.
- Multi Table: Tags and value will be exported in separate table and mapped using relations/
- Sql Connector : The sql connector to use.
- Table: The destination table.
- Date Suffix: Add the today suffix to the destination.
Actions
- Execute: Executes the block.