When I search for SAS Access to Sybase I tend to find a lot of information on how to code my SAS script, what engine to use and some of the options available. But details on the configuration are few and far between. So, I thought I would write a blog about each one, so the next time I search I’ll be able to find a reference.
The key file for Sybase is interfaces.
The interfaces file is typically local to the server so you will need to update it on all of your compute servers.
If using Linux or similar be careful updating it using ftp as this can corrupt the file, I choose to use the VI editor.
Now you know what to update and how, you just need to find it. You can search for the interfaces file, read your SAS installation documentation or ask a friendly Sybase DBA. Here is a place you could look:
When you find the file, a connection string will look similar to this. There are a few variations so don’t be concerned if yours is not the same.
master tcp ether beamdwh.db.optimalbi.com 15113
query tcp ether beamdwh.db.optimalbi.com 15113