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

Informatica PowerCenter vs SAS Access comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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
2nd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
81
Ranking in other categories
Data Visualization (8th)
SAS Access
Ranking in Data Integration
57th
Average Rating
9.0
Reviews Sentiment
7.5
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Informatica PowerCenter is 9.7%, down from 11.9% compared to the previous year. The mindshare of SAS Access is 0.3%, up from 0.2% 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.
Robert Heck - PeerSpot reviewer
The solution is stable, scalable, and flexible
I rate the solution eight out of ten. The number of people required to maintain the solution is dependent on the other applications running. The solution in itself does not require a lot of maintenance. The solution is flexible and I recommend it when you have more complex applications with special requirements.

Quotes from Members

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

Pros

"We can scale the product."
"My overall experience with Informatica PowerCenter is positive."
"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 has good standard features for ETL development."
"The product's initial setup phase is very easy."
"The interface is very clean and clear."
"It is an excellent ETL tool."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable feature is you have native access to the external databases."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
 

Cons

"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."
"Requires an established data center because there is no option for software as a service."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"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."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"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 solution can provide access to the newer databases that come out sooner."
"The pricing model needs to be reconsidered and adjusted."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
 

Pricing and Cost Advice

"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."
"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."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"It's much more expensive, almost three times more expensive than most other solutions."
"Its maintenance is expensive."
"Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis."
"I am not sure about the most recent price, but I think it should be $100,000 or more."
"We are satisfied with the pricing."
"The pricing model is complex and is based on modular packages as well as the size of the applicable environment."
"The solution's pricing and licensing are expensive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
845,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
18%
Computer Software Company
12%
Manufacturing Company
7%
Government
7%
Financial Services Firm
24%
Computer Software Company
11%
Manufacturing Company
11%
Insurance Company
10%
 

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...
Ask a question
Earn 20 points
 

Also Known As

PowerCenter
SAS/Access
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Los Angeles County, West Midlands Police, Credit Guarantee Corporation, Canada Post, Allianz Global Corporate & Specialty
Find out what your peers are saying about Informatica PowerCenter vs. SAS Access and other solutions. Updated: February 2025.
845,406 professionals have used our research since 2012.