Mapping Data to Databases

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce >

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.


© 2019 Altova GmbH