ETL – ORACLE DATA INTEGRATOR 12c

DURATION:

5 Day Course

COURSE GOALS:

The goals of the ETL Oracle Data Integrator training course are: 

• To understand the architecture, installation and configuration of Oracle Data Integrator. 
• To provide the technical knowledge to develop an ETL, from building the interfaces to defining the load plans, and to monitor an ETL execution with Oracle Data Integrator Studio. 

TARGET AUDIENCE:

• BI Consultants – learn how to develop an ETL with Oracle Data Integrator. 
• IT Consultants  
• IT Project Managers – get an idea of the cost involved in an ETL development to better estimate and manage your BI project. 

PRE-REQUISITES:

Basic ETL knowledge is needed to enrol this course. 

LANGUAGES:

ETL Oracle Data Integrator is offered in English and Spanish (training material is only available in English). 

TOPIC COVERED:

• Architecture: Database schemas, repositories, ELT vs. ETL, declarative design, agents. 
• Installation & Configuration. 
• Repositories Administration. Management of ODI projects.  

• Oracle Data Integrator Studio: Designer (Models, Mappings, Packages, Scenarios, Functions, Procedures). 
• Oracle Data Integrator Studio: Topology Manager (Physical Architecture, Logical Architecture, Contexts, Repositories). 
• Oracle Data Integrator Studio: Monitoring sessions with Operator. 
• Oracle Data Integrator Studio: Managing security. 
• 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. 

RELATED COURSES:

ETL Design

Informatica PowerCenter – Developer

REQUEST MORE INFORMATION

For further information about this course, please fill out the form below.