• Understand ODI 12c architecture and E-LT processing.
• Administer ODI repositories and topology.
• Create models, datastores, mappings, procedures, and packages.
• Monitor and troubleshoot ODI mappings and sessions.
• Manage scenarios and load plans.
• Implement data quality and Change Data Capture.
• Apply ODI administration and security practices.
• Integrate ODI with Subversion and Big Data environments.

Module 1: Introduction to Integration and Administration

• Oracle Data Integrator overview
• Data integration concepts
• ODI architecture
• E-LT architecture
• ODI components and their roles
• ODI graphical interfaces
• ODI integration and administration capabilities

Module 2: Administering ODI Repositories

• ODI repositories overview
• Master Repository
• Work Repository
• Repository management
• Repository connections
• Repository administration
• Managing ODI repositories

Module 3: ODI Topology Concepts

• ODI Topology
• Physical architecture
• Logical architecture
• Technologies
• Data Servers
• Physical Schemas
• Logical Schemas
• Contexts
• Agents

Module 4: Physical and Logical Architecture

• Physical architecture concepts
• Logical architecture concepts
• Mapping logical resources to physical resources
• Context-based configuration
• Agent configuration

Module 5: Setting Up a New ODI Project

• ODI projects
• Project organization
• Folders
• Knowledge Modules
• Variables
• Sequences
• User functions
• Procedures
• Project configuration

Module 6: Oracle Data Integrator Model Concepts

• ODI models
• Model architecture
• Technologies and data stores
• Reverse engineering
• Metadata management
• Model organization

Module 7: Organizing ODI Models and Creating ODI Datastores

• Organizing models
• Creating datastores
• Datastore attributes
• Constraints
• Keys
• References
• Journalizing configuration

Module 8: ODI Mapping Concepts

• ODI mappings
• Sources and targets
• Mapping components
• Expressions
• Filters
• Joins
• Lookups
• Connectors
• Staging areas
• Execution locations

Module 9: Designing Mappings

• Creating mappings
• Mapping components
• Data transformations
• Knowledge Modules
• Loading strategies
• Mapping execution
• Mapping validation

Module 10: Mappings – Monitoring and Troubleshooting

• Mapping execution
• Session monitoring
• Operator
• Session logs
• Error analysis
• Troubleshooting failed mappings
• Restarting and managing executions

Module 11: Designing Mappings – Advanced Topics 1

• Advanced mapping components
• Reusable mapping components
• Advanced transformations
• Mapping optimization
• Knowledge Module configuration
• Advanced execution options

Module 12: Designing Mappings – Advanced Topics 2

• Advanced mapping design
• Concurrent execution
• Advanced Knowledge Module options
• Mapping optimization techniques
• Complex transformation scenarios

Module 13: Using ODI Procedures

• ODI procedures
• Procedure steps
• Commands
• Options
• Procedure execution
• Procedure organization

Module 14: Using ODI Packages

• ODI packages
• Package steps
• Variables
• Conditions
• Workflow design
• Branches and loops
• Package execution and monitoring

Module 15: Step-by-Step Debugger

• ODI debugger
• Debugging mappings
• Debugging procedures
• Debugging packages
• Step-by-step execution
• Identifying and resolving errors

Module 16: Managing ODI Scenarios

• ODI scenarios
• Scenario generation
• Scenario execution
• Scenario versions
• Scenario management
• Deployment and execution

Module 17: Using Load Plans

• Load Plan concepts
• Load Plan design
• Serial and parallel execution
• Load Plan steps
• Exception handling
• Load Plan execution and monitoring

Module 18: Enforcing Data Quality with ODI

• Data quality concepts
• Constraints
• Data validation
• Error handling
• Data quality Knowledge Modules
• Monitoring data quality results

Module 19: Working with Changed Data Capture (CDC)

• CDC concepts
• ODI Journalizing
• Changed Data Capture configuration
• Subscribers
• Journalized data
• CDC-based integration workflows

Module 20: Advanced ODI Administration

• ODI administration
• Security
• Users and profiles
• Privileges
• Agents
• ODI Console
• ODI security and administration
• Managing multi-user ODI environments

Module 21: Integrating ODI with Subversion

• Version control concepts
• Subversion integration
• ODI objects and versioning
• Check-in and check-out
• Version management
• Collaborative ODI development

Module 22: Integrating Big Data with ODI

• Big Data integration concepts
• ODI and Big Data
• Big Data Knowledge Modules
• Integrating Big Data technologies with ODI
• Designing ODI integration workflows for Big Data

5 Days

• Configure and administer ODI Master and Work Repositories.
• Configure ODI topology components.
• Configure physical and logical architecture.
• Create and configure an ODI project.
• Create models and datastores.
• Reverse-engineer datastore metadata.
• Create ODI mappings.
• Configure sources, targets, joins, filters, and transformations.
• Configure Knowledge Modules for mapping execution.
• Execute and monitor mappings.
• Analyze mapping and session errors.
• Create and execute ODI procedures.
• Build ODI packages using variables and workflow steps.
• Debug ODI mappings, packages, and procedures.
• Generate and manage ODI scenarios.
• Design and execute Load Plans.
• Configure data quality and validation controls.
• Implement Changed Data Capture using ODI Journalizing.
• Perform ODI administration and security tasks.
• Integrate ODI projects with Subversion.
• Work with ODI capabilities for Big Data integration.

• Certification: Oracle Data Integrator 12c Certified Implementation Specialist
• Exam: Oracle Data Integrator 12c Essentials
• Exam Code: 1Z0-448
• Exam Duration: 120 minutes
• Format: Multiple-choice examination
• Number of Questions: Commonly listed as 79 questions

• Data Integration Developers
• ETL/ELT Developers
• Data Engineers
• Data Warehouse Developers
• Database Administrators
• Data Integration Architects
• Technical Consultants
• System Integrators

• Basic knowledge of databases and SQL.
• Understanding of data warehousing and ETL/ELT concepts.
• Oracle Database experience is recommended.
• Familiarity with WebLogic, Java EE, and operating systems is beneficial.