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