We performed a comparison between Informatica PowerCenter 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 technical support for Informatica PowerCenter is good."
"The setup is very simple."
"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."
"The solution is stable."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The interface is very clean and clear."
"I found the map links, work links, and workflows valuable. They are important features."
"What I like the most is that we have to deal with less while writing the queries."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"I found the initial setup very easy."
"It has a built-in automatic scheduling environment."
"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."
"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."
"The tool supports multiple target update methods."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"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."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"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."
"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."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"No support for change data capture or delta detection - that must be custom coded ."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"Customization could be better."
Earn 20 points
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while WhereScape RED is ranked 44th in Data Integration. Informatica PowerCenter is rated 8.0, while WhereScape RED is rated 8.2. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas WhereScape RED is most compared with Azure Data Factory, SSIS, Matillion ETL, Denodo and Talend Open Studio.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.