Business Processes and Rules: Siebel Enterprise Application Integration > Data Mapping Using Scripts >


You can accomplish your data transformation requirements in Siebel Business applications by using the Data Transformation Function or Siebel Data Mapper, as illustrated in Figure 10.

Figure 10. Data Transformation Options

For customers who want to do data mapping within Siebel applications, Siebel applications now support two data mapping solutions—Siebel Data Mapper and Siebel eScript Data Mapping. Siebel Data Mapper has a declarative interface and requires no programming skills. Siebel eScript Data Mapping uses scripts programmed in eScript as data maps.

Data maps defined using Siebel Data Mapper are easy to maintain and upgrade. These maps also perform better than eScript Data Maps. Because Siebel Data Mapper is based on a declarative interface, it does not have the full flexibility and power that the data mapping using eScript has. Siebel Data Mapper should suffice for most integration needs except some complex mapping situations requiring aggregation, joins, or programmatic flow control.

The following checklist outlines the main steps required to accomplish your data transformation requirements using the Data Transformation Functions.



Define integration objects in Siebel Tools—one to represent Siebel objects and another to represent external data.

For details, see Integration Platform Technologies: Siebel Enterprise Application Integration.


Set up the Data Transformation Map.

For details, see Setting Up a Data Transformation Map.


Write the Siebel eScript code to perform the data transformation.

For details, see To write a script for DTE business service.

Business Processes and Rules: Siebel Enterprise Application Integration Copyright © 2006, Oracle. All rights reserved.