In this scenario, we're going to use DMT to produce Excel reports from a database.
Although DMT doesn't yet directly generate data files in Excel format (functionality planned for version 2), you can easily generate CSV files that can be read by Excel.
Let's say you have a trading system from which you want to produce daily Excel reports for your 3 top accounts. The data is stored in several databases located around the world.
Note: For our example, we chose Oracle, SQL Server and DB2 databases and CSV files, but this would work the exact same way with any other database or any other supported file format.
You can easily implement this scenario with DMT:
![]() |
There are several ways this scenario could be implemented with DMT. Here we've chosen to use one group for all the exports, and to use one data file for Account 2 (containing both New York and London trades).
e.g. |
SELECT TRADE_ID, STOCK_ID, QTY, AMOUNT FROM TRADES_PARIS WHERE ACCOUNT_ID = 1 |
e.g. |
SELECT TRADE_ID, STOCK_ID, QTY, AMOUNT FROM TRADES_NY WHERE ACCOUNT_ID = 2 |
e.g. |
SELECT TRADE_ID, STOCK_ID, QTY, AMOUNT FROM TRADES_LONDON WHERE ACCOUNT_ID = 2 |
e.g. |
SELECT TRADE_ID, STOCK_ID, QTY, AMOUNT FROM TRADES_LONDON WHERE ACCOUNT_ID = 3 |
Note: Scheduling parameters are not required for the jobs because they belong to a Schedule Group (i.e. they will run automatically when the group is run).
Once the export group and jobs are created, you can validate them to make sure they are error free and ready to run (right click on the Group then "Validate Group").
Once the Export and Load Groups/Jobs are created, you can let the scheduler run them automatically. Just go to the scheduler Tab and click the Start button. When the scheduler is started, the export group (i.e. its 4 jobs) will run every day at the specified time.
Each time the export group runs, the following is happening:
Note: It's always a good idea to run groups or jobs manually at least once before scheduling them.