Exporting Data to Target Applications

After source data passes the validation process, a load file is created. Select the Export option after you have reviewed the data in the data grid and are sure you want to export it to the target application.

To export data to the target application:

1. From the Data Integration home page, click to the right of the integration, and then select Workbench.
2. Optional: Click Period, to select another period from the current POV.
3. Click Export ().
4. From Export Mode, select the method for exporting the data.

   Available export modes:

   • Merge—Overwrite existing data with the new data from the load file. (By default, all data load is processed in the Merge mode.) If data does not exist, create new data.

   • Replace—Clears all data for the POV in the target, and then loads from the source or file. For example, a first-time load has 100 rows, and a second load has 70 rows. In this case, 100 rows are removed, and 70 rows are loaded to TDATASSEG. After this load, the row total is 70.

     For a Planning application, Replace clears data for Year, Period, Scenario, Version, and Entity that you are loading, and then loads the data from source or file. Note that when you have a year of data in the Planning application, but are only loading a single month, this option clears the specific month only before performing the load.

   • Accumulate—Accumulate the data in the application with the data in the load file. For each unique point of view in the data file, the value from the load file is added to the value in the application.

   • Subtract—Subtract the value in the source or file from the value in the target application. For example, when you have 300 in the target, and 100 in the source, then the result is 200.
5. Click Run.