Glasspaper er Oracle Approved Education Center i Norge


Oracle Data Integrator 12c: Advanced Integration and Development

Kursavgift: kr 21 250 | Varighet: 3 dager

Beskrivelse:

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.
This course is based on Oracle Data Integrator 12c (12.1.3).

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.

Målgruppe:

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

Practical information


Our Oracle courses is conducted at the following hours:
  • Monday to Friday: 09.00 – 16.00

Course material
We use official Oracle material in our Oracle trainings. This include eKit (electronic documentation) and Lab environment from Oracle University.



Forkunnskaper:

Required Prerequisites
  • Students should have attended Oracle Data Integrator 12c: Integration and Administration, or have similar work experience


Innhold:

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 Variables 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

Read complete course description: Oracle Data Integrator 12c: Advanced Integration and Development




Epost mottat


Du er nå meldt på nyhetsbrevlisten

Epost mottat


Du er nå meldt på nyhetsbrevlisten

Mailen er sendt:

Ditt tips er registrert og sendt!
Vi håper snarlig å se deg på kurs hos oss!

Feilmelding:

OBS! Vi har problemer med å sende ditt tips!

Vi anbefaler deg å sjekke om du har skrevet inn en gyldig mailadresse.

Tips sjefen

Lyst til å delta på dette kurset, men må overbevise sjefen først?

Glasspaper har laget en tips funksjon, som gjør det enklere for deg å overbevise din sjef om at dette kurset er perfekt for deg.
Det eneste du trenger å gjøre er å fylle ut kontaktinformasjon, så sender vi relevant informasjon om kurset rett til dine utvalgte kontaktpersoner.
Bruk gjerne funksjonen til å tipse venner og kollegaer om at dette er et nyttig kurs for dem





Kontakt oss

Product Manager Oracle

Karin Sørensen

932 10 626

itpro@glasspaper.no


Glasspaper er kåret til Årets Microsoft Kurspartner 2017 - dette er åttende år på rad vi mottar denne hedersprisen