Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs SAS Data Integration Server comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Reviews Sentiment
6.5
Number of Reviews
80
Ranking in other categories
Data Visualization (8th)
SAS Data Integration Server
Ranking in Data Integration
36th
Average Rating
7.4
Reviews Sentiment
8.5
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Informatica PowerCenter is 10.9%, up from 10.1% compared to the previous year. The mindshare of SAS Data Integration Server is 0.6%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
A stable and reliable product that provides a variety of features for data integration
The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.
reviewer1752714 - PeerSpot reviewer
A stable and scalable tool with data handling capabilities and an amazing technical support
I am from the data visualization team and used SAS VA and SAS Data Integration Server. This year, my team has stopped the use of SAS VA and SAS Data Integration Server. We have a separate team that uses SAS Data Integration Server since they belong to the data management team. I recommend the solution to those organizations that have a very large scale of data to handle so that they can utilize the solution's data handling capabilities. Organizations can go with the solution's on-premises or cloud version. Since the cost of the on-premises version of the solution is huge, I recommend businesses go with the cloud version. I rate the overall product between seven to eight out of ten.

Quotes from Members

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

Pros

"Once you have learned Informatica, it is very easy to use."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"It has helped us monetize."
"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."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The setup is straightforward."
"Good product if you are trying implement data quality, data integration, and data management projects."
"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."
"The solution is very stable."
 

Cons

"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."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"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."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The pricing could be improved."
"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."
"The solution does not scale."
"When I deal with very large amounts of data, there have been performance issues."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
 

Pricing and Cost Advice

"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
"We have a site license, but we do pay by the division."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"The price of Informatica PowerCenter is expensive, but it does give value."
"We are satisfied with the pricing."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good. In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution. On a scale of one to five, I'm rating its price a three."
"I am not sure about the most recent price, but I think it should be $100,000 or more."
"It is an expensive program."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
13%
Manufacturing Company
7%
Insurance Company
7%
Financial Services Firm
25%
Computer Software Company
14%
Government
11%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
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 do you like most about SAS Data Integration Server?
The most valuable feature of the solution is its amazing capabilities in regard to data handling.
What is your experience regarding pricing and costs for SAS Data Integration Server?
I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.
What needs improvement with SAS Data Integration Server?
Visualization is an area with a few shortcomings in the product. Some new and amazing visualization capabilities have been added to the product, but I haven't used them enough to be able to comment...
 

Also Known As

PowerCenter
SAS Enterprise Data Integration Server, Enterprise Data Integration Server
 

Learn More

Video not available
 

Overview

 

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
Find out what your peers are saying about Informatica PowerCenter vs. SAS Data Integration Server and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.