topic Re: How to connect Cognos 11.1.7 to Azure Databricks in Data Engineering

How to connect Cognos 11.1.7 to Azure Databricks

Rita — Tue, 14 Sep 2021 19:38:18 GMT

We are trying to connect Cognos 11.1.7 to Azure Databricks, but no success.

Can you please help or guide us how to connect Cognos 11.1.7 to Azure Databricks.

This is very critical to our user community.

Can you please help or guide us how to connect Cognos 11.1.7 to Azure.

Thanks,

Rita

Re: How to connect Cognos 11.1.7 to Azure Databricks

Rita — Tue, 14 Sep 2021 19:42:33 GMT

Hi Kaniz,

Thank you for you quick update.

Looking forward to get an answer to my question.

Thanks,

Rita

Re: How to connect Cognos 11.1.7 to Azure Databricks

Rita — Mon, 20 Sep 2021 15:19:58 GMT

Hi All

Any update?

Looking forward to get an answer to my question.

Thanks,

Rita

Re: How to connect Cognos 11.1.7 to Azure Databricks

Deepak_Bhutada — Fri, 24 Sep 2021 19:27:35 GMT

As of now, there is no partner relationship with Cognos. IBM indicated that they do support the Simba Spark JDBC Driver, which could work with Databricks.

You can also use JDBC/ODBC drivers and configuration parameters to connect databricks clusters and SQL Endpoints.

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html

Re: How to connect Cognos 11.1.7 to Azure Databricks

Rita — Mon, 04 Oct 2021 13:52:09 GMT

Thanks you for he answer @Deepak Bhutada ,

Did anybody try to perform steps in link

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html

to connect Databricks to IBM Cognos application?

Please share your expirience or issues you have when you Databricks to IBM Cognos application

Thanks,

Rita

Re: How to connect Cognos 11.1.7 to Azure Databricks

Rita — Fri, 08 Oct 2021 17:18:26 GMT

Hi All,

After istalled ODBC drivers (unixODBC) getting error when try to connect Cognos app to Databriks:

[S1000][unixODBC][Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: authorize: cannot authorize peer.

[ISQL]ERROR: Could not SQLConnect

[S1000][unixODBC][Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: authorize: cannot authorize peer.

[ISQL]ERROR: Could not SQLConnect

[S1000][unixODBC][Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: authorize: cannot authorize peer.

Any help appriciated.

Thankyou,

Rita

Re: How to connect Cognos 11.1.7 to Azure Databricks

abc_260447 — Fri, 26 Aug 2022 05:17:57 GMT

Hey! Did you get any solution to this? I am also facing the same error.

Thanks!

Re: How to connect Cognos 11.1.7 to Azure Databricks

Hans2 — Sat, 08 Feb 2025 19:36:43 GMT

Have anyone got the Simba JDBC driver going with CA 11.1.7?

The ODBC driver works fine but i can't get the JDBC running.

Regd's