Database Mapping with Database Exception Handling

Critical business processes depend on reliable data and database administrators and other data analysts want to be confident in the integrity of information stored in database tables. During automated ETL (Extract Transform Load) operations or other database import tasks, invalid data might be encountered that jeopardizes success of the procedure. Altova MapForce includes database exception handling to roll back the affected data when an error occurs and optionally proceed with the rest of a database mapping.

For instance, an error in a single record need not prevent execution of a mapping from continuing, such as when certain database constraints prevent the mapping from inserting or updating invalid data.

Read more…
Tags: , , ,

MapForce Tutorial (Video)

Altova MapForce is an any-to-any data transformation, conversion, and ETL tool for integrating data.

A graphical data mapping tool, MapForce has an intuitive drag-and-drop interface that lets you easily convert data between any two formats, such as XML, JSON, relational databases, EDI, and more. It also features an extensive library of conversion functions that can be chained together to form custom functions that can be reused throughout your projects.

Data translated by MapForce can be pulled to or pushed from any relational database and all data management products, and it can be adapted to customize in-house data management solutions.

The MapForce tutorial video below covers all major features offered by the data integration tool and shows example mappings between several different types of files.

You can try MapForce yourself with a free, 30-day trial.

Tags: , , , , , ,

Database Tracing to Log Changes Made by a Data Mapping Project

Database administrators and other data professionals often want to maintain a record of changes in critical databases, especially when updates are made by automated scripts or other operations. Database tracing lets administrators track critical changes or anomalies, and help recover from errors. Altova MapForce supports database tracing for all popular relational databases to log the changes made by a data mapping project to the database when the mapping runs.

When tracing is enabled, events such as database insert or update actions, or errors, are logged in an XML file that you can later analyze or process further in an automated way.

Database tracing can be enabled at the database component, table, stored procedure, or database field level. You can choose to trace all messages or only errors, or you can disable tracing completely.

In addition to tracing errors that occur during the execution of a mapping to a target database, MapForce also enables database transaction handling to roll back the affected part of the database data when an error occurs, then optionally proceed with the rest of the mapping.

Read more…
Tags: , , , ,

MapForce Supports SQL Merge When It’s the Right Tool for the Job

Large database tables can easily contain a million, even hundreds of millions of rows of data. Database administrators and others charged with maintaining such large datasets are always concerned about execution time for ETL (Extract, Transform, and Load) operations, updates, and other SQL queries. To make these operations more efficient, some — but not all — database vendors implemented a SQL merge statement to insert or update rows of an existing table as a single bulk-insert statement rather than requiring individual statements for each row.

Altova MapForce automatically supports SQL merge when it is available for the target database. Let’s look at an example.


Read more…

Tags: , , ,