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 the DataFlux Federation Server Manager by a DataFlux
Federation Server administrator. To obtain the name of a DSN definition,
contact a DataFlux Federation Server administrator.
By requiring users to
reference a DSN, the DataFlux 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= argument
of the LIBNAME statement.
- DSN=dsn-definition
-
specifies the name
of DSN definition that is defined on the DataFlux Federation Server.
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.
- DSNUSER=userid
-
specifies a user ID
or shared login that is defined for the DSN definition. SAS data sets
do not support a user ID or password for a DSN definition. Alias:
DSNUID=.
- DSNPASSWORD=password
-
specifies the password
that is associated with the DSNUSER= user ID. Alias: DSNPWD=.
Within the LIBNAME statement,
the
DSN= arguments 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";