際際滷

際際滷Share a Scribd company logo

Oracle Data Integration Presentation

K
kgissandaner

Oracle Data Integrator is an ETL tool that has three main differentiators: 1) It uses a declarative, set-based design approach which allows for shorter implementation times and reduced learning curves compared to specialized ETL skills. 2) It can transform data directly in the existing RDBMS for high performance and lower costs versus using a separate ETL server. 3) It has hot-pluggable knowledge modules that provide a library of reusable templates to standardize best practices and reduce costs.

1 of 19
Oracle Data Integrator Keith Gissandaner Senior Principal Consultant
Differentiator: E-LT Architecture High Performance Transform in Separate ETL Server Poor Performance High Costs Proprietary Engine Transform in Existing RDBMS Proprietary Language High Performance Easier to Manage & Lower Cost Leverage RDBMS Native SQL
Differentiator: Declarative Design Developer Productivity & Conventional ETL Design Specialized skills Maintainability & maintenance Significant development efforts Declarative Set-based Design Necessity to define each step Shorter implementation times of Complex ETL Flow Logic Significantly reduced learning curve Simplified number of steps Automatic Data Flow generation
Knowledge Modules Hot-Pluggable: Modular, Flexible, Extensible Library of hot-pluggable templates Open and extensible Declarative set-based mapping Tailor to existing best practices Reduce cost of ownership
Oracle Data Integration Presentation
Topology
Oracle Data Integration Presentation
Oracle Data Integration Presentation
Designer Reverse Engineering
Oracle Data Integration Presentation
Add a Project
Oracle Data Integration Presentation
Execution Tab for Interface shows Status and information
Operator
Oracle Data Integration Presentation
Oracle Data Integration Presentation
Oracle Data Integration Presentation
Additional ODI Information http://www.oracle.com/technology/product s/oracle-data-integrator/index.html 4 Day Training Course through Oracle University
Questions

More Related Content

Oracle Data Integration Presentation

  • 1. Oracle Data Integrator Keith Gissandaner Senior Principal Consultant
  • 2. Differentiator: E-LT Architecture High Performance Transform in Separate ETL Server Poor Performance High Costs Proprietary Engine Transform in Existing RDBMS Proprietary Language High Performance Easier to Manage & Lower Cost Leverage RDBMS Native SQL
  • 3. Differentiator: Declarative Design Developer Productivity & Conventional ETL Design Specialized skills Maintainability & maintenance Significant development efforts Declarative Set-based Design Necessity to define each step Shorter implementation times of Complex ETL Flow Logic Significantly reduced learning curve Simplified number of steps Automatic Data Flow generation
  • 4. Knowledge Modules Hot-Pluggable: Modular, Flexible, Extensible Library of hot-pluggable templates Open and extensible Declarative set-based mapping Tailor to existing best practices Reduce cost of ownership
  • 13. Execution Tab for Interface shows Status and information
  • 18. Additional ODI Information http://www.oracle.com/technology/product s/oracle-data-integrator/index.html 4 Day Training Course through Oracle University