Data Source Support

FedSQL can access the following data sources:
  • Aster
  • DB2 for UNIX and PC operating environments
  • Greenplum
  • Hadoop (Hive and HDMD)
  • Memory Data Store (MDS)
  • MySQL
  • Netezza
  • ODBC databases (such as Microsoft SQL Server)
  • Oracle
  • PostgreSQL
  • SAP (Read-only)
  • SAP HANA
  • SASHDAT files
  • Sybase IQ
  • SAS data sets
  • SAS Scalable Performance Data Engine (SPD Engine) data sets
  • Teradata
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.