We performed a comparison between Informatica PowerCenter, SAS Data Management, 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."It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The technical support for Informatica PowerCenter is good."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"It has helped us monetize."
"Has a good visual tool for data mapping."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"Once you have learned Informatica, it is very easy to use."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"If you compare it to SQL, the memory and development times are very quick."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The technical support is excellent."
"The product offers very good flexibility."
"I am impressed with the tool's ability to customize."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"This is an established product with powerful data analysis and varied options for user entry points."
"The most valuable feature is the metadata generated code."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I found the initial setup very easy."
"Naturally produces a way to easily debug your DW data solutions."
"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 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 licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"This product is going to decommission in the next couple of years."
"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."
"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."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"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."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"I would like to see an improvement in the digital adoption."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"The solution could use better documentation."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"I would like the tool to include the ability to automate the modifications of the integrations."
"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."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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)."
"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."
"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