We performed a comparison between Informatica PowerCenter and SAS Data Management 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 setup is very simple."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Deployment was simple and straightforward."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"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."
"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."
"The product offers very good flexibility."
"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."
"If you compare it to SQL, the memory and development times are very quick."
"I am impressed with the tool's ability to customize."
"The tool is reliable, quick, and powerful."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"The technical support is excellent."
"I would like to see it be able to import data from NoSQL."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"The UI is a little outdated."
"There is some room for improvement in terms of pricing."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Integrating new tools can be tricky and challenging."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"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."
"The solution is quite expensive and hard to install/configure."
"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 could use better documentation."
"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."
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 Data Governance, SSIS, IBM InfoSphere DataStage and Palantir Foundry. See our Informatica PowerCenter vs. SAS Data Management 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.