We performed a comparison between Oracle Data Integrator (ODI) and Oracle Warehouse Builder [EOL] based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It has the ability to easily load slowly changing dimensions."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"OpenAPI supported me integrating Oracle Warehouse Builder with DevOps solutions like versioning (CVS, Subversion, and Git), ticket systems (Bugzilla and Jira), and test automatization (HPQC) as well as with professional ALM solutions (HP ALM and IKAN ALM)."
"The initial setup is complex, especially if you also have to install a console."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The performance of the user interface is in need of improvement."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"Unfortunately, a next release of Oracle Warehouse Builder will not happen but a wide range of customers still use the available features together with the current Oracle 11g or 12c database environments."
More Oracle Warehouse Builder [EOL] Pricing and Cost Advice →
Earn 20 points
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Oracle Warehouse Builder [EOL] doesn't meet the minimum requirements to be ranked in Data Integration. Oracle Data Integrator (ODI) is rated 8.2, while Oracle Warehouse Builder [EOL] is rated 7.0. The top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". On the other hand, the top reviewer of Oracle Warehouse Builder [EOL] writes "Can be enhanced with extra functionality, but no further support will be given for the solution". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate, whereas Oracle Warehouse Builder [EOL] is most compared with .
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.