Running a Post Execution Script
You can execute your own SQL script automatically after a table synchronization or consolidation. The script can be used to modify data or create indexes, for example. The script will be executed against the destination table.
To add a post execution script to a table:
-
Click Extractions on the left.
-
Click the link in the Tables column for the appropriate extraction (of Synchronization or Consolidation type).
-
Hover your mouse over the Post Execution Script column of the appropriate table to add your script.
-
Copy and paste your script in the text box.
TipThe script in the image above uses sp_execute with SQL Server (sp_executesql); this command is useful if you wish to execute several SQL queries concurrently.
-
Click Save.
-
Go back to the Extractions page and edit it to make the extraction active again.