Am trying to set up a libname connection to redshift on SAS 9. I've created the database, set up the IAM rules, opened the inbound ports, installed the amazon drivers and updated the odbc.ini and odbcinst.ini
I am able to connect and run SQL from commandline using:
isql -v "redshift" awsuser mypass
However when I run in SAS Studio I get the following:
So the issue is somewhere here:
ERROR: CLI execute error: [
There's definitely something shifty going on. If you've red this far, would appreciate some pointers!
/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya -
Data ControllerDevOps and AppDev on SAS 9 / Viya / Base SAS -
SASjs