2020-03-04T08:49:31Z

What advice do you have for others considering SAS Access?

Miriam Tover - PeerSpot reviewer
  • 0
  • 0
PeerSpot user
3

3 Answers

Robert Heck - PeerSpot reviewer
Real User
Top 10
2022-09-22T10:48:00Z
Sep 22, 2022

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.

Search for a product comparison
JH
Real User
2021-11-30T03:27:30Z
Nov 30, 2021

Our company is just a customer. I am an end-user of the solution. I can't say that I have specific advice as to why others should use this product. It's just another piece of the tool. I'd rate the solution at a nine out of ten. It's helpful and reliable.

CD
Real User
2020-03-04T08:49:31Z
Mar 4, 2020

My advice to people considering this as a solution would be that if they need a relatively straightforward method for connecting to various data sources, then I would advise using this. It is a particularly good solution if the data sources are not on the same physical platform type or environment. If their SAS is on a Windows server, for example, but they have to connect to Unix based databases or vice versa that is a perfect place to use this tool. If their SAS is on a Unix box and they are now trying to connect to things like Microsoft SQL Server, SAS/ACCESS is worth its weight and cost in resolving that type of issue. It is particularly true if they do not have dedicated support resources internally. What was interesting about coming to this product as a solution was realizing that a lot of times people will find a way around what is really something that should just be done from a software administrative support level. Where the company I worked for could have just been going directly to the SAS server to get data, they had created a half-functional work-around. It got the job done but it was totally inefficient. When I came in with SAS/ACCESS all that extra effort stopped. It is a matter of learning about efficiency. You can create a solution that functions, but it is like driving your car on one of those little donut spares instead of getting the right tire instead. That donut is not made to be on the car forever. On a scale from one to ten where one is the worst and ten is the best, I would rate the SAS/ACCESS product as a ten-out-of-ten. If you need this type of solution, it does exactly what you need. You can create access with the full support of the company's technical support. For example, in our most complicated scenario, we were actually able to connect to a vendor's database completely outside of our company network and utilize the data. SAS technical support was perfectly willing to work with me to figure out how to set up that connection under SAS/ACCESS. The combination of the support and the technical capabilities of the product just can not be matched with any other product that I know of.

Find out what your peers are saying about SAS, Informatica, Quest Software and others in Data Integration. Updated: March 2024.
765,234 professionals have used our research since 2012.
Data Integration
What is data integration? Data integration is the process of combining data that resides in multiple sources into one unified set. This is done for analytical uses as well as for operational uses.
Download Data Integration ReportRead more