topic Establishing connecting between Postgresql and Data Integration Studio in SAS Programming

Establishing connecting between Postgresql and Data Integration Studio

edzy007 — Thu, 29 Sep 2022 08:36:13 GMT

Hi all!

As the title says, how can I establish a connection between Postgresql and Data Integration Studio?

Apologies if this question is vague. I am new to SAS.

Hope anyone can help point me in the right direction.

Thanks!

Re: Establishing connecting between Postgresql and Data Integration Studio

SASKiwi — Thu, 29 Sep 2022 21:44:48 GMT

To be able to do this you need a SAS/ACCESS product both installed and licensed, most likely SAS/ACCESS Interface to PostgreSQL or SAS/ACCESS Interface to ODBC. Run this program to confirm:

proc product_status;
run;

proc setinit;
run;

PRODUCT_STATUS will tell you what products are installed, SETINIT what products are licensed.