Basic concepts of Oracle-ODI

Odi: Oracle Data Integrator

Oracle Data Loading tool.

Oracle Odi, like owb, is a data extraction/Data Conversion Tool designed using the concept of E-LT.

　　The biggest feature of ODI is the concept of a knowledge module ).

Odi Loads files to the database, captures data from the MySQL database, stores data in the Oracle database, and captures data from DB2 in the Oracle database) the detailed implementation steps are recorded as one knowledge module and recorded step by step using Jython script language combined with database SQL statements, in this way, more than 100 knowledge modules in ODI are formed, basically including all the scenarios involved in common applications. More conveniently, users can directly use the knowledge module of Odi to obtain data, or customize the knowledge module, for example, in a business scenario, a specific step in the knowledge module may not be required, so you can directly Delete the step to provide better performance. Of course, you can develop these knowledge modules on your own.

Odi knowledge module Classification

The knowledge modules of Odi are mainly divided into several categories (rkm, CKM, lkm, ikm, and SKM), among which the most important are lkm (load km) and ikm (integration km) rkm:

Rkm completes reverse engineering of the data structure of the source and target systems to form a data model.

CKM: CKM completes data quality check.

Jkm: the logging knowledge module that records new data and updated data in a single table or view.

Lkm: lkm loads data from the source database to a temporary table.

Ikm: ikm loads data from a temporary table to the target table.

SKM: SKM provides the ODI and web service interfaces.

SKM (Service km): Web Service knowledge module, which can be used to generate Web service calls.

Edit other ODI features in this section:

1. Heterogeneous Data: when the data source or target is not an Oracle database, Odi can generate native SQL statements for that data source.

2. Real-time Data Integration Environment: ODI can detect events. An event can trigger an interface flow of Odi. This completes near-real-time data integration.

3. Data Extraction and integration can be integrated with SOA. Odi itself provides the call web service mechanism, and the ODI interface can also be exposed as WebService, it can interact with the SOA environment.

4. supports consistent CDC (Change Data Capture). different data sources (such as Oracle and DB2) provide different technical frameworks for acquiring changed data, odi shields these different technical frameworks, provides a unified CDC setting framework in a unified interface mode, and provides the subscriber function.