Because SAS Federation Server
supports several data sources, a broad range of database functionality
that is unique to each data source is provided. For example, a particular
data source provides transaction support while another data source
might not provide transaction support but supports indexes and integrity
constraints.
You must understand
database functionality and how its implementation affects processing,
performance, and integrity of your data in order to determine which
data sources are most appropriate for different types of applications.
Because database functionality is unique to each data source, you
cannot make assumptions about the data source to be accessed. For
example, an application cannot request a locking level just because
that locking level is more efficient. An application must respond
to the attributes of a SAS Federation Server
driver.
Database functionality
is applied through the SAS Federation Server driver when the application submits requests.
Requests can be in the form of FedSQL statements or the
SQL statements that are the implementation of the data service.
The supported data sources and connection options are presented in the following topics.
For information about
data type support, see the
SAS FedSQL Reference Guide.