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 features are the metadata repository and the data warehouse application console."
"Informatica PowerCenter is a very good ETL tool."
"I like the automated scheduling feature."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"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."
"It reduces a lot of legacy coding."
"It has good standard features for ETL development."
"I like the completeness of the way I can build ETL workflows."
"The data transformation is the solution's most valuable feature."
"The most valuable feature is connectivity to data sources."
"The user interface and user experience are perfectly all right."
"Mainstream integration and real-time integration are the best features."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"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."
"This product is easy to install and it can be done in a few hours."
"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 scalability is great. It's one of the reasons we chose the solution."
"The installation of the client ODI Studio is easy."
"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."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new 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's most valuable features are it utilizes the database engine and is very lightweight."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"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."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"The product's high costs can be an area of concern where improvements are required."
"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."
"I would like to have easier integration with cloud platforms."
"Integration with the largest number of databases and other systems would be important."
"Pushdown optimization could be improved."
"Should diversify more, maybe with a reporting and visualization utility,"
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"We used a third party to do the implementation of ODI."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Stability could be improved because some operators have issues."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The resource management aspect of the solution could be improved."
"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."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."