Symptoms:
Error while trying to connect O&DQ to Databricks using JDBC driver. The user receives the error message "Keyword not supported".
Error: "Keyword not supported"
Resolution:
-
Install ODBC Driver: Ensure that the Databricks ODBC driver is installed on the gateway server.
-
Download the ODBC driver from the Databricks website: Databricks ODBC Drivers.
-
Install both the 32-bit and 64-bit versions of the driver.
-
Configure ODBC Data Source: Set up the ODBC data source on the gateway server.
-
Open the ODBC Data Source Administrator.
-
Add a new data source and configure it using the Databricks ODBC driver.
-
Save the connection details, including the token, in the ODBC data source configuration.
-
Use ODBC Data Source in O&DQ: Configure O&DQ to use the ODBC data source.
-
In O&DQ, create a new data provider using the ODBC data source.
-
Use the connection string format:
DSN=<Name of ODBC connection>
.
-
Test Connection: Verify the connection in O&DQ.
-
Ensure that the client does not hang and that the connection test completes successfully.
Reference Ticket:
33228