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.
Solved! Go to Solution.
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.
Hi geraldo