Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. ODBC connections
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

ODBC Connector

ODBC mapping example

ODBC mapping example

You work in the human resource management team of a manufacturing organization and you need to migrate employee data from DB2 to Informix database. Create a
mapping
task to use the insert operation. You use the following objects in the ODBC mapping:
Source Object
The source object for the
mapping
task is Employee. Use the ODBC connection to connect to DB2 database and read data from the DB2 Employee object. Use the Employee object as a single source in the
mapping
task.
Target Object
The target for the
mapping
task is an Informix table. The target includes the EMPID, EMPNAME, AGE, DOB, DEPTID_EMP, LOCATION, DESIGNATION, and SALARY fields.
Mapping
Map the fields of the Employee source to the Informix target.
The following image shows the ODBC mapping:
The following image shows the mapped fields of the DB2 source with the Informix target object:
When you run the mapping, the agent writes the Employee details to the Informix table.
The following image shows the Employee details that the agent writes based on the fields you mapped in the
mapping
task:

0 COMMENTS

We’d like to hear from you!