EPCs and Owner Operators frequently have to exchange data incrementally based on the progress they make when collaborating on projects. In such cases, it is a cumbersome task to load all the configurations like import mappings, export mappings, rulesets, job definitions, and so on as separate XML files into the target system multiple times when changes are made.
You can use the Export Data Validator Configurations and the Compare XML Values options in the staging system Desktop Client and generate the delta changes as XML files in a couple of clicks. After verifying that the changes are correctly captured, the XML files can be loaded into the target system to update the data with all the changes.
The schema files are not compared as the comparison may generate the delete instructions
for the staging schema which is referenced in another configuration.
Generate the base configuration
-
In the Desktop Client, click Find > Data Validator > Job Definition.
-
In the Find Job Definition dialog box, enter the name of the job definition or a wildcard character, and click OK.
-
Right-click the selected job definition, and click Export Data Validator Configurations.
-
In the Export Data dialog box, ensure the Split Files by Container ID checkbox is not selected, and click Export.
Before clicking Export, we recommend you to clear the Split Files by Container ID checkbox to avoid creation of multiple files based on container id, so that there
are less number of files to compare.
-
In the Browse for Folder dialog box, navigate to the location where you want to save the folder containing the exported data.
The software creates the folder, MultipleContainerIDs, containing three files - SCHEMA_MultipleContainerIDs.xml, ADMIN_MultipleContainerIDs.xml, and DATA_MultipleContainerIDs.xml.
Consider this folder and these XML files as the base configuration.
Generate the modified configuration
-
Make the required changes to the Data Validator configuration and repeat steps 1 - 5 above.
Consider the folder and the XML files created now as the modified configuration.
Compare the base and modified configurations
In the Desktop Client, use the Compare XML Files option to compare the ADMIN and DATA XML files in the base and modified configurations, and generate instructions to migrate the data in the database based on the differences between the files.
-
Select Administration > Compare XML Files in the Desktop Client to open the Compare XML Files dialog box.
-
In the File 1 box, browse to select the ADMIN_MultipleContainerIDs.xml file from the base configuration folder.
-
In the File 2 box, browse to select the ADMIN_MultipleContainerIDs.xml file from the modified configuration folder.
-
Click OK. The Xml Comparison form shows the differences between the two admin files highlighted in different colors (see key at the bottom of the dialog box).
-
Use the Previous and Next buttons to step from one difference to the next.
Review all the additions, deletions, and changes carefully.
-
Click Generate Instructions to migrate the data in the database based on the differences between the files and the associated instructions for loading.
-
Click Exit.
-
Repeat steps 1 to 7 to generate loading instructions for the DATA_MultipleContainerIDs.xml files in the base and modified configurations.
Load the incremental changes into the target system
Use the Desktop Client Loader in the target system to load the generated instructions from the comparison of the ADMIN_MultipleContainerIDs.xml and DATA_MultipleContainerIDs.xml files. For more information, see Loader.
The updated schema files can be directly loaded without comparing the files.