Oracle Data Integrator 12c: Integration and Administration Ed 3

Course Description

Oracle Data Integrator 12c: Integration and Administration Ed 3 strengthens delivery and support capability in ODI topology, repositories, agents, models, mappings, knowledge modules, load plans, deployment, monitoring, security, and recovery. Learners work within a data engineering team delivering governed batch and near-real-time integrations across databases, files, and analytic platforms, linking configuration and process decisions to security, accuracy, availability, and operational ownership.

The curriculum is arranged around Topology, Agents, Repositories, and Security; Projects, Models, Mappings, and Knowledge Modules; Load Plans, CDC, Data Quality, and Big Data Integration; Deployment, Scheduling, Monitoring, and Recovery. Every stage produces practical evidence, a validation record, troubleshooting notes, and a reusable handover outcome.

What You Will Learn

• Apply master and work repositories, domains, logical schemas, contexts, and physical architecture while working through topology, agents, repositories, and security.
• Validate standalone, JEE, and colocated agents, scheduling services, and connectivity and resolve issues involving repository backup, agent testing, connection diagnostics, and access remediation.
• Apply projects, folders, variables, sequences, packages, and reusable procedures while working through projects, models, mappings, and knowledge modules.
• Validate models, datastores, reverse engineering, keys, constraints, and data quality and resolve issues involving LKM, IKM, CKM, RKM choices, options, generated code, and mapping troubleshooting.
• Apply scenarios, load plans, serial/parallel steps, restartability, and exception branches while working through load plans, cdc, data quality, and big data integration.
• Validate journalizing, subscribers, CDC windows, consistency, and downstream consumption and resolve issues involving file, Hadoop, Spark, and heterogeneous integration patterns with operational controls.
• Apply scenario generation, versioning, smart export/import, and environment promotion while working through deployment, scheduling, monitoring, and recovery.
• Validate schedules, agents, run-time parameters, variables, and dependency sequencing and resolve issues involving restart, rollback, cleanup, repository recovery, and production support handover.

Training Approach

Guided demonstrations, hands-on configuration, scenario analysis, validation checklists, controlled failure testing, troubleshooting, solution review, and a final improvement plan are used throughout Oracle Data Integrator 12c: Integration and Administration Ed 3. Learners document assumptions, settings, outputs, exceptions, corrective actions, rollback needs, and operational responsibilities.