- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi all,
I usually connect to redshift via odbc on sas 9.4, but in my SAS-hosted environment I am unable to locate a libname statement that works.
My Redshift server is usually accessed by a url, port, and database name.
Can anyone direct me to the correct libname format? ODBC libnames provide the following error:
CLI error trying to establish connection:[unixODBC]Driver Manager]...
thanks in advance!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If your SAS Viya environment has not been configured for use with Redshift a LIBNAME alone is unlikely to work. Do you have a Viya administrator contact?
Viya typically runs on linux so odbc.ini needs to be configured.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I found this really helpful documentation, but I am still having problems:
SAS Help Center: LIBNAME Statement for Amazon Redshift
There is a lot of configuration on my DSN or odbc.ini file and I'd think it's best just to utilize that. Any idea how I can best pass this through and reference in on SAS Viya?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If your SAS Viya environment has not been configured for use with Redshift a LIBNAME alone is unlikely to work. Do you have a Viya administrator contact?
Viya typically runs on linux so odbc.ini needs to be configured.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@SASKiwi I have SAS admin contact, and I am afraid you're right. The environment is likely not configured for Redshift.
If I supply an odbc.ini to my administrator, theoretically they should be able to save it on the linux environment and then a libname alone should work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@illmatic - I would have thought it would be your administrator who would ensure that whatever Redshift configuration is done actually works. They should be across this sort of stuff and know what to do to get it working.