We performed a comparison between 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 was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The most valuable feature is connectivity to data sources."
"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 transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"It is a scalable and versatile solution."
"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."
"The most valuable feature is the metadata generated code."
"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."
"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."
"The tool supports multiple target update methods."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Naturally produces a way to easily debug your DW data solutions."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"I would like the stability to improve."
"The product's high costs can be an area of concern where improvements are required."
"Integration with the largest number of databases and other systems would be important."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The connectivity with T24 core banking could be improved."
"Pushdown optimization could be improved."
"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."
"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."
"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."
"Customization could be better."
"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 PowerExchange is ranked 21st in Data Integration with 19 reviews while WhereScape RED is ranked 48th in Data Integration. Informatica PowerExchange is rated 7.8, while WhereScape RED is rated 8.2. The top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Azure Data Factory, SSIS and Qlik Replicate, whereas WhereScape RED is most compared with Azure Data Factory, SSIS, Informatica PowerCenter, Matillion ETL 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.