Oracle Data Integrator (ODI) Reviews

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.