I am currently using Base SAS 9.3 & SAS/ACCESS to MySQL but I am having diffuclty establishing an SSL connection with a server using SAS/ACCESS. What is the format for making a SSL connection using SAS/ACCESS or do I have to use a different method?
Thanks.
libname test mysql user=testuser password=test database=test server='test.amazonaws.com' port=3306 BULKLOAD=YES;
Wow, it looks like somebody pushed that button, and I did actual work, but not "real" work. Real work would be coding.
Hat tip @JYus for pointing out that SAS has implemented this.
Hi,
Unfortunately, connecting to MySQL from SAS/ACCESS using SSL is not supported.
If you like, you can make a feature request via the following link. I know the feature has been requested, but it doesn't hurt to pile-on just a little.
Go to http://support.sas.com. And look at the bottom left of the page.
If you need any assistance, holler.
Best wishes,
Jeff
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.