Error: 'Keyword not supported' while Connecting O&DQ to Databricks using JDBC¶

Symptoms:¶

Error while trying to connect O&DQ to Databricks using JDBC driver. The user receives the error message "Keyword not supported".

Resolution:¶

1. 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.

1. 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.

1. 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>.

1. 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

Reference Links:¶

• Databricks ODBC Drivers