Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

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

Inserting Data into a Table

Control how primary key values are to be created...

Inserting Data into a Table

Inserting Data into Multiple Linked Tables

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

Inserting Data into Multiple Linked Tables

Database Table Actions Settings

Preserve the hierarchical relationship of records in tables linked by foreign keys...

Inserting Data into Multiple Linked Tables

Update a table conditionally...

Updating a Table

Merge records into a database table (update some records, and also insert some other records into the same table), based on a condition...

"Update if... Insert Rest" Action

MERGE statements

Preserve database integrity when updating tables that are linked to other tables through foreign key relationships...

Options for Child Tables When Updating a Parent Table

Define multiple actions against the same table (for example, delete a record if a condition is satisfied, otherwise insert a new record)...

"Delete if..." Action

"Ignore if..." Action

 

Preserve data integrity in case of failed mapping execution...

Handling Database Exceptions

Insert multiple records into a database table in bulk (combine multiple INSERT statements in one query)...

Bulk Inserts (MapForce Server)

Avoid undesired results when mapping data to target database tables that contain null values...

Handling Nulls in Database Table Actions

View an example of how to create a mapping which updates a database.

Example: Mapping Data from XML to SQLite

© 2019 Altova GmbH