Run SQL. Runs a custom SQL statement against the configured database without returning any rows, typically to update or clean up data.
Export SQL result to file. Runs the configured SQL query and writes the result to a file (CSV, fixed-width or XML) using the export format options of the step.
The action runs as a step in a SyncTool configuration. You configure the step's settings (e.g. server, login, path, format or SQL depending on the action) and run the configuration. The action fetches the data it needs from Sapera or the external source itself – you do not map source columns as you would for a regular import.
Run SQL executes your SQL statement against the configured database without returning rows – typically to update or clean up data. Export SQL result to file runs the query and writes the result to a file (CSV, fixed width or XML) according to the step's export format.
Often combined with e.g. an FTP or e-mail step that sends the generated file on.
See also the overview SyncTool – actions.
