Oracle Data Integrator streamlines the high performance movement and transformation of data between heterogeneous systems in batch, real time, synchronous, and asynchronous modes; it dramatically enhances user productivity with an innovative, modularized design approach and built-in connectivity to all major databases, data warehouse appliances, analytic applications and SOA suites. The course aims at providing insight into Oracle Data Integrator Architecture and in developing and deploying data integration interfaces using Oracle Data Integrator.
- Describe architecture of Oracle Data Integrator
- Work with Topology Navigator, Security Navigator, Designer and Operator Navigator
- Understand ODI Topology and create logical and physical architecture for Data Integration
- Describe ODI Model concepts
- Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations
- Understand and work on different Knowledge Modules for integration of data between heterogeneous applications
- Setup security with ODI
- Administer ODI Repositories and Agents
- Explore, audit data, and enforce data quality with ODI
- Implement Changed Data Capture with ODI
- Use ODI Web services and perform integration of ODI with SOA