Supported Data Sources :: SAS® Federation Server 4.2: Administrator's Guide, Second Edition

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
Memory Data Store	MDS	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: