I have many jobs that require me to pull data from a MYSQL database over a VPN. I'd like to issue a SAS command to launch the Cisco VPN client and log in automatically insteead of having to manually log in each time. Is that possible from SAS? I use SAS to launch other things like EXcel and Outlook and issue commands to those applications but I can't find anything that looks like what Iam trying to do with the VPN. Thanks.
Can you create a shortcut for the VPN client and simply launch the shortcut?
The problem isn't so much launching the actual program but selecting the connection and passing the log-in info from SAS to the Cisco client to complete the connection.
Can that info be saved in the shortcut? I haven't used a Cisco client, but have always been able to setup shortcuts to include all necessary ids and passwords.
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.