Hi Nigel, thank you for your detailed reply. I was able to make the connection earlier and it was due to missing jar driver file in our driver's folder. I was thinking that Cognos already have all needed driver files uploaded, looks like we ourselves need to upload it too and I could not find that part in the documentations, another support guy emailed me the pdf with instructions. I think it will be great if Cognos put that instructions in their Databricks jdbc related documentation too.
I have another question. Now I can connect to the databricks databases but I have to specfify 3 level name path databsename.schemaname.tablename, is there a way to include database and schema names in data source itself and to just put table name in the sql query? Like instead of select * from databsename.schemaname.tablename, can we use somehow use select * from tablename.
Thanks!
------------------------------
Bek Ibragimov
------------------------------
Original Message:
Sent: Wed January 18, 2023 07:01 AM
From: NIGEL CAMPBELL
Subject: Cognos 11.2.4 Databricks connection error
Either you have not placed any copy of the Databricks JDBC driver in the <cognos>\drivers folder.
https://www.databricks.com/spark/jdbc-drivers-archive
Or you have have not put the minimum version of their driver into that folder.
https://www.databricks.com/spark/jdbc-drivers-archive
Databricks made changes to their driver, including class names and protocol name the driver exposes.
Which in part is why there is a minimum version version required, per our documentation.
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=administration-databricks-support
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Tue January 17, 2023 08:25 AM
From: Bek Ibragimov
Subject: Cognos 11.2.4 Databricks connection error
I am trying to set up a connection in Cognos Analytics 11.2.4 version to Databricks but it is showing following error any hint\help will be appreciated:
------------------------------
Bek Ibragimov
------------------------------