SAS/ACCESS Reviews & Product Details

I use SAS/ACCESS to connect to our database and find it offers easy data extraction, loading, and manipulation. I like that it is quick and convenient. I also appreciate how it combines SAS and SQL effectively. The initial setup was very easy. Review collected by and hosted on G2.com.

Not any I can think of Review collected by and hosted on G2.com.

Native Connectivity to variety of data sources Review collected by and hosted on G2.com.

High performance, low latency and native connectivity to variety of data sources Review collected by and hosted on G2.com.

Allow connectivity to many source databases and connectivity Review collected by and hosted on G2.com.

I seen no limitations on how we use/need access Review collected by and hosted on G2.com.

Having SAS Access included in the base Viya License is a godsend.SAS Access has allowed me to extract value from legacy data that is being migrated before the migration is complete. Review collected by and hosted on G2.com.

Well, i was going to,say the license fees, but see the other commemt. Review collected by and hosted on G2.com.

It’s very important that no data is compromised when we switch interfaces, SAS just do the job well. Review collected by and hosted on G2.com.

There are no as such dislikes about SAS/ACCESS. Review collected by and hosted on G2.com.

ability to seamlessly access oracle and snowflake Review collected by and hosted on G2.com.

sometimes queries are inefficient and slow, especially when using formats Review collected by and hosted on G2.com.

The program enables to connect to different database. Review collected by and hosted on G2.com.

additional verification and token are harder to implement when sharing the program within the team. Review collected by and hosted on G2.com.

SAS/ACCESS not only acts as a medium to connect to the Database and other filesystems and perform Data analysis for better decisions. It can transfer the data between different filesystems faster.

SAS has only two datatypes: Char and Num. But when loading the data to the DB, SAS/ACCESS handles the data conversion smoothly.

SAS customer support is always faster in responding to any query.

Easy to configure, connect, and access. Review collected by and hosted on G2.com.

Connection to some unpopular databases might sometimes be difficult as data connection settings can vary from DB to DB and filesystem, requiring learning of filesystem-specific settings to enable them in SAS. Review collected by and hosted on G2.com.

Data Integration : SAS/ACCESS provides seamless integration with Oracle, MS SQL and Hadoop

Ease of Use : With SAS/ACCESS, users can use familiar SAS procedures and functions to access and manipulate data, regardless of where the data is stored.

Data Consistency: SAS/ACCESS ensures that data is consistent and reliable, regardless of the data source. Review collected by and hosted on G2.com.

The implementation to integrate with MongoDB and Hadoop is not straight forward. It puts dependency on SAS Admin and normal developers cannot integrate it. Review collected by and hosted on G2.com.

Easy access to any DBMS and no need to worry about third-party drivers Review collected by and hosted on G2.com.

Some of the latest access engines (e.g., SAS/Access to Google BigQuery) are immature and do NOT support some functionalities that other ODBC drivers provide Review collected by and hosted on G2.com.