Siebel Connector for SAP R/3 > Customizing Integrations > Building the Interfaces >

Creating Business Service Data Maps

Business Service Data Maps can be created through the use of eScript or the Siebel Data Mapper. For more detailed information, read Overview: Siebel eBusiness Application Integration Volume I.

Working with eScript

Business Service Data Maps can be created using eScript. These maps can be created and edited within Siebel Tools. The maps must be compiled in the srf file before they can be executed within the Siebel Client or Server applications.

To create a new business service

  1. Open Siebel Tools.
  2. Navigate to Tools > Object Explorer > Business Service.
  3. Select Business Service and right click and choose New Record or Copy Record.
  4. Enter Name, Project, Class "CSSEAIDTEScriptService", Display Name (as you want it to appear) and other Properties. For more information, read Overview: Siebel eBusiness Application Integration Volume I.
  5. Once you have created a business service, you can edit it by right-clicking on the business service record and choosing Edit Scripts.

For more information on eScript and Business Service Data Maps, read Siebel Tools Online Help and Siebel Tools Reference.

Working with Siebel Data Mapper

The Siebel Data Mapper can be used in place of an eScript business service to map fields from one integration object to another. The map is stored in the Siebel Database and does not need to be compiled into the srf.

You can visually map source integration object and target integration object structures using the map design and editor tools. These are available in the Siebel Client by navigating to Integration Administration > Data Maps, Data Map Editor, and Data Map Browser. Under the object level, there are maps at the component and field levels. Siebel Data Mapper uses standard Siebel Query Language as an expression evaluator.

Your map can be executed from workflow by executing the business service EAI Data Transformation Engine. For more information on how to create a map, refer to Overview: Siebel eBusiness Application Integration Volume I.

To create maps

  1. Navigate to Integration Administration > Data Maps.
  2. Create a new record, using the following table as a guide.

    3. Field
    Description
    Example
    Name
    Provide a unique name for this Integration Object map.
    SAP Product map with Siebel Data Mapper
    Source Object Name
    Identify the source object for this map.
    Product - Receive SAP 4x Material (4x IDOC Input) - DDTE
    Target Object Name
    Identify the target object for this map.
    Product - Receive SAP 4x Material (Siebel)

  3. Navigate to Data Maps Editor, and edit Integration Component Maps using the following table as a guide.

    4. Field
    Description
    Name
    Provide a name for this Integration Component map.
    Parent Component Map Name
     
    Source Component Name
    Choose an appropriate component name from the drop-down list.
    Target Component Name
    Choose an appropriate component name from the drop-down list.
    Source Search Specification
    Use to provide an optional component map condition. For information, consult Overview: Siebel eBusiness Application Integration Volume I.
    Precondition
    Use to provide optional error checking. For information, consult Overview: Siebel eBusiness Application Integration Volume I.
    Postcondition
    Use to provide optional error checking. For information, consult Overview: Siebel eBusiness Application Integration Volume I.

  4. Edit Integration Field Maps using the following table as a guide.

    5. Field
    Description
    Source Expression
    Use Siebel Standard Query Language to compose an expression, provide the Source Field Name in the format of [Field Name], or enter a string that you want to assign to the Target Field.
    Target Field Name
    Choose an appropriate name from the drop-down list.

  5. Create a workflow that calls this map. The new business service is called EAI Data Transformation Engine, the method invoked is Execute, and there are three arguments: Map Name, Output Integration Object Name, and SiebelMessage. The Map Name is your new map name.

    6. The first figure shows the Integration Field Maps form (and its fields: Name, Group, Persistence Frequency, Created By, Business Object, Activation Date/Time, Persistence Level, Created, Status, Expiration Date/Time, Error Process Name, and Version). The second figure is the Process Designer with the following steps defined: Start Step, Map IDOC to Siebel DDTE, Sync data to the Siebel application, and End Step.

    Click for full size image

  6. Create new maps between any two integration objects, and then build your new integration point based on your business requirement. For Siebel Data Mapper limitations in this release, read Overview: Siebel eBusiness Application Integration Volume I.

NOTE:  Siebel Connector for SAP R/3 includes a sample map (ReceiveSAP4xMaterial_IDOCToSiebel_DDTE) and a sample workflow (Product - Receive SAP 4x Material (4x IDOC) - DDTE). The sample differs slightly in functionality from the eScript map that performs this function. The "Description" field mapping requires aggregation and sorting features of Siebel Data Mapper, which are not supported by the current release. This may be available in a later release. For now this field is now mapped with empty string.


 Siebel Connector for SAP R/3 
 Published: 22 August 2003