Duration
5 days
WHAT YOU WILL LEARN
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements 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) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.
Learn How To:
- Use Oracle Data Integrator to perform transformation of data among various platforms.
- Design ODI mappings, procedures, and packages to perform ELT data transformations.
- Administer ODI resources and set up security with ODI.
- Perform data integration and transformation among various platforms.
- Use the ODI graphical interface to define procedures, packages, and ELT jobs.
- Set up and maintain a secure, multi-user ODI environment.
- Implement changed data capture with ODI.
- Use ODI Web services and perform integration of ODI with SOA.
AUDIENCE
- Administrator
- Analyst
- Architect
- Data Scientist
- Database Administrator
- Implementer
METHODOLOGY
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
OBJECTIVES
- Administer ODI resources and setup security with ODI
- Apply ODI Topology concepts for data integration
- Describe ODI Model concepts
- Describe architecture of Oracle Data Integrator 12c
- Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
- Explore, audit data, and enforce data quality with ODI
- Implement Changed Data Capture with ODI
- Integrate ODI with Version Control Systems (Subversion)
- Extend ODI to include the Big Data Hadoop ecosystem
Programme scope, delivery arrangements and suitability are confirmed during enquiry.