Execute additional processes before and/or after exports and loads:
Run SQL statements or Stored Procedures against any data source before or after an export or load.
This can be useful to perform data preparation, cleanup, logging, reporting, etc.
![]() |
The post process inserts a row in the report T_LOG table with information about the export or load that's just run.
Note: the $RV values used in the SQL statement are special values called Run Variables. |
Run any executable program (.BAT, .EXE, etc.) before or after an export or load.
This can be useful to perform operations external to the data sources (e.g. deleting files, launch external processes, etc).
![]() |
The pre process executes the Cleanup.exe program and waits until it’s completed to start the export or load.
The program is automatically killed if it isn't completed after 3 minutes. |
Send notification Emails before or after an export or load.
This can be useful to keep people informed of exports and loads performed by DMT. You can also attach a file containing the exported or loaded data.
![]() |
The post process sends an email to the specified recipient(s) with information about the export or load that's just run.
The exported data file is zipped and attached to the email. Note: the $RV values used in the email body are special values called Run Variables. |
Upload or Download any file via FTP before or after an export or load.
This can be useful to send exported data to a remote location or obtain data to load from a remote location.
![]() |
The post process uploads the data file (containing the exported data) to a remote FTP server.
|
Run another export or load before or after an export or load.
This can be useful to link exports and loads together into a single operation.
![]() |
The pre process runs the "Extract Source Data" job to produce the source data before loading it into the destination database.
|
That's it. Thanks for taking the tour.
If you you'd like more information about DMT, have a look at the following pages:
You can also Contact Us, we'll be happy to answer your questions.