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 user interface and user experience are perfectly all right."
"The scalability is excellent."
"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 product’s flexibility is valuable."
"It is a scalable and versatile solution."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"This product is easy to install and it can be done in a few hours."
"It's scalable."
"The most valuable feature that we use is the Knowledge Modules."
"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."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The CAEM is very useful in its modularity and portability."
"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."
"The initial setup is easy."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"Provides various ways to secure services as well as providing extensive support."
"The most valuable features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better."
"It's easy to build an integration and make changes to it."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"The out-of-box integration between Oracle and SAP is really beneficial"
"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."
"I would like the stability to improve."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The solution needs better integration with other tools."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The product is not suitable for application integration."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The initial setup is complex, especially if you also have to install a console."
"We used a third party to do the implementation of ODI."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"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."
"The resource management aspect of the solution could be improved."
"Stability could be improved because some operators have issues."
"The error retrying mechanism could be improved. If an error occurs, it can be retried automatically, it would be helpful."
"Now the platform is not built in a way that you can define."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
"Dealing with the large file size has occasionally been a challenge."
"It has lengthy documentation, making the process of building applications more time-consuming."
"We would love to have more and more ready-to-use interfaces from Oracle."
"They need to make tools framework available for implementation partners"
More Oracle Integration Cloud Service Pricing and Cost Advice →