Mapping Information from Databases (Magic xpi 3.x)
The Data Mapper can map data to and from databases to all of the data types it supports. The mapper reads information from the following types of databases:
-
Microsoft SQL Server
-
Oracle
-
DB2
-
DB2/400
-
Pervasive SQL
-
ODBC
Note:
|
You must configure your computer using an ODBC driver in the Microsoft Windows ODBC Data Source Administrator. Be sure that the driver that you choose is installed on your computer.
|
|
The Resource Repository contains the information required to connect to a database’s data Sources so they can be used in the Data Mapper.
Before you can map data from a database, you must first enter the database in the Resource Repository.
When using one Source and multiple Destinations in the Data Mapper, the actual database operation (such as Insert) is the last operation that is carried out, regardless of the order of the Destinations. This is problematic when you have two tables with a parent-child relationship. Instead, use separate Source-Destination pairs; the first should be the database operation and the second the call flow.
You can continue using the Mapper even when there is no live connection to the database. In other words, you can continue mapping nodes when the database server is not available. When a connection to the database is re-established, the validity is checked again.
When both the Source and Destination are databases, if the Source database contains a Null value in one of its fields, the Null value will be entered into the Destination. See also XMLExist.
Defining a Database in the Resource Repository
Filters for Database
Setting up ODBC Data Sources
Manual Database Configuration
How Do I Create Language Support for the DB2/400 Database?