The target system data model forms the basis for the export mapping process in Data Validator. The export process uses a defined mapping, based on the structure of the target system, to manage loading data into the target system.
The data to be exported must match the data in the target system database using any one of three parameters:
-
Unique ID
-
Unique key
-
Query definition
By default, Data Validator identifies objects in the target system using the UID constructed in the staging area and the class definition specified in the export map. Sometimes, however, the UIDs for a specific type of object in a target system cannot be constructed or predicted from the data provided in a CSV file. In that case, you can use a target system unique key or a query definition to specify how to identify the object in the target system.
You can export data to a target system by mapping the imported staging area data objects to the existing objects, properties, and relationships found in the target system. You can manually configure the export mapping for each object in the imported data, or you can automatically generate the export mapping from the target system by selecting the Auto Generate Export Mapping option when you create a new import definition. The export mapping can be further refined for each stage object to target object mapping by selecting specific property-to-property, relationship-to-property, and relationship-to-relationship mappings.
If you have two target systems that use the same model or schema, they can share
the same export mapping.
