Skip to main content

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

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:

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings