Databricks primarily supports connections through its dedicated Databricks ODBC Driver and JDBC Driver. While OLEDB is more general, including ODBC functionality, Databricks recommends using its specific drivers for optimal performance and compatibility. 

Windows OS

1. One must have a Databricks database established or a trial of Databricks is acceptable: 
   
   Create an account on the Databricks Database.
   
   
2. After creating an account on the Databricks Database the setup will look as follows:
   
   
   
   How to establish Databricks ODBC connection:
   
   
3. The path should be SQL Server Warehouse>>Serverless Starter Warehouse.
   Click on Start Serverless Starter Warehouse in the Databricks dashboard. 
   Go to the tab Connection details. Copy the Server hostname and HTTP path.
   In this tab, create a personal access token, then save your token.
   
   
   
   
4. Now, we need to create a Database connection in Statistica hence click on Enterprise Manager and create a Database connection.
   
   
   
   
   
5. Click on Microsoft OLE DB Provider for ODBC Drivers and enter the connection string and then test the connection.
   
   The Connection string will be as follows:
   Driver={Simba Spark ODBC Driver};Host=<your-hostname>;Port=443;HTTPPath=<your-http-path>;SSL=1;ThriftTransport=2;AuthMech=3;
   
   Token can be created on Databricks by clicking on SQL Warehouses >> Serverless Starter Warehouse >> Connection Details >> Create a personal access token.
   
   
   
   
   
   
6. Create Data Configuration as below:
   
   
   
   
7. Explore DC and we can see data on Statistica.
   
   
   
   

This article will help to understand the process of creating database connection on Databricks database and then using the Databricks credentials to set the database connection on Statistica.

The first step is to download the ODBC driver (SimbaSparkODBC-2.9.1.1001-Windows-64bit) for Databricks from

https://www.databricks.com/spark/odbc-drivers-archive#windows