SAS Federation Server
is a data server that provides scalable, threaded, multi-user, and
standards-based data access technology in order to process and seamlessly
integrate data from multiple data sources. The server acts as a hub
that provides clients with data by accessing, managing, and sharing
SAS data. It also supports several popular relational databases.
SAS Federation Server
provides a secure, blended, and virtual view of your data without
having to move it. Dynamic data masking, on-demand data quality, and
in-memory caching help to make information technology staff more agile
in responding to data provisioning requests from business users.
SAS Federation Server
supports native access to Oracle, Teradata, SQLServer, or DB2. The
Federation Server also supports the use of ODBC drivers not delivered
by SAS. Federation Server administrators create DSNs on the Federation
Server and provide access to users. Users can set up a Federation
Server DSN in the Data Management Platform that gives them access
to data without ever having to set up ODBC on their specific box.
SAS Federation Server
enables powerful querying capabilities and improved data source management.
With SAS Federation Server, you can efficiently unite data from many
sources, without moving or copying the data.
SAS Federation Server
provides the following data access capabilities:
-
a central location for setup and
maintenance of database connections.
-
access to popular database systems,
including DB2, Netezza, Oracle, SAP, SQL Server, PostgreSQL, Teradata,
and Greenplum.
-
ODBC and native drivers to connect
to select data sources.
-
threaded data access technology
that enhances enterprise intelligence and analytical processes.
-
multi-server services that enable
multiple clients to access the same data concurrently.
-
ability to reference data from
disparate data sources with a single query, known as data federation.
Also included is its own SQL syntax, Federated Query Language (FedSQL),
to provide consistent functionality that is independent of the underlying
data source.
-
a data abstraction layer, providing
the ability to present a consistent data model throughout the organization.
This abstraction layer is created with FedSQL views.
-
data access control with user permissions
and data source security.
-
federated view building application
that creates dynamic views of heterogeneous data and is made available
to other systems through ODBC, JDBC, or web services.
-
support for data masking, caching,
and in-view data quality transformations.
-
table-level, row-level, and column-level
data access controls.