Next >> << Prev

Tour Part 7: Pre and Post Processes

Execute additional processes before and/or after exports and loads:

Run SQL statements or Stored Procedures


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.

SQL Pre or Post Process
 
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 External Program


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).

Executable Pre or Post Process
 
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


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.

Email Pre or Post Process
 
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.

Transfer files via FTP


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.

FTP Pre or Post Process
 
The post process uploads the data file (containing the exported data) to a remote FTP server.

Run other Exports or Loads


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.

Run exports or loads Pre or Post Process
 
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.