Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Gallery Data Connections for Greenplum Throws Error: LDAP Authentication Failed For User

JLinAltX
Alteryx
Alteryx
Created

‎02-25-2021 01:51 PM - edited ‎07-22-2021 12:50 PM

Environment Details


Using a Greenplum connection from the Gallery Data Connections resulted in the error:
 

Connection Error:
ERROR [0800] FATAL: LDAP authentication failed for user "service account"



 
  • Alteryx Designer
    • All versions
  • Alteryx Server
    • All versions
  • PostgreSQL ODBC Driver (Note: Greenplum uses PostgreSQL ODBC Driver)​​​​​​​


Cause


User in account connection string unable to be validated via LDAP.



Resolution


Resolution 1

In the Gallery Data Connections, retype the password for the Greenplum connection that is failing.  Once you click save, the password will be encrypted again.

For example, when you click on the connection, you will see this type of connection string:

   odbc:DSN=Greenplum;UID=jlin;PWD=__EncPwd1__

Type over the value "__EncPwd1__" with the actual password and save it again.




Resolution 2

1. From the ODBC Data Source Administrator in Windows, test the existing System DSN or User DSN on the machine.  If the test fails, ensure the correct password was entered or contact the organization's IT Admin or Database Administrator for further assistance.



2. If the ODBC test is successful, on a new workflow, drag a new Input Tool in Designer.  Go to Data sources > ODBC under the appropriate Database platform and select the same DSN that tested successfully.  

If this still fails, check the version of the Greenplum ODBC drivers and compare it with the version Alteryx officially validated them on, per the Alteryx Help page.  While it may not always be the case, some ODBC versions that are too old or too new may not work with the version of Designer.  Contact Alterxy Support or check Community if further assistance is needed.

3. If the new connection created on the test workflow works, copy the connection string and save it as a new Galley Data Connection.  Remember to type over the encrypted password by re-typing in the password in plain text and then save, which will encrypt the password again.

0 Likes