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."It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"UI-based ability to create data mapping."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"We can scale the product."
"The user interface and user experience are perfectly all right."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"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 agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"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."
"It is easy to integrate the solution with other tools."
"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."
"The OIC is very good."
"Technical support responds quickly."
"Provides various ways to secure services as well as providing extensive support."
"The out-of-box integration between Oracle and SAP is really beneficial"
"In general, there were a lot of great utilities for working with files."
"Oracle Integration Cloud Service offers a lot of adaptors."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"It's easy to build an integration and make changes to it."
"The initial setup is not straightforward. You need expertise to do it."
"I would like to see it be able to import data from NoSQL."
"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."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"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."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The product is not suitable for application integration."
"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."
"I would like to have easier integration with cloud platforms."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"The solution's customer service could be better."
"The support and resources were lacking — they weren't there."
"The bulk processing needs improvement."
"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."
"Dealing with the large file size has occasionally been a challenge."
"Configurable timeouts on each connection would be good."
"They should provide tutorials for beginners to learn about the processes."
More Oracle Integration Cloud Service Pricing and Cost Advice →