Mapping Data to Databases
This section provides instructions and examples for transferring data from any mapping source supported by MapForce (for example, an XML file) to a target database. Use the following roadmap for a summary of available options.
I want to... | Read this topic... |
---|---|
Insert data into a target database table based on data supplied by the mapping... | |
Control how primary key values are to be created... | |
Run a "preliminary" SQL statement to be executed before a table is modified by the mapping (for example, delete all records in the table, or a custom SQL statement)... | |
Preserve the hierarchical relationship of records in tables linked by foreign keys... | |
Update a table conditionally... | |
Merge records into a database table (update some records, and also insert some other records into the same table), based on a condition... | |
Preserve database integrity when updating tables that are linked to other tables through foreign key relationships... | |
Define multiple actions against the same table (for example, delete a record if a condition is satisfied, otherwise insert a new record)... |
|
Preserve data integrity in case of failed mapping execution... | |
Insert multiple records into a database table in bulk (combine multiple INSERT statements in one query)... | |
Avoid undesired results when mapping data to target database tables that contain null values... | |
View an example of how to create a mapping which updates a database. |