Domain-enabled
ODBC connections use a domain and credentials that are supplied by a SAS Metadata Server.
You can create domain-enabled ODBC connections for use with jobs that run on the DataFlux
Data Management Studio host, or that run on a DataFlux Data Management Server host.
If you create a domain-enabled ODBC connection for use with Studio, and if you want
to move that connection to a DataFlux
Data Management Server, then you copy the .dtfk file
from the client to the DataFlux Data Management Server. The destination
directory is install-path\etc\dftkdsn.
To execute jobs, the
DSN in the domain-enabled ODBC connection must be defined in a location that is accessible
to the DataFlux Data
Management Server. Otherwise, the reference to the DSN in the domain-enabled ODBC
connection will not resolve.
To create a new domain-enabled ODBC connection for use on the DataFlux Data Management
Studio host, see the Data Management Studio User's Guide.
To create a new domain-enabled ODBC connection for use on the DataFlux Data Management
Server host, follow these steps:
-
Open a DataFlux Data
Management Server using the riser bar in DataFlux Data Management
Studio and log on if prompted.
-
Click the Data
Connections tab and click New.
-
Select Domain
Enabled ODBC Connection from the drop-down menu.
-
In the Name field,
enter a name for the connection, preferably referring to the domain
that was created on the SAS Metadata Server.
-
Enter some information
about the domain and connection in the Description field.
-
-
In the Domain
name field, enter the actual domain name as it was created
in the SAS Metadata Server.
-
The new connection places
a .dftk file in the install-path\etc\dftkdsn.