We performed a comparison between Informatica PowerCenter and SAS Access based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It reduces a lot of legacy coding."
"The solution is stable."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"Informatica PowerCenter is a very good ETL tool."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"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 aspect of the solution is the ease of access to the data in those databases."
"The most valuable feature is you have native access to the external databases."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"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."
"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."
"I would like to see it be able to import data from NoSQL."
"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 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."
"The solution can provide access to the newer databases that come out sooner."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while SAS Access is ranked 42nd in Data Integration with 3 reviews. Informatica PowerCenter is rated 8.0, while SAS Access is rated 9.0. 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 Access writes "The solution is stable, scalable, and flexible". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas SAS Access is most compared with Delphix and Toad Data Point.
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.