Oracle Data Integrator 12c

I.                   Objectives

This course is focused on the installation and use of the main functionalities of Oracle Data Integrator 12c.

Upon completion of the course, the student will have sufficient knowledge to:

Install the development environment on a computer and configure an external agent.

Create mappings with different data integration methods, including user functions.

Use the most common knowledge modules in ETL processes.

Create procedures, packages, and load plans to carry out a complete data integration.

II. Requirements

SQL knowledge.

Optional:

Knowledge of other ETL tools.

III. Duration

25 hours.

IV.Methodology

The course is developed through theoretical presentation accompanied by practical demonstrations and explanations of the results obtained.

The student carries out the creation of objects (procedures, correspondences, models, topography, etc.) with different data sources, mainly relational (Oracle and MySQL).

Resolution of doubts about the concepts presented.

V. Content

Introduction to Oracle Data Integrator 12c, integration and administration. EL-T approach. Declarative design.

Knowledge modules.

Product installation. Prepare Java environment.

Installation of Middleware and ODI on Linux.

Create Master and Work repository. Using the RCU tool.

Using the ODI user interface and connection to the database.

Topology concepts. Description and creation of physical and logical architectures. Creation of contexts. Data servers and physical schemes. Access to source data and target schemas.Server connection parameters.Creation of logical schemas.Association of logical and physical objects through contexts.

Description and creation of physical and logical agents.Installation of Standalone Collocated Agent.

Topology configuration.

Projects.Project creation.Description of objects: Folders, packages, correspondences, procedures, variables, sequences, user functions, knowledge modules, bookmarks.Organization and scope of projects.Export and import of objects.

Introduction to knowledge modules.

Creation of models.Model folders.Datastore concept.Reverse engineering from relational models.Working with XML sources.Concepts of restrictions and indexes.Primary and foreign keys (references).NOT NULL or mandatory columns.Conditions (check type restrictions).Establish automatic distribution.Establish restriction checkpoint (flow, static).

Verify compliance with restrictions.

Mapping. Basic mappings. Use of different technologies (MySQL > Oracle). Use of Flow Control.

Use of Control Append.

Use of Incremental Update. Use of mapping components: Join, Aggregate, Filter, Lookup…

Specification of the staging area location.

Use of Operator Navigator. Check the execution log. See the sessions, steps and tasks carried out.

Review the code generated by ODI.

Sequences. Types of sequences.

Use of native sequences.

User functions. Scope of use. Implementation. Multiple technologies.

Creating a user function.

Procedures. Procedure description. Creating a procedure. Tasks and properties. Optional commands.

Modifying behavior using options.

Packages.Description.Creating a package.Package diagram panel and tools.Using variables in packages.Updating the value.Verifying and making decisions.

Controlling execution.

Version management.Creating versions in objects.

Comparing changes.

Scenarios.Description.Creating a scenario.

Managing versions in scenarios.

Load plans.Description.

Creating load plans with scenarios.

Change management. Change Data Capture.Description of the CDC system.Implementing and reviewing objects created in the database. Enabling the system.

Creating correspondence with CDC function.