Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Connecting PostgreSQL

Loperal
8 - Asteroid

Hi there, 

 

I am trying to connect to a PostregSQL, so far when I do the ODBC connection worksfine (at least the test seems to work), whenever I am trying to use Alteryx its telling me something is wrong. Never work before with a PostgreSQL so I am not sure I am doing something wrong... needless to say the password is the same I did in the ODBC test, maybe the user needs to be entered in a different way...

 

any ideas

 

Loperal_0-1646039023538.png

Loperal_2-1646039235688.png

 

 

2 REPLIES 2
TheOC
16 - Nebula
16 - Nebula

hey @Loperal 

I found this, which may be useful:
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Error-quot-FATAL-no-pg-hba-conf-entry...

Cheers,
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
VojtechT
Alteryx Alumni (Retired)

Hi @Loperal , this might be a long shot, but I know that some other data sources are struggling when the password is using some special characters, especially ; or @. 

Is it possible that your password is using any special character?

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
Labels
Top Solution Authors