Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Oct 24, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
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