Oracle Data Integrator (ODI) Review

It has made it possible for our organization to rapidly build robust integration. There are no tools/dashboards to monitor/administrate this in-memory database.


Valuable Features:

The ability to build integrations that process large amounts of data (in GBs), be it file transfers ,DB operations, and web service calls, etc.

Improvements to My Organization:

ODI has made it possible for our organization to rapidly build robust integrations that process large data. The learning curve of this technology is also very smooth and can be picked up by any one with minimal programming experience.

Room for Improvement:

ODI's "in-memory RDBMS" is still a black box for programmers as there are no tools/dashboards to monitor/administrate this in-memory database. As a result, inconsistent data processing issues generally force us to restart the ODI server.

Deployment Issues:

There were no issues with the deployment.

Stability Issues:

We've experienced no issues with performance.

Scalability Issues:

It's been able to scale for our needs.

Other Advice:

The product may not be as evolved as Informatica, but still has a lot to offer in the Fusion Middleware Product Suite. Keeps all the promises of an ETL/ELT tool, but when it comes to Administration and maintenance the product still leaves a lot to be desired.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partners
Add a Comment
Guest

Sign Up with Email