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 most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"Deployment was simple and straightforward."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"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 has good standard features for ETL development."
"It reduces a lot of legacy coding."
"Good interface, reasonable documentation."
"It's a complete package, which is why we use this solution."
"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."
"Data transformations and rollups are easy to accomplish."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"The most valuable feature is the metadata generated code."
"The tool supports multiple target update methods."
"I found the initial setup very easy."
"Support is absolutely excellent, efficient, and timely."
"Lacks ability to calculate cost of the product."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"I would like to see it be able to import data from NoSQL."
"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."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"It should be more cloud-centric than on-prem-centric."
"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."
"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."
"Customization could be better."
"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)."
"Technical support isn't the best."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
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, Talend Open Studio and Denodo.
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.