Oracle Data Integrator 12c: Advanced Integration and Development



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Oct 24, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase

Oracle Data Integrator 12c: Advanced Integration and Development

Description: This Oracle Data Integrator course covers advanced techniques for using Oracle Data Integrator 12c (ODI). You learn how to implement high-performance movement and transformation of data among various platforms.

Duration: 3 Days

Learn to:

  • Perform data integration and transformation among various platforms using advance techniques.
  • Design advanced ODI mappings, procedures, and packages to perform EL-T data transformations.
  • Set up ODI security by implementing a strongly secured approach with non-generic profiles and external user authentication.
  • Develop and customize Knowledge Modules with substitution methods and Java.
  • Automate ODI tasks by using the Groovy script editor.
  • Implement integration strategies with ODI by using best practices.
  • Use ODI web services and perform integration of ODI in an enterprise environment and SOA.

  • Business Analysts
  • Data Modelers
  • Database Administrators
  • SOA Architect
  • Technical Consultant
  • Data Warehouse Administrator

Course Objectives:

  • Describe GoldenGate integration
  • Design advanced integration mappings
  • Automate ODI tasks using Groovy
  • Enhance ODI security with strongly secured approach
  • Expose ODI scenarios as web services
  • Integrate ODI in enterprise environment and SOA
  • Describe best practices for implementing integration strategies
  • Describe various ODI integration patterns
  • Develop and enhance Knowledge Modules
  • Describe BigData support

Required Prerequisites:

  • Oracle Data Integrator 12c: New Features

Suggested Prerequisites:

  • Oracle Data Integrator 11g: Integration and Administration
  • Oracle Data Integrator 12c: Integration and Administration


Developing ODI Knowledge Modules

  • Overview of Different Types of KMs
  • Guidelines for KM Developers
  • Working with Substitution Methods
  • Applying Various ODI Tags
  • Implementing Java in KMs
  • Troubleshooting and Debugging KMs

Designing Advanced Integration Mappings

  • Designing Integration Mappings: E-LT and ETL Mappings
  • Selecting LKM and Mono-Connection (Single Technology) IKM
  • Applying Best Practices for Integration Mapping Design
  • Designing Reusable Mappings
  • Implementing Lookups
  • Combining Multiple Datasets
  • Using Set-Based Operators
  • Partitioning ODI Datastores

Using Variables

  • Describing a Variable's Scope
  • Inserting Variables in Object Properties
  • Using Variables within Variables
  • Defining Variables in the Resource Name of a Datastore
  • Applying Variables in Topology Objects
  • Setting Variables as Start Up Parameters
  • Tracking Variables

Using Groovy in ODI

  • Interacting Programmatically with ODI
  • Overview of ODI SDK
  • Introduction to Groovy
  • Using Groovy Editor
  • Automating Development Tasks with Groovy

Using Complex Files

  • What are Complex Files
  • Determining Technical Requirements for Complex Files Project
  • Applying nXSD Schema: an Example
  • Setting up the Topology for Complex Files
  • Creating and Reverse-Engineering a Complex Files Model
  • Designing a Mapping with Complex Files
  • Implementing JSON files

Enhancing ODI Security

  • Overview of ODI Security
  • Best Practices for Enhancing ODI Security
  • Applying Non-Generic Profiles
  • Configuring External Authentication
  • Configuring LDAP for External Authentication with ODI

Integration of ODI in Enterprise Environment

  • Configuring Java EE Agent
  • Monitoring ODI Environment with Enterprise Manager

Integration of ODI in SOA

  • Working with Web Services with ODI
  • Overview of Public Web Services
  • Invoking Web Services from ODI
  • Exposing ODI Scenario as a Web Service
  • Configuring the OdiInvokeWebService Tool
  • Executing an ODI Scenario from a BPEL Process in SOA

Choosing Integration Strategies: Best Practices

  • Selecting Integration Strategies
  • Loading and Integration Patterns
  • Selecting Staging Area Location
  • Working with Slowly Changing Dimensions (SCD)
  • Working with Changed Data Capture
  • Using ODI with Oracle GoldenGate
  • Locate OGG/ODI VM for further research

ODI and Big Data

  • Describe Big Data concepts
  • Contrast Hadoop, NoSQL, Apache, Hive, HBase, HDFS
  • Implement ODI mapping for Big Data to Oracle SQL
  • Locate BigDataLite VM for further research


Right Menu IconMENU