Visual Importer ETL is capable of running SQL before and after loading data into the target database.

Note:

  • SQL is executed against the target database
  • All SQL statements must be separated by a delimiter
  • it is possible to run any SQL statement including executions stored procedures

Typical usage of this feature would be truncating the table before loading the data and running some calculations after

 It is possible to run any SQL statement here,
 including stored procedures
 all statement must be separated by a delimiter

All our ETL tools have no limitations, which means you can load your data today and solve all the data quality problems right now.