Defaulting to Teradata DSN User and Password Throws Error Message: Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]

[JLinAltX]

Error: “Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]”

 

Environment Details

 

When defaulting to the Teradata user and password stored in the DSN to make a connection, Designer throws a Table List Error message regarding the password.

Table List Error: Error SQL[DriverConnect: [Teradata][ODNC][10380] Unable to establish connection with data source. Missing settings: {[Password}]

 

• Alteryx Designer
  • All
• Teradata Database 
  • v16
• Teradata Database ODBC Driver 16.20.00.108, 16.20.00.110

Cause

The issue is not with Alteryx but with the Password string value not being written into the Teradata ODBC Registry Key.

 

Spoilers

In Windows REGEDIT go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<Name of your ODBC DSN> and you will see that that Password string value is missing.

Resolution 1

We have only noticed two affected versions so far: 16.20.00.108, 16.20.00.110.  The ODBC version that we have found to not have this issue is 16.20.00.098.  Beyond this, you will need to try different versions of the ODBC driver or contact Teradata.     
 

Resolution 2

Enter in the user name and password directly into the ODBC prompt when setting up the connection in the workflow.

Additional Resources

 

• Please note that per Teradata documentation, it strongly advised against storing password in DSN