In this tutorial, you create a simple data mapping in iDev Studio. This tutorial is intended to introduce you to data mapping, primarily how to create a data mapping and link source columns to target columns.

Start iDev Studio and create a new Data Mapping by selecting Create Mapping in the START menu.

This creates a new mapping in the main window.

Select data source in the Connection Explorer and click button Connect.

Select Add Data Object in the Data Mapping menu.

This opens the Add Data Object dialog. Browse the list of data objects or filter them by entering the data object name in the search field. Select data object you want to include in the data mapping.

Select Add Data Object As: Source and click button Add Selected Object. Click button Close to close the dialog.

The data object is added as Source1 in the Outline and Main window.

Add a schema as a Target by selecting Add Schema in the Data Mapping menu.

This opens the Add Schema dialog and shows all schema objects in your workspace(s). Browse the list of schema objects. Select schema object you want to include in the data mapping.

Select Add Data Object As: Target and click button Add Selected Object. Click button Close to close the dialog.

The schema object is added as Target1 in the Outline and Main window.

Column auto-linking automatically connects ports between identical source and target columns. To manually link a column between a source and target, select the source column, and drag and drop it to the target column.

Data Catalog is generated by selecting Refresh in the Data Mapping menu.

View data catalog by clicking on tab Data Catalog in the data mapping main window.