Most Helpful Review
Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.
The most valuable feature that we use is the Knowledge Modules.
It's completely user-friendly.
All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
It has the ability to easily load slowly changing dimensions.
The installation of the client ODI Studio is easy.
Besides loading data, we do most of our transformations in ODI.
In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.
The most valuable feature is stability.
All of the components are very independent but are tied together to give the business value.
A product with good API and EDI components.
We can arrange data caching and look at the solid state. Also, the API gateway is a very good component that can handle relevant cachings and integrations, as well as and also load permitting.
It's obvious that the heart of the product lies here. It's comprised of all aspects of ESB (Enterprise Gateway, Adapter, TN, Java) and BPM (task, rules engine).
We have a reusable code that we can replicate for any new interfaces.
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.
The performance of the user interface is in need of improvement.
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.
The stability of the software could be improved. Sometimes, the software just crashes.
Technical support is an area where they can improve.
The price should be reduced to make it more affordable.
The interface needs some work. It is not very user-friendly.
We need more dashboards and reporting engines that can provide detailed information for management. In short, we need better analytics.
t doesn't represent OOP very well, just a method and proprietary interface called IData.
We got the product via a reseller, and the support from the reseller has been less than desirable.
Pricing and Cost Advice
We found that the cost compared to other integration tools is a little high, but the solution works great.
The vendor is flexible with respect to pricing.
The pricing and licensing costs for webMethods are very high, which is the only reason that we might switch to another product.
It is expensive, but we reached a good agreement with the company. It is still a little bit expensive, but we got a better deal than the previous one.
Some of the licensing is "component-ized," which is confusing to new users/customers.
out of 93 in Data Integration Tools
Average Words per Review
out of 25 in ESB
Average Words per Review
Compared 21% of the time.
Compared 16% of the time.
Compared 13% of the time.
Compared 10% of the time.
Compared 7% of the time.
Compared 33% of the time.
Compared 6% of the time.
Compared 5% of the time.
Compared 4% of the time.
Compared 4% of the time.
Also Known As
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.
ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.
The award-winning webMethods Integration Server, our Enterprise Service Bus (ESB), is a complete enterprise application integration solution. It's standards-based so it "speaks" any technology. You can integrate any technology from any vendor: ERP systems, databases, mainframes and legacy apps. SaaS platforms, Web services, JMS messaging systems and packaged apps.
Learn more about Oracle Data Integrator (ODI)
Learn more about webMethods Integration Server
|Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University||Fujitsu, Coca Cola, ING, Credit Suisse, Electrolux, GTA, CosmosDirekt|
Financial Services Firm30%
Software R&D Company53%
Comms Service Provider9%
Software R&D Company17%
Comms Service Provider8%
Software R&D Company44%
Comms Service Provider11%