ETL – ORACLE DATA INTEGRATOR 12c

Todos nuestros cursos pueden ser impartidos en Español. Sin embargo, no podemos garantizar que dispongamos de todos los materiales lectivos en dicho idioma.

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. 

REQUEST MORE INFORMATION

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