🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Connecting to an SQL Server database from Altair SLC on Windows

User: "IanBD"
Altair Employee
Updated by IanBD

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;
  • 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.

Comments

No comments on this post.