We performed a comparison between Informatica PowerCenter and WhereScape RED based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The setup is straightforward."
"The most valuable features are the monitoring tools and the reporting manager."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It has a Data Catalog that uses the Model repository."
"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."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The tool supports multiple target update methods."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"It has a built-in automatic scheduling environment."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"Data transformations and rollups are easy to accomplish."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"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."
"The initial setup is not straightforward. You need expertise to do it."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Requires an established data center because there is no option for software as a service."
"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."
"Improve the object renaming ability (it works, but it could be more automated)."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"Technical support isn't the best."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
Earn 20 points
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while WhereScape RED is ranked 48th 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 Informatica PowerCenter vs. WhereScape RED report.
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.