I have a SQL database on an EC2 server set up by my company. In the past, this database was in a different location, where i set up a simple ODBC connection through the typicaly ODBC Administrator in Windows, connect through a VPN, and read data from tables directly into SAS. For the new version of the database, they have told me to connect using a jump host. I have successfully made use of the jump host information (including a .pem key file) and the database ODBC information to connect using the mySQL Workbench utility. Now, i want to be able to connect directly through SAS. The ODBC Administrator doesn't seem to be set up for accommodating jump host setups. Is there a pass-through work-around for this? Really, i'm looking for a step-by-step example of how to connect? I have Base SAS, SAS ACCESS, and SAS CONNECT at my disposal. Thanks, Jason
... View more