Oracle Data Integrator (ODI) Reviews

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

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.

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.

There were no issues with the deployment.

We've experienced no issues with performance.

It's been able to scale for our needs.

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.

The possibilities provided by using knowledge modules and the integration with other Oracle products.

The old fashion PL/SQL codes have been translated into ODI, improving the way of maintenance. Several developers can work on the same project easily.

The software is developed on Java so it is very hardware dependent. You will need enough hardware to run the software otherwise you will struggle with it.

I've been using it for the last four years.

There were no issues with the deployment.

When developing on huge internal repositories, the performance is often quite poor.

It's been able to scale for our needs.

I have managed to solve my questions/issues via OTN or forums.

I haven't used any other products.

The first time might look a bit complex but using the right documentation it should be easy to handle.

It was already implemented on the projects where I have worked.

I didn't look at any other similar products.

Strong and reliable ETL tool with high performance and helpful features

Enhance export/import features and add more features (I think they enhanced it in the 12c version)

More than 3 years 11g and now start working with 12c.

Export/import isn't stable and they don't have a clear behavior.

No issues.

Developed a project on SSIS (SQLServer Integration Services), and used to write ETL in scripts (PL/SQL).

Straightforward set-up.

Go ahead it is a very good, stable and reliable product. 

The most valuable features of ODI are the relatively comprehensive ELT features (i.e. execution of data transformation and validation processes), with scheduling.

In our experience with ODI, we've found that the best use of it was with the development of our data warehouse.

There are a couple areas for improvement. First, it needs better error handling (i.e. messages, debugging). Second, it also needs the ability to perform more complex interfaces (i.e. multiple sources to targets).

I've used it for over a year.

There have been no issues with the deployment.

We have had no issues with the stability.

There have been no issues scaling it for our need.

In our experience, technical support is just average.

It is relatively complex for a first-time setup. There is a need to set up separately the RCU configuration of agents, and there's definitely a learning curve to this.

We implemented with our in-house team.

 Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.  Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.  Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.  In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.

 As with any big tool, truly mastering ODI may take months.

 Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target.

The tool has a in-built "Knowledge Modules" using Oracle ADF, and this provides by default, all possible databases and technologies for data integration, such as file system, Oracle RDBMS, Teradata, and Microsoft SQL Server. This ensures that customers do not compromise their requirements and also falls within many companies budget and technical feasibility.

We had a customer whose core business was a logistics suite. ODI was used for their reporting purpose in some key BI reports such as "Container Load Plan (CLP) Reports", "Master Data Management Reports", "Business Partner Reports - Non Shipper Reports ", "Customer Consignee Details Reports". The customers requirements were delivered by using OTM (Oracle Transportation Management) as the Source OLTP System by us. We were also able to integrate ODI with their transactional system and therefore, we generated the reports through an ETL & data warehousing model. Due to this, the customer was able to get a deep-dive insight into their business performance across the south-east Asian logistics industry.

Although we're satisfied with its overall performance in terms of integrity, scalability, and usability, it could be improved by including a separate UI for viewing the session runs through the operator layer of ODI. They could also reduce the complexity of having to move between tabs in the same window.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.