Connecting to a MySQL database from Altair SLC on Windows


If you have data stored in a MySQL database, you can connect using the MySQL Connector/C client. To install the client you need to:

  1. Download the MySQL Connector/C client installer (.msi) from the MySQL Download Connector/C page of the MySQL website.
    Make sure you select the correct connector to match the 64-bit Altair SLC installation.
  2. On the same device as Altair SLC is installed, run the MySQL installer (.msi).
  3. Add the MySQL Connector/C client installation folder containing the file libmysql.dll to the system PATH variable:
    • In the Windows Control Panel/System and Security. Select System and click Advanced System Settings.
    • In the Advanced tab, click Environment Variables.
    • Select the PATH entry in System Variables and then click Edit.
    • In the Edit environment variable dialog box, click New and enter the installation folder path.
    • Click OK to save the changes, and close the remaining system and security dialogs by clicking OK each time.

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

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