Data Source Support

FedSQL can access the following data sources:
  • Aster
  • DB2 for UNIX and Windows operating environments
  • Greenplum
  • Hadoop (Hive, HDMD, HAWQ, and Impala)
  • Memory Data Store (MDS)
  • MySQL
  • Netezza
  • ODBC databases (such as Microsoft SQL Server)
  • Oracle
  • PostgreSQL
  • SAP (Read-only)
  • SAP HANA
  • Sybase IQ
  • SAS data sets
  • SASHDAT files (Write-only)
  • SAS Scalable Performance Data Engine (SPD Engine) data sets
  • SAS Scalable Performance Data Server (SPD Server) tables in UNIX and Windows operating environments
  • Teradata for UNIX and Windows operating environments
Note: The procedures and SAS Federation Server support different data sources. See Base SAS Procedures Guide and SAS Federation Server: Administrator’s Guide for information about the data sources that each one supports.
Last updated: February 23, 2017