We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The product's initial setup phase is very easy."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It reduces a lot of legacy coding."
"Can manage a huge quantity of data and provide reliability."
"UI-based ability to create data mapping."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"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."
"The most valuable features are the metadata repository and the data warehouse application console."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"This product is easy to install and it can be done in a few hours."
"It is easy to integrate the solution with other tools."
"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 product’s flexibility is valuable."
"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."
"The most valuable feature is connectivity to data sources."
"Data transformations and rollups are easy to accomplish."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The most valuable feature is the metadata generated code."
"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."
"Integrating new tools can be tricky and challenging."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The performance of Informatica PowerCenter could improve."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"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."
"Pushdown optimization could be improved."
"Technical support can be improved with respect to delays in ticket response time."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"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."
"Should diversify more, maybe with a reporting and visualization utility,"
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
"No support for change data capture or delta detection - that must be custom coded ."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
Earn 20 points