Cours pré-requis
Connaissances des ETL data processing
Connaissance du langage SQL
Description 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.
This offering details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.
Objectifs
Décrire l'architectureOracle Data Integrator 11G
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Explore, audit data, and enforce data quality with ODI
Administer ODI resources and setup security with ODI
Implement Changed Data Capture with ODI
Use ODI Web services and perform integration of ODI with SOA