How should I connect Postgresql 13 from Alteryx Designer

Question

Hello All,

'Postgresql 13' is installed in my local machine.

How should I connect it from Alteryx Designer Version: 2023.1.1.200 Patch: 1 for the first time.

I'm getting a connection error im002 microsoft odbc driver manager data source name not found and no default driver specified.

I've attached all the screenshots step by step, It will be helpful if someone help me on this.

Screenshots.zip

ArnaldoSandoval · Accepted Answer

Hi @RE5260

As suggested by @geraldo you should use ODBC, I tried PostgreSQL's Quick connect option and it failed with the same error as yours, see below

The I choose the ODBC option and it worked, below the screenshot sequence just for information.

Before doing this I added PostgreSQL to my ODBC-64 on Windows, with the name shown in the screenshot.

Then I added the Connect Credentials and tested it.

continueing the history board

then within my Input Data tool connection, I was able to navigate PostgreSQL to pick up tables.

Yes, I got an error with the first table I tried, because it was empty 😮

Finally I choose a table with date "select tiget.state_lookup.* from tiger.state_lookup" getting the results shown below.

Hope this helps,

Arnaldo

PS: I don't attach the workflow because it wont work on your environment.

RE5260 · Accepted Answer

Hi geraldo

ODBC driver already installed in my system.