Informatica PowerCenter vs SAS Data Integration Server comparison

Informatica PowerCenter vs. SAS Data Integration Server

Download the complete report

Helped 903,147 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Informatica PowerCenter

Ranking in Data Integration

4th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Visualization (13th)

SAS Data Integration Server

Ranking in Data Integration

40th

Average Rating

7.2

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of July 2026, in the Data Integration category, the mindshare of Informatica PowerCenter is 3.4%, down from 8.2% compared to the previous year. The mindshare of SAS Data Integration Server is 0.9%, up from 0.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Mindshare Distribution
Product	Mindshare (%)
Informatica PowerCenter	3.4%
SAS Data Integration Server	0.9%
Other	95.7%

Data Integration

Featured Reviews

Garima Goel

Associate Principal Engineer at Nagarro

Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement

Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into. Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

Read full review

reviewer2937544

Works at a financial services firm with 5,001-10,000 employees

Offloads processes on the server side but needs better installation syntax

One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"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."

"Informatica is 100% value for money, and the kind of flexibility and stability it offers in dealing with heterogeneous data is amazing."

"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration."

"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."

"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."

"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."

"This is an old and reliable product, and I like the visual tool for data mapping and the workflow manager."

"It is very robust, scalable, and simple to use, and it is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."

More Informatica PowerCenter pros

"The solution is very stable."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"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."

Cons

"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."

"It would be good to recreate the entire interface to make it easier for users to build workflows."

"The cost and set up of the licenses could be improved. You need a lot of different licenses, depending on your setup, and it gets expensive."

"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."

"As all ETL tools in general, it does not include a good data reporting feature."

"I would like to see the inclusion of a tool that allows you to report performance metrics."

"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."

"The documentation could be improved."

More Informatica PowerCenter cons

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

"The transform tool has limited access. They should make it more flexible."

"One area for improvement is the installation process."

"Something that could improve is writing SQL to integration studio because it is not that straightforward. There should be better integration with other software."

"The initial setup of SAS Data Integration Server was complex."

"So I would like to see improved integration with other software."

Pricing and Cost Advice

"Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho. There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users."

"We have found the pricing very cost-effective. The licensing is CPU and data source-based."

"Its maintenance is expensive."

"I am not sure about the most recent price, but I think it should be $100,000 or more."

"The solution is in the middle price range compared to other solutions."

"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."

"We are using an annual license for Informatica PowerCenter."

"A basic setup can be from $100,000 and up annually."

More Informatica PowerCenter pricing and cost advice

"It is an expensive program."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

903,147 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Manufacturing Company

Computer Software Company

Government

Financial Services Firm

26%

Construction Company

13%

Comms Service Provider

11%

Computer Software Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	15
Midsize Enterprise	11
Large Enterprise	75

No data available

Questions from the Community

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

Which Informatica product would you choose - PowerCenter or Cloud Data Integration?

Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...

What needs improvement with SAS Data Integration Server?

What is your primary use case for SAS Data Integration Server?

I am involved in the ETR job. My role is focused on executing the ETR job.

What advice do you have for others considering SAS Data Integration Server?

I use it without further details. For example, if I use SAS to connect to a NetEazt database or purchase a shared asset to ODBC, I can connect to any database with ODBC connection support. The over...

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter

Comparisons

Compared 7% of the time

WhereScape RED vs Informatica PowerCenter

Compared 5% of the time

Oracle Data Integrator (ODI) vs Informatica PowerCenter

Compared 5% of the time

SSIS vs Informatica PowerCenter

Compared 4% of the time

SAS Data Management vs Informatica PowerCenter

Compared 4% of the time

More Informatica PowerCenter Competitors

SSIS vs SAS Data Integration Server

Compared 7% of the time

Oracle Data Integrator (ODI) vs SAS Data Integration Server

Compared 5% of the time

Palantir Foundry vs SAS Data Integration Server

Compared 4% of the time

Axway AMPLIFY Application Integration vs SAS Data Integration Server

Compared 4% of the time

Upsolver vs SAS Data Integration Server

Compared 4% of the time

More SAS Data Integration Server Competitors

Product Reports

Informatica PowerCenter

Download Informatica PowerCenter product report

Data Integration

Download SAS Data Integration Server product report

Also Known As

PowerCenter

SAS Enterprise Data Integration Server, Enterprise Data Integration Server

Overview

Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.

Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.

What are the key features of Informatica PowerCenter?

Data Integration: Facilitates robust data handling across numerous platforms.
Real-Time Processing: Manages data workflows efficiently in real-time.
Transformation Options: Provides extensive options for data mapping and manipulation.
Error Handling: Enhances development through efficient error management.
Scalability: Supports growing data needs with adaptability across diverse systems.

What benefits should users look for?

Scalability: Supports growth with efficient data management and integration.
Efficiency: Offers user-friendly interfaces for streamlined workflows.
Support: Provides traceability and comprehensive support for large data handling.
Adaptability: Integrates seamlessly with various data platforms, enhancing flexibility.
Future-Preparedness: Ready for transition to cloud environments for better scalability.

Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.

Informatica

SAS Data Integration Server automates and manages data integration processes, enabling efficient data management, transformation, and migration in enterprises. It provides a comprehensive suite for data-driven solutions.

Designed for extensive data management needs, SAS Data Integration Server supports seamless data integration, allowing users to access, run, and monitor data transformation processes. It is tailored to enhance data quality and streamline processes, serving industries reliant on precise data interpretation and utilization. With robust functionalities, it simplifies complex data environments, promoting productivity and reliability in data handling.

What are the key features of SAS Data Integration Server?

Data Profiling: Ensures data accuracy and quality through thorough analysis.
ETL Capabilities: Extracts, transforms, and loads data efficiently.
Metadata Management: Centralized control over data definitions and usage.
Data Lineage: Tracks data source origins and transformations for transparency.

What benefits and ROI should reviewers look for?

Improved Data Accuracy: Enhances decision-making with high-quality data.
Increased Efficiency: Reduces time and effort in data-related tasks.
Scalability: Adapts to growing business data demands seamlessly.
Reduced Costs: Optimizes resources, minimizing unnecessary expenditures.

SAS Data Integration Server finds applications across numerous industries, like finance and healthcare, where data integration and quality are critical. In finance, it helps manage vast amounts of transaction data, while in healthcare, it ensures accurate patient information management and reporting.

SAS

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance

Informatica PowerCenter vs. SAS Data Integration Server