The Data Management Server connects to data sources on databases through
ODBC or through jobs that connect to the Federation Server. For more information about accessing data on or through a Federation
Server, refer to the
DataFlux
DataFlux Data Management Studio User’s Guide and
to the
DataFlux Federation Server Administrator’s
Guide.
To add a data source using ODBC, use the ODBC Data Source Administrator provided with Windows, or use the dfdbconf command
in UNIX and Linux.
You can configure the
following data connections (also known as DSNs or data sources) for
the jobs that you run on the DataFlux Data Management Server:
-
Domain-Enabled ODBC
Connection - Enables you to create a connection that links a DataFlux Authentication Server domain to an ODBC Data Source Name (
DSN). User credentials from the Authentication Server are automatically applied when the user accesses the domain-enabled connection.
This approach ensures that the appropriate credentials for that domain are applied to the access request.
-
Custom Connection - Enables you to create a custom connection string for non-ODBC connection types. These custom strings enable you to establish
native connections from a SAS Federation Server to third-party
databases or to draw data from more than one type of data input.
-
SAS Data Set Connection -
Enables you to create SAS data set connections.
In Windows, DSNs are
stored in install-path\etc\dftkdsn.
In UNIX and Linux, DSNs
are stored in install-path/etc/odbc.ini.
You can store ODBC credentials for data sources that require login credentials with the ODBC
Credential Manager. With stored ODBC credentials, you can make connections to data sources without being prompted for login credentials. When
a job is run, the
saved user credentials are retrieved and used. The credentials are not stored within the job. The job references the connection
by DSN only. In UNIX and Linux, credentials are stored in the directory /$HOME/.dfpower/dsn.
When you develop jobs and services in DataFlux Data Management Studio, use the Data Connections riser to set up and store
login credentials for any Open Database Connectivity (ODBC) data source. The DataFlux Data Management Server can use these
data sources directly if Studio is installed on the same
host as DataFlux Data Management Server.
Stored credentials do
not have to be entered each time the job is run, and that information
can be used by any DataFlux application. If you do not use stored
credentials, then your job must authenticate through a Metadata Server
or Authentication Server.
Use global variables
within jobs and services to accept or retrieve data. Using global
variables increases the flexibility and portability of Studio jobs
and services between data sources.
If you want to use ODB drivers other than those that are supplied, note that the Data Management Server is compatible with
most ODBC-compliant data sources. Also note that SAS provides limited support for drivers that are not supplied by SAS.
If you develop jobs
that access a SAS Federation Server, then you can use JDBC drivers
and other drivers that are written for native access to popular databases.
To learn more about developing jobs that use Federation Server drivers,
refer to the DataFlux Data Management Studio User’s
Guide and to the SAS Federation Server Administrator’s
Guide.