【转载】BI_EAI_DataMapping.ppt

Module 18: Data Mapping with Scripts Module Objectives After completing this module you will be able to: Describe the types of integration situations that require data transformation by scripts rather than by the declarative DTE Create a business service containing a custom script to transform data between a Siebel application and an external application Write code to access input and create output integration object and XML Hierarchy instances Create EAI Value Maps and use them with the EAIGetValueMap and Translate methods Use exception handling functions in data mapping scripts Why you need to know You may need to write custom scripts for data transformation between a Siebel application and an external application When to Use Scripts for Data Mapping There are no integration objects to represent external metadata To aggregate or index multiply-occurring components To map two or more source components, with non-trivial relationships, to the same target component To exercise programmatic control Example: Using if/then or case statement logic Data Transformation Tasks In Siebel Tools: Create integration objects Siebel integration objects to represent Siebel data External integration objects to represent external data Create a business service to hold the data transformation code Write the data transformation eScript code Use Siebel data transformation functions to build maps that: Transform incoming external data into the Siebel structure Transform outgoing Siebel data into the external systems structure Create Integration Objects Create a Siebel integration object based on a business object Use the Integration Object Builder with the EAI Siebel Wizard Create an external integration object based on a document type definition (DTD) from the external application Use the Integration Object Builder with an EAI wizard For XML: EAI DTD Wizard – requires DTD of external XML Create a Business Service In Siebel Tools: Create a new business service Set the Project prope