When you use SAS Viya, most of your analysis takes place using the CAS server. CAS holds your data in memory for fast access, and the CAS server enables distributed processing of large amounts of data. Use your data connector to load your data into a caslib that you add using a CASLIB statement. If you have a data connect accelerator for your interface, use it to load data in parallel into CAS. For more information, see Working with SAS Data Connectors in SAS Cloud Analytic Services: User’s Guide.
These SAS/ACCESS interfaces have corresponding data connectors.
| Amazon Redshift | ODBC |
| DB2 under UNIX hosts | Oracle |
| Google BigQuery | PostgreSQL |
| Hadoop * | SAP HANA |
| Impala | Snowflake |
| JDBC | Teradata * |
| Microsoft SQL Server | Vertica |
| MySQL |
* It is possible to transfer data in parallel if you have separately licensed SAS In-Database Technologies for this interface.
Additional interfaces: In addition to the relational DBMS interfaces in this book, the following SAS/ACCESS interfaces have corresponding data connectors:
| MongoDB | Salesforce |
| PC Files |
For more information, see Data Connectors in SAS Cloud Analytic Services: User’s Guide.
In addition, some SAS/ACCESS interfaces can be included with SAS Viya but do not have corresponding data connectors, such as Greenplum, HAWQ, Netezza, and SAP ASE.
Your traditional SAS/ACCESS interface enables you to establish a connection, via a libref that you specify in a LIBNAME statement, between the SAS client and your external data source. After you specify this connection to your data source, you can send SQL commands by using the SQL procedure to manipulate the data in your external data source.
To access results that you generate in CAS, use a CAS LIBNAME statement to specify a libref between the SAS client and the CAS server. For more information, see CAS LIBNAME Engine Overview in SAS Cloud Analytic Services: User’s Guide.