Oracle Enterprise Service Bus
This section provides an introduction and the methodology to work with the ESB Cross-References Knowledge Modules in Oracle Data Integrator.
Cross-referencing is the Oracle Fusion Middleware Function, available through its Enterprise Service Bus (ESB) component, and leveraged typically by any loosely coupled integration, which is truly built on the Service Oriented Architecture. It is used to manage the runtime correlation between the various participating applications of the integration.
The Cross-referencing feature of Oracle SOA Suite enables you to associate identifiers for equivalent entities created in different applications. For example, you can use cross-references to associate a customer entity created in one application (with native id Cust_100) with an entity for the same customer in another application (with native id CT_001).
Cross-reference (XRef) facilitates mapping of native keys for entities across applications. For example, correlate the same order across different ERP systems.
The implementation of cross-referencing uses an Oracle database schema to store a cross-reference table (called XREF_DATA) that stores information to reference records across systems and data stores.
The optional ability to update or delete source table data after the data is loaded into the target table is also a need in integration. This requires that the bulk integration provides support for either updating some attributes like a status field or purging the source records once they have been successfully processed to the target system.
ESB Cross-References Knowledge Modules
The ESB Cross-References Knowledge Modules (KMs) are certified with Oracle ESB 10g. Oracle Data Integrator provides three Knowledge Modules for handling ESB cross-references:
LKM SQL to SQL (ESB XREF)
This KM supports cross-references while loading data from a standard ISO source. It supports both Oracle and DB2.The LKM SQL to SQL (ESB XREF) has to be used in conjunction with the IKM SQL Control Append (ESB XREF) in the same interface.
LKM MSSQL to SQL (ESB XREF)
This KM is a version of the LKM SQL to SQL (ESB XREF) optimized for Microsoft SQL Server.
IKM SQL Control Append (ESB XREF)
This KM provides support for cross-references while integrating data to an Oracle, DB2 or Microsoft SQL Server target. It integrates data to the target table in truncate/insert (append) mode, and supports data checks.
Knowledge Modules Reference Guide