{"id":6235,"date":"2015-11-12T13:29:56","date_gmt":"2015-11-12T12:29:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-the-el-t-tool-from-oracle\/"},"modified":"2015-11-12T13:29:56","modified_gmt":"2015-11-12T12:29:56","slug":"oracle-data-integrator-the-el-t-tool-from-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-data-integrator-the-el-t-tool-from-oracle\/","title":{"rendered":"Oracle Data Integrator \u2013 The EL-T tool from Oracle"},"content":{"rendered":"

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful and that allows the integration of data coming from another sources.<\/p>\n

\"ODI_P1\"<\/a><\/p>\n

\u00a0Agility of use<\/h2>\n

Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. Here is an example of data transformation flows. The different interfaces are very intuitive and easy to use.
\n\"ODI_P11\"<\/a><\/p>\n

On this picture, you can see that the user interface is split in 3 big windows.
\n– The project element
\n– The Workflow design
\n– The Predefined components
\nThe project element window centralizes all components, database connection or workflow you have created for the project. All information is centralized on one location.
\nThe workflow design uses the drag and drop technology. In the same time, you can use predefined components that are SQL instructions or script. Using these components avoids writing many complex lines of code that can lead to syntax errors. Although each performed module or task can be controlled and customized.<\/p>\n

The Loading Knowledge Module and the Integration Knowledge Module<\/h2>\n

One of the most powerful function from ODI is that you can choose the data loading and the Data Integration methodology without using code.
\nFor example you can use an Oracle to Oracle push or pull method for loading the data or you can choose a multi connect or a specific SQL script. These options allow a better data transfer between the source and the target table.<\/p>\n

\"ODI_P12\"<\/a>
\nThe Integration Knowledge Module allows to choose the data upgrade or integration strategy. You have multiple actions that you can do: Oracle incremental update, Oracle update \u2026 All these functions are still modeled in these knowledge modules.<\/p>\n

\"ODI_P13\"<\/a><\/p>\n

The Check Knowledge Module<\/h2>\n

This module is used to check the constraints of the datastore and to create an error table. This module can use the Oracle Check module or a specific SQL script.<\/p>\n

\"ODI_P14\"<\/a><\/p>\n

Powerful tool<\/h2>\n

Each operation on data such as select, create, lookup, … have been integrated into the modules, thus avoiding to write many complex lines of code that can lead to syntax errors. Although each performed module or task can be controlled and customized.<\/p>\n

\"ODI_P3\"<\/a><\/p>\n

In addition, ODI uses a very powerful debugger tool that allows checking each task from the data transform process.<\/p>\n

\"ODI_P4\"<\/a><\/p>\n

Many external data sources access<\/h2>\n

A good ETL tool must now connect to most database or data types that exist on the market. That’s why ODI provides access to a many database, including big data, making it one of the most connected tools on the market.<\/p>\n

\"ODI_P5\"<\/a>\"ODI_P5Bis\"<\/a><\/p>\n

E-LT, the Business Intelligence 2.0<\/h2>\n

ODI is based on a new technological concept called E \u2013LT (Extract \u2013 Load, Transform). Most of the data integration tools use the technology ETL (Extract – Load – Transform) In other terms, the data first have to be extracted from their base and copied in a temporary database. Then in a second time, data are transformed and stocked in the real data warehouse. These processes cost time, RAM and CPU.<\/p>\n

The E-L.T. technology changes the processes sort. It takes advantages from the hardware and software technologies used in the source and target database. The data is extracted and directly copied in the data warehouse. The data transform processes are directly made on the data located in the data warehouse. This new process avoids another data transfer that cost time. At least, this technology allows refreshing frequently the data because we can choose the dataflow we want to update.<\/p>\n

\"ODI_P6\"<\/a><\/p>\n

Classical ETL schema\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 E-LT schema<\/p>\n

\"ODI_P7\"<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"ODI_P8\"<\/a><\/p>\n

Oracle Data Integrator and Oracle Golden Gate<\/h2>\n

More and more customer\u2019s solutions are using Oracle Golden Gate and Oracle Data Integrator at the same time. What advantages do we have to use these two technologies together?<\/p>\n