A
DSN is an object that encapsulates
data source connection information, such as the
table driver name, physical location of the data, and any necessary
authentication information that is required to retrieve data. A DSN is created in SAS Federation
Server Manager by a SAS Federation Server administrator. To obtain the name of a DSN
definition, contact a SAS Federation Server administrator.
By requiring users to reference a DSN, the SAS Federation Server administrator can
set authorization enforcement on data
access and make the DSN available only to authorized users.
A DSN is referenced by specifying the DSN definition name in the DSN= LIBNAME option.
DSN=dsn-definition
specifies the name of DSN definition that is defined on SAS Federation Server. DSN=
is a required argument.
Note: If the DSN definition name
is not a valid SAS name, enclose the name in quotation marks. If the
name contains single quotation marks, enclose the name in double quotation
marks, or use two single quotation marks in the name and enclose the
name in single quotation marks.
Other data source connection LIBNAME options are:
DSNUSER=userid
enables you to access a DSN with a user ID that is different from the default ID.
Alias: DSNUID=.
DSNPASSWORD=password
specifies the password
that is associated with the DSNUSER= user ID. Alias: DSNPWD=.
Within the LIBNAME statement, the DSN= options are specified after the
server connection arguments and before data source processing options, as follows:
libname lib3 fedsvr server="d1234.us.company.com"
port=2171 user="myid" pwd=mypwd
dsn="oradsn" preserve_col_names="yes" dbgen_name="dbms";