See also ODBC driver capabilities for more driver configurations. The installation directory is /Library/simba/spark.Ĭhoose a Data Source Name and create key-value pairs to set the mandatory ODBC configuration and connection parameters.
See Download the ODBC driver.ĭouble-click on the dowloaded.
dmg file to install it.ĭownload the latest driver version for macOS, if you haven’t already done so. To set up a DSN on macOS, use the ODBC Manager.ĭownload the ODBC Manager and double-click on the downloaded. In macOS, you can set up a Data Source Name (DSN) configuration to connect your ODBC client application to Databricks. Install and configure the ODBC driver for macOS Select the Simba Spark ODBC Driver from the list of installed drivers.Ĭhoose a Data Source Name and set the mandatory ODBC configuration and connection parameters. Go to the User DSN or System DSN tab and click the Add button.
Navigate to the Drivers tab to verify that the driver (Simba Spark ODBC Driver) is installed. The installation directory is C:\Program Files\Simba Spark ODBC Driver.įrom the Start menu, search for ODBC Data Sources to launch the ODBC Data Source Administrator. To set up a DSN configuration, use the Windows ODBC Data Source Administrator.ĭownload the latest driver version for Windows, if you haven’t already done so. In Windows, you can set up a Data Source Name (DSN) configuration to connect your ODBC client application to Databricks. Install and configure the ODBC driver for Windows
Query_text - The SQL statement you want to execute.Ĭol_names_logical - True or False to specify if column names are returned as part of the result. 4 = dialog is not displayed and an error is returned if unsuccessful 3 = dialog is only displayed when there is insufficient information (options are not available). 2 = dialog is only displayed when there is insufficient information (options are available). Output_ref - This is only relevant when you are not calling this function from a worksheet.ĭriver_prompt - The option for whether the driver prompt dialog box is displayed.
SQL.REQUEST(connection_string, output_ref, driver_prompt, query_text, col_names_logical)Ĭonnects to an external data source and executes a query.Ĭonnection_string - The data source name, user id and password required by the driver. The add-in has the filename "XLODBC.xla" and was installed in the following folder by default:Ĭ:\Program Files\Microsoft Office\Office10\Library\Msquery\ This add-in was not installed as part of the normal installation but could be downloaded from the Microsoft website. This is short for Open Database Connectivity and allows you to connect to external data sources using ODBC drivers and the SQL.REQUEST function. This was replaced with ActiveX Data Objects.