Seamlessly connect different sources
September 20, 2016

Seamlessly connect different sources

Carlos Sanz Porro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Integrator

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).
  • It connects to any source (database, files, web services) and target.
  • Modify the logic of SQL with knowledge modules.
  • Easy development.
  • 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.
  • Migrating data sources to another technology
  • Developing logic planning and execution
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

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