Support for Cloud and Database Variants

SAS has extended SAS/ACCESS and SAS In-Database Technologies support to selected cloud and database variants of supported data sources. The full list of supported databases for each SAS/ACCESS or SAS In-Database product can be found in the system requirements document that corresponds to your operating system.

Support for Hadoop

Starting with SAS® 9.M4, the following Hadoop as a Service platform is supported:

  • Amazon Elastic Map Reduce (EMR)

The following SAS products support Amazon EMR:

  • SAS/ACCESS® Interface to Hadoop
  • SAS® In-Database Code Accelerator
  • SAS® Scoring Accelerator for Hadoop
  • SAS® High-Performance Analytics (requires SAS 9.4M5 and later)

The following limitations apply to SAS support for Amazon EMR:

  • SAS FILENAME statement for Hadoop
    • Reads and writes using the REST API are not supported. Set the environment variable SAS_HADOOP_RESTFUL to 0 (the default setting).
    • SAS HADOOP procedure
  • Submitting Pig Latin code is not supported due to Java issues.
    • Reads and writes using the REST API are not supported. Set the environment variable SAS_HADOOP_RESTFUL to 0 (the default setting).
  • Spark is not supported.

Support for MySQL

Starting with SAS 9.4M4 SAS/ACCESS Interface to MySQL supports the following:

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

Support for Microsoft SQL Server

Starting with SAS 9.4M4, SAS/ACCESS Interface to Microsoft SQL Server supports the following:

  • Amazon RDS Microsoft SQL Server (Microsoft SQL Server 2012 or later)
  • Microsoft Azure SQL Database
  • Microsoft Azure SQL Database managed instance

Support for Oracle

Starting with SAS 9.4M4, the following Oracle platforms are supported:

  • Amazon RDS Oracle (Oracle version 11gR2 or later) (supported by SAS/ACCESS Interface to Oracle)
  • Oracle Cloud Platform (Oracle version 11gR2 or later) (supported by SAS/ACCESS Interface to Oracle and SAS Scoring Accelerator for Oracle)

Support for PostgreSQL

Starting with SAS 9.4M5, SAS/ACCESS Interface to PostgreSQL supports the following:

  • Amazon Aurora (PostgreSQL engine version 9.6 or later)
  • Amazon RDS PostgreSQL (engine version 9.6 or later)
  • Azure Database for PostgreSQL (engine version 9.6 or later)
  • Google Cloud Platform Cloud SQL for PostgreSQL (Engine version 9.6 or later)

Support for Teradata

Starting with SAS 9.4M4, the following Teradata Database 15.10 or later platforms are supported by the indicated SAS products:

Teradata IntelliCloud

  • SAS/ACCESS Interface to Teradata
  • SAS Scoring Accelerator for Teradata
  • SAS Code Accelerator for Teradata
  • SAS Data Quality Accelerator for Teradata
  • SAS Analytics Accelerator

Teradata Database on Amazon Web Services

  • SAS/ACCESS Interface to Teradata
  • SAS Scoring Accelerator for Teradata
  • SAS Code Accelerator for Teradata
  • SAS Data Quality Accelerator for Teradata
  • SAS Analytics Accelerator

Teradata Database on Microsoft Azure

  • SAS/ACCESS Interface to Teradata
  • SAS Scoring Accelerator for Teradata
  • SAS Code Accelerator for Teradata
  • SAS Data Quality Accelerator for Teradata
  • SAS Analytics Accelerator

Teradata Database on VMware

  • SAS/ACCESS Interface to Teradata
  • SAS Scoring Accelerator for Teradata
  • SAS Code Accelerator for Teradata
  • SAS Data Quality Accelerator for Teradata
  • SAS Analytics Accelerator




1SAS FedSQL and DS2 are not supported with MemSQL

Recommended Resources


Explore our training options, including on-site classroom, live web, e-learning and one-on-one mentoring.


Validate your SAS knowledge and skills by earning a globally recognized credential from SAS.


Explore documentation on topics of interest to SAS administrators.
 

Back to Top