You have multiple actions that you can do: Oracle incremental update, Oracle update … All these functions are still modeled in these knowledge modules. The Integration Knowledge Module allows to choose the data upgrade or integration strategy. These options allow a better data transfer between the source and the target table. One of the most powerful function from ODI is that you can choose the data loading and the Data Integration methodology without using code.įor 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. The Loading Knowledge Module and the Integration Knowledge Module Although each performed module or task can be controlled and customized. Using these components avoids writing many complex lines of code that can lead to syntax errors. In the same time, you can use predefined components that are SQL instructions or script. ![]() The workflow design uses the drag and drop technology. All information is centralized on one location. ![]() The project element window centralizes all components, database connection or workflow you have created for the project. On this picture, you can see that the user interface is split in 3 big windows. The different interfaces are very intuitive and easy to use. Here is an example of data transformation flows. Oracle Data Integrator uses various types of graphical interfaces during all stages of data flow creation. 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. Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |