Next >> << Prev

Tour Part 2: Export data from any data source

Manage all your exports from the Export Tab:

  • Create and edit data exports (all parameters saved for reuse)
  • Organize exports in groups and jobs (like folders and files)
  • Enter any SQL statement to export your data
  • Test and run exports on demand
Export Data Tab

It contains 4 sections:

1. List of Exports: This list contains all your export groups and jobs. It looks and behaves like files and folders in the windows explorer. Jobs are data exports performed by DMT and groups are a way to organize jobs together. The area on the right (2,3,4) display information about the group or job currently selected.
2. Export Parameters: In this area you can instantly view and edit the main attributes of an export (e.g. Name, Database Connection, Data File information, etc). You can also access additional attributes like Run Pre-Conditions (See Tour Part 6) and Pre or Post Processes (See Tour Part 7).
3. Enter your own SQL Statement: In this area you can enter the SQL Statement used to export the job’s data. You can enter any SQL statement (including stored procedures), giving you total flexibility over what data you want to export and how.
4. Scheduling Parameters: All groups and jobs can either be run "manually" on demand or be scheduled to run independently. In this area you can define all the scheduling parameters (e.g. run frequency, run time, run days, etc). There are many scheduling frequencies and options to define when exports run. More details about scheduling parameters in Tour Part 5.

Once you've created an export job, it's automatically saved in DMT with all its parameters (so you can reuse it again). Whenever a job runs, it automatically connects to the database you've specified and delivers the exported data in the format you've chosen.

You can run export jobs on demand from DMT or automatically with the scheduler (see Tour Part 4).