In the Windows operating environment, use the Microsoft
ODBC Data Source Administrator to manage database drivers and data sources on DataFlux
Data Management Server. To add required stored credentials to Windows DSNs, use the
DataFlux Data Management Server’s administrative interface in SAS Data Management
Studio, as described in the following steps:
Note: To learn about DSN options,
open the Help for the ODBC Data Source Administrator.
Follow these steps to
configure a driver to connect to a database:
-
Click Start and
point to Settings.
-
-
Double-click Data
Sources (ODBC) to open the ODBC Data Source
Administrator dialog box.
-
Select the System
DSN tab and click Add.
-
Select the appropriate
driver from the list and click Finish.
-
Enter your information
in the Driver Setup dialog box and click OK when
finished.
-
To add required stored credentials to the
DSN, open SAS Data Management Studio, select the Administration riser, and expand DataFlux
Data Management Server.