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

Topics:

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