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."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 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."
"I like the completeness of the way I can build ETL workflows."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"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."
"It has good standard features for ETL development."
"The number of docs has been reduced drastically, which is very good."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"I am impressed with the tool's ability to customize."
"The technical support is excellent."
"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 product offers very good flexibility."
"The tool is reliable, quick, and powerful."
"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."
"If you compare it to SQL, the memory and development times are very quick."
"They should release new versions for the solution's on-premises setup."
"Integrating new tools can be tricky and challenging."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Integration with Artificial Intelligence would benefit this solution."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"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."
"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."
"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."
"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."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"I would like the tool to include the ability to automate the modifications of the integrations."
"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."
"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 is quite expensive and hard to install/configure."
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 Collibra Governance. 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.