Automating the Data Manager Utility

To run the DataManager utility from the command line, you call the DataManager executable with the following parameters:

/CONFIG – full path to the. TPI DataManager Job configuration file
/IN1 – /IN100 – the names of the files loaded into the DataManager in the same order they exist in the Job
/OUT1 – /OUT100 – the name of the file(s) generated in DataManager, in the same output order

Example Statement:

>”Path to DataManager Executable (datamanager.exe)” /CONFIG “Path to .TPI DataManager Job File” /IN1 “First Input File in the DataManager Job” /IN2 “Second Input File in the DataManager Job” /OUT1 “Output File in the DataManager Job”

 

Example Scenario

We want to do a simple join between 2 CSV files in order to include data from a second file in our main source. In this scenario, there are a few files necessary in order to run this job.

First, we need a DataManager .TPI file which executes the join logic:

.TPI DataManager Job File – Join.TPI

Next, we need our 2 source CSV files with corresponding data fields:
2 Source Files – Order to Cash Sample TPI Data.CSV & Order to Cash Shipping Source Data.CSV

Lastly, we want to specify the output file where we should save the resulting data:
1 Output File – OUTPUT_FILE.CSV

For the example and corresponding files above, the command line statement looks like this:

>”C:\Program Files\…\datamanager.exe /CONFIG “C:\…\JOIN.TPI” /IN1 “C:\…\ Order to Cash Shipping Source Data.CSV” /IN2 “C:\…\ Order to Cash Sample TPI Data.CSV” /OUT1 “C:\…\Order to Cash Sample\OUTPUT_FILE.csv”