Support for Databases in SAS^® Viya^® 3.5

Some SAS products support slightly different versions of the data sources that are supported by SAS Viya 3.5. For more information, see Support for Databases in SAS Visual Investigator and Support for Databases in SAS Anti-Money Laundering, SAS Customer Due Diligence, and SAS Real-Time Screening.

Support for Amazon Redshift

SAS/ACCESS Interface to Amazon Redshift includes a required ODBC driver.

The required client software is installed automatically. In order to reference a Data Source Name (DSN) in your connections, some post-installation configuration might be required. Consult the SAS® Viya® 3.5: Deployment Guide for instructions.

Support for IBM DB2

IBM DB2 Connect™ must also be licensed if you plan to connect to IBM DB2 databases that are running on AS/400, VSE, VM, MVS, and z/OS systems.

The following DBMS products are supported:

• IBM DB2 version 10.5 or later
  
• Client utilities for IBM DB2 version 10.5 or later

SAS/ACCESS Interface to DB2 supports the following products:

• IBM Integrated Analytics System (IIAS)
  

SAS recommends installing the latest FixPack on the client and server.

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

Support for Google BigQuery

Base SAS is required for the installation of SAS/ACCESS Interface to Google BigQuery.

The required Google BigQuery client library is included with SAS/ACCESS Interface to Google BigQuery.

Support for Greenplum

SAS/ACCESS Interface to Greenplum includes the required 64-bit ODBC driver.  Greenplum Database version 4.3 or later is supported.

Support for Hadoop

The table below details the minimum supported Hadoop distributions for SAS Viya 3.5 release with the latest hot fixes applied.

SAS Support for Alternative Releases of Hadoop Distributions describes SAS support for later versions of Hadoop distributions.

Hewlett Packard Enterprise Ezmeral Data Fabric is not supported.

 

SAS In-Database Technologies for Hadoop requires the following components:

• Apache Hive
  Hive requires the following additional software:
  • Oracle JRE version 1.8 or a later version
  • Python, strace, and wget (which are included with Linux)
• MapReduce or Spark 2.4
  
• YARN
• HCatalog for processing non-delimited Hive file types

Information about Hadoop JAR files and SAS environment variables for Hadoop is provided in the Hadoop Deployment: Configuring SAS Access to Hadoop and SAS Data Connector to Hadoop.

Support for HAWQ

SAS/ACCESS Interface to HAWQ includes the required 64-bit ODBC driver.  Apache HAWQ Database version 2.2 or later is supported.

Support for Impala

SAS/ACCESS Interface to Impala supports Impala Server version 2.5 or a later version. It also supports the ODBC Driver for Impala, version 2.5.34 or a later version.

In addition, the ODBC Driver for Impala requires a compatible ODBC Driver Manager, such as the Unix ODBC Driver Manager.

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

Requirements for JDBC Access

A JDBC driver is required for the data source from which you want to access data. JDBC drivers are available from DBMS vendors and other third-party JDBC driver developers. SAS recommends using JDBC drivers that comply with the JDBC 4.1 specification or later.

You must install the JDBC driver on the CAS controller.

Support for Microsoft SQL Server

SAS/ACCESS Interface to Microsoft SQL Server supports Microsoft SQL Server 2012 or later.

The client software is installed automatically along with SAS/ACCESS Interface to Microsoft SQL Server. Some post-installation configuration might be required for the client.

SAS/ACCESS Interface to Microsoft SQL Server supports the following cloud variants of Microsoft SQL Server:

• Amazon RDS Microsoft SQL Server (Microsoft SQL Server 2012 or later)
• Google Cloud Platform Cloud SQL for SQL Server (version 2017 or later)
• Microsoft Azure SQL Database
  
• Microsoft Azure SQL Database Managed Instance

Support for MongoDB

SAS/ACCESS Interface to MongoDB requires the MongoDB C Driver (“libmongoc,” the official client library for C applications). You can obtain the latest MongoDB C driver from the following website: http://mongoc.org/.

SAS/ACCESS Interface to MongoDB requires the following DBMS products:

• MongoDB version 3.6.5 or later
  
• MongoDB C Driver version 1.17 or later
  

Support for MySQL

SAS/ACCESS Interface to MySQL supports the following DBMS products:

• MySQL Client version 5.7 or later
  
• MySQL Server version 5.7 or later

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

SAS/ACCESS Interface to MySQL supports the following cloud and database variants of MySQL:

• Amazon Aurora (MySQL engine version 5.7 or later)
• Amazon RDS MariaDB (engine version 10.1 or later)
• Amazon RDS MySQL (engine version 5.7 or later)
• Azure Database for MySQL (engine version 5.7 or later)
• Google Cloud Platform Cloud SQL MySQL (engine version 5.7 or later)
• MariaDB 10.1 or later
• SingleStore (MemSQL) 6.0 or later
• Oracle MySQL Database

Support for Netezza

SAS/ACCESS Interface to Netezza requires an ODBC driver from IBM. To obtain the appropriate IBM Netezza ODBC driver, contact IBM Technical Support at (877) 426-6006 or visit the IBM Fix Central web site: http://www.ibm.com/support/fixcentral.

SAS Viya supports the following DBMS products:

• IBM Netezza version 7.0 or later         
• Client utilities for IBM Netezza version 7.0 or later

For best results, match the Netezza ODBC client version with the version of the Netezza server where it will be connected. For example, if you have IBM Netezza Interface server release 7.0.4, you should use the ODBC client driver release 7.0.4 with SAS/ACCESS Interface to Netezza.

Support for ODBC

Before you can use SAS Viya with ODBC, an ODBC driver is required for the data source from which you want to access data. ODBC drivers are often available from DBMS vendors and other third-party ODBC driver developers. Your ODBC driver must comply with the ODBC 3.5 (or later) specification.

With SAS Viya on Windows, install the ODBC driver on the machine with SAS Viya. With SAS Viya on Linux, you must install the ODBC driver on the CAS controller.

Note: The ODBC driver that you select might require additional DBMS software in order to enable network access.

Support for Oracle

SAS Viya requires the following Oracle components:

• Oracle Database 19c or later
• Oracle Client 19c or later (64-bit libraries)

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

SAS/ACCESS Interface to Oracle supports the following cloud variants of Oracle:

• Amazon RDS Oracle (19c or later)
• Oracle Cloud Platform (19c or later)

Support for PostgreSQL

SAS Viya can connect to PostgreSQL Database version 9.4.4 or a later version.

SAS Viya requires a driver manager and an ODBC driver for PostgreSQL. SAS provides both of these ODBC client components and installs them automatically.

In order to reference a Data Source Name (DSN) in your connections, some post-installation configuration might be required. Consult the SAS Viya 3.5: Deployment Guide for instructions.

With SAS Viya on Linux, you must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

SAS/ACCESS Interface to PostgreSQL supports the following cloud variants of PostgreSQL:

• Amazon Aurora PostgreSQL 9.6 or later
• Amazon RDS PostgreSQL 9.6 or later
• Azure Database for PostgreSQL 9.6 or later
• EnterpriseDB PostgreSQL 9.6 or later
  
• Google Cloud Platform Cloud SQL for PostgreSQL 9.6 or later

Support for Salesforce

SAS/ACCESS Interface to Salesforce requires a Salesforce user account that has API access enabled. SAS/ACCESS Interface to Salesforce supports Salesforce API access, version 46.0 or later.

Support for SAP ASE

SAS/ACCESS Interface to SAP ASE (on SAS Viya) requires SAP ASE (formerly Sybase) Open Client SDK, Release 15.7 or later (64-bit libraries).

Support for SAP HANA

SAS/ACCESS Interface to SAP HANA requires the ODBC driver (64-bit) for SAP HANA from SAP. This driver is part of the SAP HANA Client.

The following SAP products are required:

• SAP HANA SPS 11 Server or later
• SAP HANA ODBC Client for SPS 11 or later

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

Support for SAP R/3

SAS Viya requires the following products:

• SAP NetWeaver 7.0 or later
• SAP NetWeaver RFC library, Release 7.20 or later

Support for Snowflake

SAS/ACCESS Interface to Snowflake (on SAS Viya) requires the following products:

• ODBC Driver for Snowflake, version 2.19.2 or later
• For Linux: The unixODBC Driver Manager. Use the latest version.
• For Windows: The Snowflake ODBC Driver. Use the latest version.

With SAS Viya on Linux, you must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

Support for Teradata

SAS Viya support for Teradata requires the following DBMS products:

• Teradata CLIv2 client libraries, TTU 16.20 or 17.10
• Teradata Database 16.xx if you are using TTU 16.20
• Teradata Database 17.xx if you are using TTU 17.10

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

The SAS Data Connect Accelerator for Teradata also requires SAS Embedded Process for Teradata.

The SAS Embedded Process for Teradata is included with SAS In-Database Technologies for Teradata. It requires 600 MB of disk space in the /opt file system on each Teradata Trusted Parallel Application (TPA) host.

In order to load data in parallel, the CAS controller and each CAS worker must have an IP address that can be routed externally from the SAS Embedded Process TPA nodes.

Additional disk space in the /opt file system is also required on each TPA node to accommodate SAS Quality Knowledge Base (QKB). The size of the QKB varies, but the default size is 8 GB.

Both SAS/ACCESS Interface to Teradata and SAS In-Database Technologies for Teradata support Teradata Vantage SQL Engine version 16.20 or later on the following cloud platforms:

• Amazon Web Services
• Google Cloud
  
• Microsoft Azure
• VMware

Support for Vertica

SAS/ACCESS Interface to Vertica requires Vertica Analytic Database version 7.1 or later and Vertica ODBC Client version 7.1 or later from Vertica. SAS/ACCESS Interface to Vertica also requires the Vertica ODBC Client Driver.

To obtain the Vertica Client ODBC driver, contact your database administrator or visit the myVertica website: https://my.vertica.com/download/vertica/client-drivers.

You must install the client software on the CAS controller and on any CAS workers that will participate in a multinode data transfer request. Multinode is an optional data transfer method that increases the speed of serial data transfers. It is only supported by SAS Viya on Linux.

Support for Databases in SAS Visual Investigator

SAS Visual Investigator 10.6 and later and SAS Intelligence and Investigation Management 8.1 and later support the specified versions of the following databases:

• IBM DB2 (refer to Support for IBM DB2 for information about supported versions and requirements)
  
• Microsoft SQL Server. The following distributions are supported:    
  • Microsoft SQL Server 2017 and later
  • Microsoft SQL Server on Azure Virtual Machines
  • Azure SQL Managed Instance
• MySQL (refer to Support for MySQL)

SAS Visual Investigator 10.6 supports only MySQL 5.7 and earlier. SAS Visual Investigator 10.7 and later support newer versions of MySQL.

• Oracle (refer to Support for Oracle)
  
• PostgreSQL (refer to Support for PostgreSQL)
  
• Teradata (refer to Support for Teradata)

Note: Unless specified otherwise, SAS Visual Investigator does not support the “cloud variants” of data sources that are listed for each corresponding SAS/ACCESS product.

Data from MySQL and Microsoft SQL Server data sources is accessible using SAS/ACCESS Interface to ODBC.

Support for Databases in SAS Anti-Money Laundering, SAS Customer Due Diligence, and SAS Real-Time Screening

SAS Anti-Money Laundering 8.2 and 8.3 and SAS Customer Due Diligence support the following databases for the external data store:

• Oracle

Note: Only Oracle Database Enterprise Edition, 19c or later is supported by SAS Anti-Money Laundering.

• PostgreSQL
• Microsoft SQL Server Enterprise Edition 2016 SP 1 and later

SAS Real-Time Screening supports Oracle and PostgreSQL databases only.

SAS Anti-Money Laundering, SAS Customer Due Diligence, and SAS Real-Time Screening also use a separate PostgreSQL instance as an internal data store for the Knowledge Center and SAS Infrastructure Data Server. 

Note: SAS Anti-Money Laundering, SAS Customer Due Diligence, and SAS Real-Time Screening do not support the "cloud variants" of data sources that are listed for each corresponding SAS/ACCESS product.

Data from a Microsoft SQL Server data source is accessible using SAS/ACCESS Interface to ODBC.