topic connecting to MYSQL from SAS Miner in SAS Data Management

connecting to MYSQL from SAS Miner

Sivateja — Fri, 29 Jun 2018 20:51:46 GMT

Hi Guyz,

I was just wondering if I can connect to MYSQL database from SAS Miner Workstation 14.1 and update tables in the database?

Can you take me through the steps?

Re: connecting to MYSQL from SAS Miner

SASKiwi — Fri, 29 Jun 2018 23:31:23 GMT

To connect to MySQL you will need either SAS/ACCESS to MySQL or the more general SAS/ACCESS to ODBC products. These aren't necessarily bundled with SAS Enterprise Miner. You can confirm what products you have licensed by running this code: proc setinit noalias; run;

Re: connecting to MYSQL from SAS Miner

Sivateja — Thu, 31 Jan 2019 19:05:52 GMT

HI, I do have SAS/ACCESS I checked its status by proc product_status; still I'm not able to connect to MySQL it is throwing me an error in the log saying

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be
loaded.
ERROR: Error in the LIBNAME statement.

The code I'm using is:

libname mysqlib mysql user=XYZ password=XXXXXXXXXX database=database name

server=mysqlserv port = 3306;

proc print data = Siva.Table;
run;

Please let me know if I'm missing something

Re: connecting to MYSQL from SAS Miner

SASKiwi — Thu, 31 Jan 2019 21:49:21 GMT

Looks like this SAS Note is relevant: http://support.sas.com/kb/19/250.html

Re: connecting to MYSQL from SAS Miner

SimonDawson — Tue, 05 Feb 2019 21:46:02 GMT

@Sivateja please consult the Configuration Guide for SAS® 9.4 Foundation for Microsoft Windows for x64 manual here. There is a section titled "SAS/ACCESS Interface to MYSQL" please review that section and follow the steps.