Connecting PostgreSQL

[urezwan]

I am trying to connect PostgreSQL to Alteryx. I cannot connect. Here are the two windows:

My pgAdmin, the Postgres studio, loads on a net browser because I do not have the icon on my desktop or other drive. I can work with the psql shell.

Any help?

[BrandonB · Accepted solution]

You will want to click the ODBC Admin button and create a connection with the information for your Postgres database. After doing so it will appear in the dropdown list that currently says "No ODBC DSNs Available". More information about Postgres in Alteryx can be found here: https://help.alteryx.com/current/designer/postgresql

[urezwan]

I did not know I would have to install ODBC connector. I did and it nos works. Thanks!

[ramesh_neel]

@BrandonB  - Picking up this old thread ! How do we create a gallery connection to PostgreSQL? Is there a way to do that?

[apathetichell]

Are you using a DSN - or is it a DSN less connection?

[BrandonB]

@ramesh_neel I like to use the site connectionstrings.com (not affiliated with Alteryx) as a reference for gallery connection strings. 

This page covers the structure of a PostgreSQL connection string: https://www.connectionstrings.com/postgresql-odbc-driver-psqlodbc/ 

 

[ramesh_neel]

@apathetichell  - I was able to create a successful DSN connection on the server designer but needed a DSN less gallery connection as well.

@BrandonB  - Thanks for pointing me to the site . The syntax provided there didn't work on Alteryx but was a good starting point (Alteryx did not recognize it a connection at all ) and @CathyH from Alteryx support helped me  fix the issue by changing the format of the string to the below .

odbc:Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

In our case providing the IP did not work either so had to use the actual server name .

Thank you all your for all the help!

Cheers,

Ramesh