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. |
