1. Home
  2. Data Integration Tools
  3. Oracle Data Integrator (ODI) Reviews
  4. User Review of Oracle Data Integrator (ODI)
Data Warehouse Architect's Review of Oracle Data Integrator
Updated November 07, 2017

Data Warehouse Architect's Review of Oracle Data Integrator

Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

Oracle Data Integrator (ODI) is used to integrate applications, bulk data movement and of course to load a data warehouse environment.

ODI helped me to reduce a slowly changing dimension type 2 with the same output, from 22,000 seconds to 168 seconds. [I] Manage to load 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300 GB of data per day.

  • ODI is a tool that can talk or learn how to talk, with any database or operating system in its own language, this is the power of ODI!
  • I managed to connect to an Ingress Database, within 3 days of time (it is not supported out of the box).
  • When a new version of source and/or target database supports new data types, it takes my 5 minutes to implement it into ODI and immediately start using it.
  • Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step.
  • Easy to learn & develop. It takes your 3 days to learn ODI and be an "intermediate ODI Developer", if you know how to write SQL.
  • Big data connectors are implemented since ODI 11.1.1.7 (out-of-the-box) and upper version that support many well-known Big Data architecture.
  • Knowledge Module architecture helps you to build your data integration activities with less effort.
  • They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
  • It made a tremendous job, all the developers across the organisation learnt ODI rapidly and started to develop. ODI became the strategic ETL tool and data integration tool for my company.
Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
  • Data Modeling Tools : Sybase
    Power Designer, SQL Developer Data Modeler, ERwin
    Data Modeler.
  • BI Tools: OBIEE,
    Cognos, Microstrategy,
    Business Objects, Qlikview,
    Tableau.
  • ETL Tools: ODI, OWB, IBM
    Data Stage, SAP Data Services, Informatica, Microsoft SSIS, Pentaho, Talend.
  • You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
  • Variables can help you to perform loops and conditional statements in packages for helping ETL. What else do you need?
  • It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
  • Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.

Oracle Data Integrator (ODI) Feature Ratings

10.0
Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
10.0
Simple transformations
10
Complex transformations
10
9.8
Data model creation
10
Metadata management
10
Business rules and workflow
10
Collaboration
9
Testing and debugging
10
10.0
Integration with data quality tools
10
Integration with MDM tools
10

Using Oracle Data Integrator

50 - Architect and developer.
50 - Knowledge of intermediate SQL language makes an intermediate ODI developer after 2 days of training. Straight forward design and easy to learn.
  • Loading Data Warehouse
  • Performing Data Quality
  • Scheduling
  • On the fly incremental update for different database technologies
  • Fully customized depending on the business needs.
  • Connecting and receiving data from very very old database management systems.
  • Calling operating system routines to output for OLTP tasks.
  • Enhancements in multiuser development environment
ODI is your power to any kind of database, operating system, big data or others.