We performed a comparison between Informatica PowerCenter and SAS Data Management based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Once you have learned Informatica, it is very easy to use."
"PowerCenter performs well during data transformation and optimization."
"The ability to scale through partitions helped us to improve the performance."
"Has a good visual tool for data mapping."
"It has very good monitoring and process monitoring."
"I like the automated scheduling feature."
"It is an excellent ETL tool."
"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."
"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."
"This is an established product with powerful data analysis and varied options for user entry points."
"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."
"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 tool is reliable, quick, and powerful."
"The technical support is excellent."
"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 licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"The initial setup is not straightforward. You need expertise to do it."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"I would like the tool to include the ability to automate the modifications of the integrations."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"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 solution is quite expensive and hard to install/configure."
"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."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"The solution could use better documentation."
"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."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while SAS Data Management is ranked 43rd in Data Integration with 15 reviews. Informatica PowerCenter is rated 8.0, while SAS Data Management is rated 8.4. 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 SAS Data Management writes "A scalable solution with customer support that is responsive and diligent". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas SAS Data Management is most compared with Tungsten RPA, Microsoft Purview, IBM InfoSphere DataStage, Palantir Foundry and SSIS.
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.