Hello,
Thanks for your answer.
Using DBeaver I can check the class name in the jar file so I am using the same class name in CA and DBeaver.
I'm using the same configuration in CA in DBeaver, including the jar file, and both have the same error - works in DBeaver, error message in CA
------------------------------------------------------SIMBA JDBC DRIVER:SimbaSparkJDBC42-2.6.22.1040.zip
com.simba.spark.jdbc.Driver
JDBC URL: jdbc:spark://community.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/XX/XX;AuthMech=3
CA Error:
XQE-JDB-0012 Could not load the driver "class com.simba.spark.jdbc.Driver" because it is not certified for use with this product.
------------------------------------------------------DATABRICKS JDBC DRIVER:DatabricksJDBC42-2.6.29.1051.zip
com.databricks.client.jdbc.Driver
JDBC URL: jdbc:databricks://community.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/XX/XX;AuthMech=3
CA Error:
XQE-JDB-0012 Could not load the driver "class com.databricks.client.jdbc.Driver" because it is not certified for use with this product.
------------------------------
Paulo Klein
------------------------------
Original Message:
Sent: Wed October 26, 2022 10:48 AM
From: Mark Fry
Subject: XQE-JDB-0012 - JDBC SPARK/DATABRICKS CONNECTION FAILURE
Hi,
Just as a sanity check - you are definitely using the 2.1 version of the driver? Have you copied the driver into the Drivers folder in your CA install location, then re-started Cognos Analytics?
What's slightly puzzling here is that the error you posted refers to com.simba.spark.jdbc.Driver but the class the normal connection uses is com.simba.spark.jdbc4.Driver. Are you sure you haven't accidentally changed the class?
Cheers!
MF.
------------------------------
Mark Fry
Technical Consultant
Original Message:
Sent: Wed October 26, 2022 10:31 AM
From: Paulo Klein
Subject: XQE-JDB-0012 - JDBC SPARK/DATABRICKS CONNECTION FAILURE
Hello @Mark Fry,
Yes,
I'm triyng to create a new Data Server connection using Spark SQL connection.
I've created an cluster on https://community.cloud.databricks.com/ to test this connection.
Using DBeaver the connection works fine. Using CA shows the error message
------------------------------
Paulo Klein
Original Message:
Sent: Wed October 26, 2022 10:06 AM
From: Mark Fry
Subject: XQE-JDB-0012 - JDBC SPARK/DATABRICKS CONNECTION FAILURE
Hi,
From the Supported Environments page for your version (IBM Cognos Analytics on Premises 11.2.x: Supported Software Environments) it looks like Spark SQL Thrift Server is a supported JDBC connection type. It looks like this has been an option since the 11.0.8 release - the notes for this say:
Cognos Analytics supports the Spark SQL 2.1 Thrift server through the SIMBA (Magnitude) JDBC driver for Spark SQL
How exactly are you trying to configure the JDBC connection in CA - are you creating a Data Server connection and selecting "Spark SQL" from the list of supported connection types?
Cheers!
MF.
------------------------------
Mark Fry
Technical Consultant
Original Message:
Sent: Wed October 26, 2022 09:04 AM
From: Paulo Klein
Subject: XQE-JDB-0012 - JDBC SPARK/DATABRICKS CONNECTION FAILURE
I'm trying to create a JDBC connection to the DATABRICKS/SPARK cluster using CA11.2.1 and I'm getting this error:
Driver: DatabricksJDBC42.jar
Class: com.databricks.client.jdbc.Driver
Error: "XQE-JDB-0012 The driver "class com.databricks.client.jdbc.Driver" could not be loaded because it is not certified for use with this product."
Driver: SparkJDBC42.jar
Class: com.simba.spark.jdbc.Driver
Error: "XQE-JDB-0012 The driver "class com.simba.spark.jdbc.Driver" could not be loaded because it is not certified for use with this product."
Why is this connection not yet certified?
Any way this connection can be certified in the future?
Is there any other way to create a JDBC connection to DATABRICKS or SPARK cluster using CA?
Thanks!
------------------------------
Paulo Klein
------------------------------
#CognosAnalyticswithWatson