This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
User in account connection string unable to be validated via LDAP.
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:
Type over the value "__EncPwd1__" with the actual password and save it again.
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 Supportor 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.