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.
Oracle Data Integrator (ODI) Feature Ratings
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