Connecting to an SQL Server database from Altair SLC on Windows

IanBD
IanBD
Altair Employee
edited September 2022 in Altair RapidMiner

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.