In the Windows operating environment, use the Microsoft
ODBC Data Source Administrator to manage database drivers and data sources on a 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 the DataFlux Data Management Server.