How to connect Cognos 11.1.7 to Azure Databricks

[Rita]

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

[Rita]

Hi Kaniz,

Thank you for you quick update.

Looking forward to get an answer to my question.

Thanks,

Rita

[Rita]

Hi All

Any update?

Looking forward to get an answer to my question.

Thanks,

Rita

[Deepak_Bhutada]

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

[Rita]

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

[Rita]

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

[abc_260447]

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

Thanks!