03-16-2018 07:47 AM - edited 03-16-2018 07:48 AM
Please request your help on setting up PostgreSQL connection via SAS Accessand we do not want to set-up using ODBC connection.
In regards to the same, Do we need to install PostgreSQL client software in SAS servers and any change required in any of the configuration files to update the PostgreSQL server details.
Note: SAS 9.4 on Windows Env
Appreciate your help on this.
03-16-2018 10:12 AM
First thing you need to check is whether you have Licence to SAS/Access interface to PostgreSQL.
You can do this by running
If you don't have licensed then use ODBC. My suggestion is using ODBC connection and avoiding new setup connection hazels.
03-16-2018 11:48 AM - edited 03-16-2018 11:56 AM
Thank you. We have License and we don't want to connect via ODBC. As mentioned, I am looking for some suggestions as mentioned earlier.
03-17-2018 03:53 AM
03-18-2018 07:55 AM
What you need to have deployed on the system to have the SAS/ACCESS Interface to PostgreSQL access product work are documented in this system requirements documentation.
You just need to ensure the client libraries location is included in the PATH environment variable.
There is no configuration updates required in the SAS configurations to get this access product to work.
03-19-2018 03:51 AM - edited 03-19-2018 03:52 AM
Thank you Simon and Can you please share some details and as I am very clear what to do from SAS SMC side. But I am still not sure, on how to set-up connection from Server front.
How do we ensure, our SAS servers can interact/recognise the Third Party Postgre SQL server and this is can achieved only when we install and configure the PostgreSQL. Please correct if I am wrong and this is where I am not clear on how to do it.