We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, and Oracle Data Integrator (ODI) 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 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."
"Deployment was simple and straightforward."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"The ability to scale through partitions helped us to improve the performance."
"The product’s flexibility is valuable."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"Mainstream integration and real-time integration are the best features."
"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."
"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 scalability is excellent."
"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 initial setup is easy."
"It's scalable."
"The product has an ELT approach."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The most valuable feature is Data movement."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"It should be more cloud-centric than on-prem-centric."
"There is some room for improvement in terms of pricing."
"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."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The licensing is difficult."
"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."
"Should diversify more, maybe with a reporting and visualization utility,"
"Technical support can be improved with respect to delays in ticket response time."
"The solution needs better integration with other tools."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"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."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"The initial setup is a bit complex compared to other tools."
"The initial setup is complex, especially if you also have to install a console."
"Reverse engineering is complicated and challenging to manage."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."