In this scenario, we're going to use DMT to regularly export orders from several sales system and load them into a fulfillment system.
Let's say you have several sales system taking orders automatically and you need to transfer them regularly into a separate fulfillment system.
For this example we'll have 2 sales systems:
The fulfillment system is based on an Oracle database.
Note: For our example, we chose an Oracle and a DB2 database and a CSV file format 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:
![]() |
e.g. |
SELECT ORDER_ID, CLIENT_ID, PROD_ID, QTY FROM ORDERS WHERE PROCESSED = 'N' |
Note: We only need one export job since the other system already supplies order files containing the data.
Once the export job is created, you can validate it to make sure it's error free and ready to run (right click on the Job then "Validate Job").
Active | Dest. Column (in dest. database) | Value (from src. data file) | Comments |
---|---|---|---|
Yes | ID | ORDER_ID | |
Yes | CLIENT | CLIENT_ID | |
Yes | PRODUCT | PRODUCT_ID | |
Yes | QTY | QTY |
Active | Dest. Column (in dest. database) | Value (from src. data file) | Comments |
---|---|---|---|
Yes | ID | ORDER_NUM | |
Yes | CLIENT | CLIENT_NUM | |
Yes | PRODUCT | PRODUCT | |
Yes | QTY | QUANTITY |
Note 1: Both jobs load data in the same destination columns, but the data file column names are slightly different between the 2 data files.
Note 2: You can enhance the process by deleting data files after they've been loaded (see advanced parameters).
Note 3: Because we don't know when the data file ExternalOrders.csv is delivered by the external system, we run the "Load CSV Orders" job every 30 minutes and use a run pre-condition to make sure the data file is present.
Note 4: Before you can enter load mappings for the load jobs, you need to look up the column definitions for the data file and/or the destination table.
Once the load 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:
Note: It's always a good idea to run groups or jobs manually at least once before scheduling them.