Item: Oracle Data Integrator (ODI)
Rating: 9
Author: Carlos Sanz Porro

Overall Satisfaction with Oracle Data Integrator

Use Cases and Deployment Scope

We are currently using ODI for large companies that have the need to generate and consolidate information, move data, transform and consolidate data.

The great quality of ODI, is that it is able to connect to any database and source (xml , txt, SOZ ) both source and target. ODI is all possible, we have not seen in the position of a customer asks us something that ODI can not do . Thanks to that we can modify its core, we can do anything.

ODI allows the multidisciplinary development, its own versioning, and integration with any language (Python , Groovy , t - SQL).

Pros and Cons

Pros

It connects to any source (database, files, web services) and target.
Modify the logic of SQL with knowledge modules.
Easy development.

Cons

The product sometimes have small bugs, which are fixed with patches.
Very complex queries are difficult to do in graphics mappings
It has functionality versions but can not develop in parallel a same object.

Return on Investment

Migrating data sources to another technology
Developing logic planning and execution

Other Software Used

Oracle Warehouse Builder, Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Oracle BI Foundation Suite

Likelihood to Recommend

Oracle Data Integrator (ODI) is recommended when you want to move data from heterogeneous sources. Also the multidisciplinary development is appropriate because when an object is being used, it appears locked by another user. ODI is a mature tool on the market.

A developer without advanced knowledge of SQL, can easily use the tool and generate complex queries against the database.

Oracle Data Integrator (ODI) Feature Ratings

Comments

Please log in to join the conversation

Seamlessly connect different sources