Create an ODBC DSN-less connection string for the Databricks ODBC Driver

This article describes how to create an ODBC Data Source Name (DSN)-less connection string for the Databricks ODBC Driver.

This article assumes that you have already gathered the following configuration settings:

To create an ODBC DSN-less connection string, construct the string in the following format. Line breaks have been added for readability. The string must not contain these line breaks:

Driver=<path-to-driver>;
Host=<server-hostname>;
Port=443;
HTTPPath=<http-path>;
SSL=1;
ThriftTransport=2;
<setting1>=<value1>;
<setting2>=<value2>;
<settingN>=<valueN>

To get the value for <path-to-driver>, see Download and install the Databricks ODBC Driver.
To get the values for <server-hostname> and <http-path>, see Compute settings for the Databricks ODBC Driver.
<setting>=<value> is one or more pairs of authentication settings and any special or advanced driver capability settings.

Next steps

To use your DSN-less connection string with your target app, tool, client, SDK, or API, see Technology partners or your provider’s documentation.