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 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."
"The number of docs has been reduced drastically, which is very good."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It has a Data Catalog that uses the Model repository."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"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."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Naturally produces a way to easily debug your DW data solutions."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"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."
"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."
"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 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."
"Support is absolutely excellent, efficient, and timely."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"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."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Lacks ability to calculate cost of the product."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"They should release new versions for the solution's on-premises setup."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"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."
"Improve the object renaming ability (it works, but it could be more automated)."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"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."
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.