Develop ELT with Oracle Data Integrator

Value Beyond Technology

Ultimo Software Solutions is a valued Enterprise Application service provider that assists leading business organizations to deploy IT solutions ensuring long-term success in SOA, EAI, B2B, BPM, AJAX Rich Internet Applications, and User Interfaces.

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.

Objectives
  • 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
Course Duration

3 days