SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

connecting to MYSQL from SAS Miner

Reply
Occasional Contributor
Posts: 5

connecting to MYSQL from SAS Miner

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?

 

Super User
Posts: 4,032

Re: connecting to MYSQL from SAS Miner

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;

Ask a Question
Discussion stats
  • 1 reply
  • 96 views
  • 0 likes
  • 2 in conversation