Connecting to an SQL Server database from Altair SLC on Windows


If you have data stored in a SQL Server database, you can connect using the ODBC Driver 11 for SQL Server Client. To install the client you need to:

  1. Download the ODBC Driver 11 for SQL Server from the Microsoft Download Center.
    Make sure you select the 64-bit connector to match the Altair SLC installation.
  2. On the same device as Altair SLC is installed, run the SQL Server installer.

Once the client has been installed, test the database connectivity with the following SAS language program:

LIBNAME DATASRC SQLSERVER USER=user-name PASSWORD=password 
SERVER=remote-id DATABASE=dbase;
PROC DATASETS LIBRARY=DATASRC;
RUN;