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)
  • MariaDB 10.1 or later - On-premises
  • MemSQL 6.0 or later – On-premises1

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

Support for Oracle

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

  • Amazon RDS Oracle (11gR2, 12c or 18c) (supported by SAS/ACCESS Interface to Oracle)
  • Oracle Cloud Platform (11gR2, 12c or 18c) (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)

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