We performed a comparison between Informatica PowerExchange, Oracle Data Integrator (ODI), and Oracle Integration Cloud Service based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"Provides a significant amount of control over the landscape and overall implementation."
"It is easy to integrate the solution with other tools."
"This product is easy to install and it can be done in a few hours."
"The most valuable feature is connectivity to data sources."
"It is a scalable and versatile solution."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The most valuable feature that we use is the Knowledge Modules."
"The initial setup is easy."
"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."
"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."
"It's completely user-friendly."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The most valuable feature of Oracle Integration Cloud Service is its performance."
"The OIC is very good."
"It is a scalable solution."
"OIC's accuracy is quite good."
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"OIC offers a number of pre-built technology and SaaS adapters for high productivity for a wide range of target systems, both in-house via agents and cloud/SaaS, via a very flexible range of interfaces."
"Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."
"The product is not suitable for application integration."
"Integration with the largest number of databases and other systems would be important."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"Technical support can be improved with respect to delays in ticket response time."
"Should diversify more, maybe with a reporting and visualization utility,"
"I would like the stability to improve."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The initial setup is complex, especially if you also have to install a console."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"Reverse engineering is complicated and challenging to manage."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"They need to make tools framework available for implementation partners"
"Dealing with the large file size has occasionally been a challenge."
"Configurable timeouts on each connection would be good."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"Oracle Integration Cloud Service can improve the downloading and uploading of files. I've submitted this issue to the Oracle Idea Labs. The issue is from the front end of Oracle Integration Cloud, we cannot download or upload a file directly or drag and drop it."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."
"We would love to have more and more ready-to-use interfaces from Oracle."
More Oracle Integration Cloud Service Pricing and Cost Advice →