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:
- 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.
- 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
PROC DATASETS LIBRARY=DATASRC;
- In the LIBNAME statement, replace user-name and password with your user name and password for the remote-id server, and replace dbase with the name of the SQL Server database.
- The DATASETS procedure returns the names of all tables in the selected database; for databases with large numbers of tables, this program might take some time to run.