@Bob_Deployment Thank you very much useful info. But just to highlight you that - We would like to set-up connection to a Third party PostgreSQL Database from our SAS Windows servers by using SAS/ACESS and agree with you on all options from SAS side. I believe and my assumption - PostgreSQL which comes along with SAS\SWebInfrastructurePlatform is only for SAS VA purpose only and this is not useful to connect to external PostgreSQL DB's. Please correct me if I am wrong. By considering above cases - As you suggested, we may install PostgreSQL client software on SAS servers and then set-up the connection. My question here, What is configuration file that we need to modify to update the Database details and port etc ( For example; tnsnames.ora that we do for Oracle or SQL server etc) as I am not clear on the config file for PostgreSQL Thank you.
... View more