Szkolenia Oracle

Cel szkolenia szkolenie zdalne - dlearning

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. 

Learn how to: 

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

Benefits to You: 

Improve performance and reduce integration costs across your organizations' heterogeneous systems. Centralize data across databases using your new skills to perform data integration, design advanced ODI mappings, set up ODI security, and automate ODI tasks.

Administering the IT infrastructure and Metadata

 This course helps you learn how to use the ODI Studio for developing projects and models. Expert Oracle instructors will also explore how to monitor executions through instruction and hands-on exercises.

Advanced ODI development for High-Performance Data Integration

 In addition, this course teaches you how to perform advanced ODI topology configuration. Learn how to design advanced ODI mappings, procedures, packages, and other objects for high-performance data integration among various technologies.

Perform Extract Load Transform (EL-T) in an Enterprise Environment

 For enterprise SOA deployments, there is almost always a need for enterprise data extraction, transformation, and loading. By leveraging the native SOA architecture in Oracle Data Integrator, this course helps you perform EL-T from SOA applications.

You also learn how to implement the integration of ODI in an enterprise environment and in SOA. In addition, this course teaches you how to execute ODI transformation from a BPEL process.

Apply Strongly Secured Approach

 Taking this course helps you learn how to enhance ODI security by applying the Strongly Secured Approach and by implementing External Authentication with LDAP.

 Finally, you learn about cubes and dimensions and how to use and populate them in ODI.

This course is based on Oracle Data Integrator 12c (


  • 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

Plan szkolenia Rozwiń listę

  1. Introduction
  2. Overview of Oracle Data Integrator
  3. ODI Knowledge Modules: Overview
  4. ODI Knowledge Modules: Overview
  5. Working with Knowledge Modules
  6. Developing Knowledge Modules
  7. Developing Knowledge Modules
  8. Developing Knowledge Modules: Best Practices
  9. Using Java in KMs
  10. Using Substitution Methods: Code Examples
  11. Troubleshooting Knowledge Modules
  12. Designing ODI Integration Mappings
  13. Integration Process: Overview
  14. Integration Mappings: Overview
  15. Designing Integration Mappings: Best Practices
  16. Maintaining Integrity of Data
  17. Designing Advanced Integration Mappings
  18. ODI Mappings: Advanced Functionality
  19. Partitioning
  20. Reusable Mappings
  21. Using Variables in ODI
  22. Using Variables: Overview
  23. Using Variables in ODI Objects
  24. Tracking Variables
  25. Accelerating Development with Groovy
  26. Interacting Programmatically with ODI
  27. Using Groovy Editor
  28. Performing SDK Tasks Using Java with Groovy Editor
  29. Working with ASCII Files
  30. Complex Files Concepts: Overview
  31. Complex Files: Configuring the Topology
  32. Complex Files in Integration Projects
  33. Integration of ODI in Enterprise Environment and SOA
  34. ODI Integration with Java EE
  35. Using Web Services with ODI: Overview
  36. Invoking Web Services
  37. Integration of ODI with SOA
  38. Enhancing ODI Security
  39. ODI Security: Overview
  40. Implementing a Strongly Secured Approach
  41. Security Integration
  42. Configuring ODI External Authentication
  43. Choosing Integration Strategies: Best Practices
  44. Defining an ODI Integration Strategies
  45. Strategies with Staging Area on the Target
  46. Strategies with Staging Area Different from the Target
  47. Using ODI for Bulk Processing
  48. Real-Time Data Integration: Using ODI with Oracle GoldenGate
  49. Working on ODI Projects: Best Practices
  50. Cubes and Dimensions
  51. Overview of Dimensions
  52. Overview of a Cube
  53. Create Dimensions
  54. Create Cubes
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Suggested Prerequisite:

  • Oracle Data Integrator 12c: Integration and Administration Ed 2
Poziom trudności
Czas trwania 3 dni

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.


Autoryzowany wykładowca Oracle.

Pozostałe szkolenia Oracle | Application Development

Szkolenia powiązane tematycznie


Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.


Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle