Components of SAS Federation Server

SAS Federation Server consists of a set of components that provide the functionality that is required by data integration, business intelligence, and analytic processing. SAS Federation Server provides several types of drivers that you use to connect to the server. The following topics describe the drivers that are available with SAS Federation Server.

A SAS Federation Server driver interacts with a data source to read and write proprietary file formats. Each supported data source has a driver that communicates with the data service in its own language to resolve data access requests, and to manage physical files and database tables. For example, to process an SAP table, an application uses the SAS Federation Server Driver for SAP, and to process an Oracle table, an application uses the SAS Federation Server Driver for Oracle.

A Federation Server driver provides connectivity to and from the data source, submits SQL statements to the data source, and sends data to and from the data source. That is, a Federation Server driver receives an SQL expression as input and returns the result as output. Each Federation Server driver supports the database functionality of the underlying data source.

For more information about the supported data sources and their connection options, see the SAS Federation Server Driver Reference .

Language drivers implement the SAS Federation Server languages by processing a request and sending the parsed query to the appropriate Federation Server driver that satisfies the request and returns the result. The multi-threaded languages provide a powerful way to create and query data. SAS Federation Server supports FedSQL and DS2 languages.