Oracle Data Integrator (ODI) a tool for integrating data. One of the platforms that covers all data integration functions from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator’s Extract, Load, Transform (E-LT) design influences different RDBMS motors to handle and change the information – the approach that advances execution, adaptability and brings down general arrangement cost.
What is ODI
How the Course Will Help
This course will help you to comprehend or take on the idea of ODI model and engineering of Oracle Data Integrator. Through this tool you can take in the utilization of ODI Topology ideas for information combination, Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT information changes. ODI helps to Explore, audit data, and implement information quality. Through this you can take on the administration of ODI assets and how to setup the security. Execute Changed Data Capture with ODI. Utilize ODI Web services and perform reconciliation of ODI with SOA.
How ODI as a tool can benefit the user
Taking this course will show you how to enhance execution and diminish combination costs over your association’s heterogeneous frameworks. You’ll have the capacity to unify information crosswise over databases utilizing your new abilities to perform information coordination, plan ODI Mappings, and set up ODI security. What’s more, Oracle Data Integrator can connect with the different devices of the Hadoop biological community, (for example, Hive, Hbase, HDFS, Oozie, and so forth), permitting administrators and information researchers to allot delineate operations from built up social databases to Hadoop. They can likewise read once more into the social world the aftereffects of complex Big Data examination for further handling.
Who should learn ODI?
On the off chance that you are working in the information Analytics field, and wanting to include new abilities in your portfolio, you can put-on. Any Data researchers, Database Administrators, Business Analysts, Technical Consultants, Data Warehouse Administrators, SOA Architect who need to utilize ODI for information examination, can take in this course.
What is the Prerequisite to learn ODI?
Clients who have the learning of SQL and PL/SQL can add the preferred standpoint to your abilities.
- Introducing ODI Integration
- Managing ODI Repositories
- Concept: Topology
- Architecture : Understanding Physical and Logical Architecture
- Creating and managing project
- Concept: Data Integrator Model
- Creating and Managing ODI Models and ODI Data store
- Concept: Interface
- Designing Interface
- Understanding ODI Procedures and its usage
- Understanding ODI Packages and its usage
- Using ODI Scenarios
- Using Load Plans
- Change data capture