How should I connect Postgresql 13 from Alteryx Designer
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)