We performed a comparison between Informatica PowerCenter and Oracle Integration Cloud Service based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"It has good standard features for ETL development."
"The setup is straightforward."
"Informatica PowerCenter is a very good ETL tool."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Once you have learned Informatica, it is very easy to use."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The initial setup is easy."
"The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive."
"It's easy to build an integration and make changes to it."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"In general, there were a lot of great utilities for working with files."
"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."
"I particularly like the drag-and-drop feature for designing integrations and processes."
"OIC's accuracy is quite good."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"I would like to see it be able to import data from NoSQL."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"The documentation could be improved."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"There is a payload size limit and we're unable to integrate some legacy applications."
"The solution is expensive."
"Now the platform is not built in a way that you can define."
"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"The bulk processing needs improvement."
"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."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 32 reviews. Informatica PowerCenter is rated 8.0, while Oracle Integration Cloud Service is rated 8.0. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Oracle Integration Cloud Service writes "An integration tool that is highly compatible and easy to maintain". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), AWS Glue, Mule Anypoint Platform, Oracle GoldenGate and Boomi AtomSphere Integration. See our Informatica PowerCenter vs. Oracle Integration Cloud Service report.
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.