Skip to main content

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:

  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:

Be the first to reply!

Reply