We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, 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 most valuable features are the metadata repository and the data warehouse application console."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"It reduces a lot of legacy coding."
"The setup is very simple."
"I like the automated scheduling feature."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"What I like the most is that we have to deal with less while writing the queries."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"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."
"The data transformation is the solution's most valuable feature."
"The product’s flexibility is valuable."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"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 user interface and user experience are perfectly all right."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"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."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"In general, there were a lot of great utilities for working with files."
"The most valuable feature is the ease of customization."
"The solution is scalable."
"People are able to scale up, learn it quickly, and start delivering."
"The reputation of Informatica is that it is expensive."
"The initial setup is not straightforward. You need expertise to do it."
"Support could be better."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"They should release new versions for the solution's on-premises setup."
"I would like to have easier integration with cloud platforms."
"The solution needs better integration with other tools."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The connectivity with T24 core banking could be improved."
"The product is not suitable for application integration."
"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."
"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."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"Lacks features for more complex integrations."
"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."
"Oracle Integration Cloud Service can improve file handling. Currently, our real-time file polling limitation is 10 MB, if that size can be increased it would be helpful. For example, increasing the size from 10 MB to 1 GB."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"Configurable timeouts on each connection would be good."
"The solution's customer service could be better."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"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."
More Oracle Integration Cloud Service Pricing and Cost Advice →