We performed a comparison between Informatica PowerCenter and SAS Data Integration Server 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."
"Deployment was simple and straightforward."
"UI-based ability to create data mapping."
"Good interface, reasonable documentation."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"Can manage a huge quantity of data and provide reliability."
"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."
"It's very easy to use it to develop mappings and workflows."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution offers very good data manipulation and loading."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"We had stability issues, mostly with JVM size."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"They should release new versions for the solution's on-premises setup."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The licensing is difficult."
"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 of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while SAS Data Integration Server is ranked 32nd in Data Integration with 3 reviews. Informatica PowerCenter is rated 8.0, while SAS Data Integration Server is rated 7.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 Integration Server writes "A stable and scalable tool with data handling capabilities and an amazing technical support". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas SAS Data Integration Server is most compared with Palantir Foundry, SSIS, Oracle Data Integrator (ODI), Azure Data Factory and AWS Glue. See our Informatica PowerCenter vs. SAS Data Integration Server 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.