12/23/2023 0 Comments Aws redshift odbc![]() ![]() Keep in mind that the Driver Manager and the Driver are 2 very different things! If you are missing ANY of these, you will not be successful! A Security Group in AWS that allows the SAS server to connect to Redshift.A Driver Manager (because we are working on Linux).Configuring a connection to AWS Redshift.My post only deals with how to successfully install the Redshift drivers onto a RedHat Linux server. If that is of interest to you, I recommend my colleague James Ke Wang's paper, Step into the Cloud: Ways to Connect to Amazon Redshift with SAS/ACCESS®. Secondly, using Redshift from SAS is a wider topic that deserves its own discussion. If that is the case, feel free to comment below this post. I am by no means an expert in these matters, so it's possible that there is a better way to do these things. I can find it when I have to do this again in a few months.So, for my own future benefits (and hopefully, your present benefit), I decided to write this how-to, in the hope that: ![]() I, for one, do it so seldom that I can never remember the steps from one time to the next. (If that is not the case, your SAS libnames will not work any better, and can actually mask the problems further.)Īnd yet, these are not things that we typically have to do on day to day basis. As many SAS Administrators and Architects know, before any SAS/Access engine can access any database, the proper database clients or ODBC configurations have to be present and successfully tested. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |