Supported Data Sources

Overview

SAS Federation Server supports disparate data sources by providing software in the form of Federation Server drivers, which access the physical data that an application processes. Federation Server drivers provide access to third-party relational databases, such as DB2, Greenplum, ODBC data sources, Oracle, and Teradata, by connecting to a remote server process.
SAS Federation Server supports the following data sources: SAS data set, SAP, Apache Hive, and several third-party relational databases.
The following table lists data sources with their data service names:
Data Sources
Data Service Name
Default Drivers
Supported Drivers
SAS data sets
BASE
BASE
BASE
SASHDAT-Hadoop on Grid
SASHDAT
SASHDAT
SASHDAT
Distributed storage, Apache Hive
HIVE
HIVE
ODBC, HIVE
DB2
DB2UNXPC
DB2
ODBC, DB2
Greenplum
GREENPLUM
Greenplum
ODBC, Greenplum
Netezza
NETEZZA
Netezza
ODBC, Netezza
Oracle
ORACLE
ORACLE
ODBC, ORACLE
PostgreSQL
POSTGRESQL
PostgreSQL
ODBC, PostgreSQL
SAP
SAP
SAP
SAP
SAP HANA
SAPHANA
SAP HANA
ODBC, SAP HANA
SQL Server
SQLSERVER or SQLSVR
ODBC
ODBC
Teradata
TERADATA
TERADATA
ODBC, TERADATA
Native Catalogs
ODBC to data sources that support native catalogs.
ODBC_FED
ODBC
ODBC
Logical Catalogs
ODBC to data sources that don't support native catalogs. In this case, SAS Federation Server provides a logical catalog.
ODBC
ODBC
ODBC
MDS
MDS

SAS Data Set

The SAS data set is the Base SAS proprietary file format for SAS software, which contains data values that are organized as a table of observations (rows) and variables (columns). The supported file format is the same as SAS data sets that are created by the BASE engine for Version 7 and later.
The SAS Federation Server Driver for Base SAS provides Read and Update access to legacy SAS data sets. In addition, the driver creates SAS data sets that can be accessed by both SAS Federation Server and Base SAS software. The driver supports standard Base SAS storage functionality such as indexing, general integrity constraints, and SAS formats and informats. For more information about supported functionality and compatibility guidelines, See SAS Federation Server Driver for Base SAS .

SAP, SAP HANA

SAS Federation Server works with SAP and SAP HANA. For SAP installation and configuration, including connection options, see SAS Federation Server Driver for SAP . Connection options for SAP HANA are outlined in the SAS Federation Server Driver for SAP HANA ..

Apache Hive

Using the SAS Federation Server Driver for Apache Hive, SAS Federation Server can query and manage large data sets that reside in distributed storage. See the SAS Federation Server Driver for Apache Hive for connection information.

Third-Party Relational Databases

SAS Federation Server can access data in several third-party relational databases. The relational database drivers read, update, and create tables for those third-party relational databases on behalf of the Federation Server client. Each driver supports most of the FedSQL functionality. The Federation Server drivers support native database functionality by using the SQL dialect that is implemented by the third-party databases. For details about supported functionality and compatibility guidelines, see the specific data source reference:
Last updated: March 6, 2018