how can i connect to aws aurora from sas EG

Pato485 — Fri, 04 Nov 2022 14:19:32 GMT

Is there any possible way to connect to postgresql from sas EG - program?

Tried this but it is not working from program in sas EG:

DRIVER=SQL;CONOPTS=((DRIVER=POSTGRES;CATALOG=public;UID=myuid;PWD=123pass;
SERVER=aurora-instance-1.ctkz01uv9xcr.us-east-1.rds.amazonaws.com;
PORT=5432;DB=aurora))

Thanks for any help.

Re: how can i connect to aws aurora from sas EG

LinusH — Fri, 04 Nov 2022 14:36:30 GMT

You probably can, but there are of course some constraints.

Your "code" is the definition of a data source.

To able to actually connect to the source from SAS, you need to submit a LIBNAME statement, which in return refers to the information you provided.

Exactly depends on your set up (EG connects to SAS server or local PC SAS), your SAS license (SAS/ACCESS to....), and of course possibility to connect to that data source given firewalls etc.

This is for Postgres SAS/ACCESS engine, might be slightly different if you are using SAS/ACCESSS ODBC engine:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/p0nc2tikruabp6n1008nkdf0buee.htm

topic how can i connect to aws aurora from sas EG in SAS Enterprise Guide

how can i connect to aws aurora from sas EG

Re: how can i connect to aws aurora from sas EG