Domain-enabled
ODBC connections use a domain and credentials that are supplied by a SAS Metadata Server or a DataFlux Authentication Server.
You can create domain-enabled ODBC connections for use with jobs that run on the 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 into the directory 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 registered Data
Management Server using the riser bar in 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 in Authentication 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 Metadata Server or Authentication Server.
-
The new connection places
a .dftk file in the install-path\etc\dftkdsn.