We performed a comparison between Informatica PowerCenter and SAS Access 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."It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The interface is very clean and clear."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"It has good standard features for ETL development."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"UI-based ability to create data mapping."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"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."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"Lacks ability to calculate cost of the product."
"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."
"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."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"The solution does not scale."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
"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."
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 Toad Data Point and Delphix. See our Informatica PowerCenter vs. SAS Access 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.