| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| May 6, 2024 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $5,000 USD | Purchase |
| Aug 12, 2024 | 11:00 | 07:00 | EDT | Live Virtual Class | 5 | $5,000 USD | Purchase |
| Nov 4, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 5 | $5,000 USD | Purchase |
Oracle Data Integrator 12c: Integration and Administration
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 (ELT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.
Duration: 5 Days
Prerequisites
- Basic knowledge of ELT data processing
- Working knowledge of SQL (suggested)
Audience
- Business Analysts
- Data Modelers
- Data Warehouse Administrators
- Database Administrators
- SOA Architects
- Technical Consultants
Learning Objectives
- Describe ODI Model concepts
- Apply ODI Topology concepts for data integration
- Design ODI mappings, procedures, packages, and load plans to perform ELT data transformations
- Explore, audit data, and enforce data quality with ODI
- Administer ODI resources and setup security with ODI
- Set up and maintain a secure, multi-user ODI environment
- Implement change data capture with ODI
- Use ODI Web services and perform integration of ODI with SOA
Topics
- Administering ODI Repositories and Agents
- ODI Topology Concepts
- Describing the Physical and Logical Architecture
- Setting Up a New ODI Project
- Oracle Data Integrator Model Concepts
- Organizing ODI Models and Creating Data Stores
- ODI Mapping Concepts
- Designing Mappings
- Mapping: Monitoring and Debugging
- Designing Mappings: Advanced Topics
- Creating and Running ODI Procedures
- Creating and Running ODI Packages
- Managing ODI Scenarios and Versions
- Enforcing Data Quality and Auditing Data with ODI
- Working with Changed Data Capture
- Administering ODI Resources: Advanced Topics
- Creating Web Services and Integration of ODI with SOA
- Extending ODI with the SDK
- Creating Web Services and Integration of ODI with SOA
- Extending ODI with the SDK
