Open the Transformation Developer.

Or, open the Mapping Designer.

Click Transformation > Create.

The Create Transformation dialog box appears.

Select Siebel EIM Read transformation from the list.

Enter a name for the transformation.

Click Create.

The wizard appears.

Enter the connection parameters.

The following table describes the connection parameters:

For more information about the connection parameters, contact your Siebel system administrator.

Click Connect to connect to Siebel.

Click Next.

To view the list of all EIM tables in Siebel, select EIM Tables in the Based on list.

Or, to view a list of Siebel base tables and corresponding EIM tables, select Base Tables in the Based On list.

Optionally, enter a filter condition to view particular Siebel base or EIM tables that meet the filter condition.

If the sort order of the database is case-sensitive, specify the EIM or base table name in uppercase letters.

Click Show Objects.

EIM tables appear if they are active in Siebel.

Select a base table to select all the corresponding EIM tables that you want to import.

Optionally, select an EIM table from the list of EIM tables.

The Table Fields area displays information about the selected EIM table.

Click Next.

Enter a name for the transformation.

If you use the Create Transformation dialog box to create the transformation, the transformation name specified in the Create Transformation dialog box overwrites the transformation name specified in the wizard.

Click Finish.

Click Done.