Supported Data Sources :: SAS(R) Federation Server 3.2: Administrator's Guide

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. Remote 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®, and several third-party relational databases.

The following table lists the data sources with their supported data service types:

Data Sources	Data Service Types	Default Drivers	Supported Drivers
SAS data sets	BASE	BASE	BASE
DB2	DB2UNXPC	DB2	ODBC, DB2
Greenplum	Greenplum	Greenplum	ODBC, Greenplum
Oracle	ORACLE	ORACLE	ODBC, ORACLE
SAP	SAP	SAP	SAP
SQL Server	SQLSERVER or SQLSVR	ODBC	ODBC
Teradata	TERADATA	TERADATA	ODBC, TERADATA
ODBC_FED	Native Catalogs	ODBC	ODBC
ODBC	Logical Catalogs	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. A supported SAS data set uses the extension .sas7bdat.

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 Data Set Reference.

SAP

For information about supported functionality and compatibility guidelines, See SAP Reference .

Third-Party Relational Databases

SAS Federation Server can access data in several third-party relational databases, including DB2, Greenplum, ODBC data sources, Oracle, and Teradata.

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: