DSN-less Databricks Connection

[Fernandesfiona]

Hi All,

I'm fairly new to  Alteryx and want to connect to Databriack ODBC via DSN-less  

please suggest/help with step by step process and the string to use 

[bensilv]

Hi @Fernandesfiona,

Please take a look at this post: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-format-common-ODBC-DSN-less-...

There are a variety of examples to try for DSN-less connections.

Let me know if that helps!

Ben

[sophiaabigail]

 Install and configure the ODBC driver for Linux. In Linux, you can set up a Data Source Name (DSN) configuration to connect your ODBC client ... A Data Source Name 192.168.l.254   (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the driver and other information that is required to access data from a data source. Go to the User DSN or System DSN tab and click the Add button. Select the Simba Spark ODBC Driver from the list of installed drivers. Choose a Data Source Name and set the mandatory ODBC configuration and connection parameters. See also ODBC driver capabilities for more driver configurations