This section describes
how to configure ODBC connections for SAS Federation Server
in a Windows environment.
To access a database
through ODBC with SAS Federation Server, a driver
for ODBC for the specific database must be used. SAS Federation Server
comes with the ODBC drivers for several databases. The database and
database connection must also be configured as an ODBC data source.
To access a database
through a vendor supplied client, the client must be installed and
configured according to the vendor documentation.
To add an ODBC data
source, use the ODBC Data Source Administrator in
Microsoft Windows. To set up a new ODBC connection:
-
Click
Start
Control Panel.
-
Double-click
Administrative Tools
Data Sources
(ODBC).
Note: In Windows 7, the view of
the Control Panel can vary. If you do not see Administrative Tools
when you open the Control Panel, click System and Security to access
Administrative Tools, Data Sources (ODBC).
-
-
In the
ODBC Data
Source Administrator window, select the driver that is
appropriate for your data source.
-
In the
ODBC Driver
Setup dialog box, enter the Data Source Name, Description,
and database-specific configuration options. These values are required,
and can be obtained from your database administrator.
Use the vendor supplied
client configuration utility for connections that are not ODBC.