Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Help: Issues with proper ODBC Impala Connection String


Help: Issues with proper ODBC Impala Connection String

New Contributor



I am having difficulty connecting to Impala.  We have been succesful in the past connecting to Impala from local desktop but now need to make this connection on a server that has ODBC set up. 


Everytime I try to make the connection I get the error that Data Source Name not found and no driver specified...I have confirmed that the DSN is correct and that the Clouder ODBC Driver for Impala is installed on the server


Data Source Name: ECM_SDM

Mechanism: SASL User Name and Password (SSL)

Host: "my confirmed host name"

Port: 21050

Transport Buffer SIze:1000


Connection String: - I have tried different variations of this but have had no luck


odbc:DSN=ECM_SDM;Driver=Cloudera ODBC Driver for Impala;Host= "My Host Name";UID="My UID";PWD="My Password";Port=21050;


Any support is greatly appreciated!




Don't have an account?
Coming from Hortonworks? Activate your account here