In
order to connect to a data source, the FedSQL language requires that
a connection string be submitted that defines how to connect to a
data source.
The FEDSQL procedure generates
a connection string by using the attributes of currently assigned
librefs. You first submit a LIBNAME statement for the data source
that you want to access (for example, a Base SAS LIBNAME statement
or a Hadoop LIBNAME statement) and then submit PROC FEDSQL.
For more information,
see FEDSQL Procedure in Base SAS Procedures Guide.The SAS Federation Server
LIBNAME engine obtains a data source connection by connecting to a
SAS Federation Server and specifying a DSN that is defined on SAS
Federation Server. You specify server connection properties and the
DSN in a LIBNAME statement. You must have been given the name of a
DSN by a SAS Federation Server administrator, and be familiar with
the names of the catalogs and schemas accessed through the DSNs in
order to access data. For more information, see
SAS LIBNAME Engine for SAS Federation Server: User's Guide
SAS Scalable Performance
Data Server generates a connection string to the FedSQL language when
you use the SQL pass-through facility and set the SQL dialect using
the EXECUTE statement:
Execute(reset dialect=fedsql)
See
SAS Scalable Performance Data Server: User's Guide.
SAS Federation Server encapsulates
the information that is needed to connect to a data source in a Data
Source Name (DSN) definition. A DSN is metadata that contains connection
details. DSN definitions are created by a SAS Federation Server administrator.
In order to use a DSN, you must first connect to SAS Federation Server.
For more information about connecting to SAS Federation Server and
submitting DSNs, see
SAS
Federation Server: Administrator’s Guide.