Establishing connecting between Postgresql and Data Integration Studio

[edzy007]

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!

[SASKiwi · Accepted solution]

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.