cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to connect Cognos 11.1.7 to Azure Databricks

Rita
New Contributor III

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

12 REPLIES 12

Kaniz_Fatma
Community Manager
Community Manager

Hi @ Rita ! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers on the community have an answer to your question first. Or else I will follow up shortly with a response.

Rita
New Contributor III

Hi Kaniz,

Thank you for you quick update.

Looking forward to get an answer to my question.

Thanks,

Rita

Kaniz_Fatma
Community Manager
Community Manager

Hi There!

We're glad to help you here.

Thankyou for being patient.

Please feel free to post your queries.

We'll revert back to you asap๐Ÿ˜Š .

Kaniz_Fatma
Community Manager
Community Manager

Hi @Semir Redzepagicโ€‹ ,

Is it possible for you to look into this?

It would be a great help.

Thanks.

Rita
New Contributor III

Hi All

Any update?

Looking forward to get an answer to my question.

Thanks,

Rita

Kaniz_Fatma
Community Manager
Community Manager

Hi @Rita Mordukhayโ€‹ ,

Sorry to keep you waiting .

Please wait while my team is looking into the issue.

They shall revert back to you soon with a response.

Thank you for your patience๐Ÿ˜Š .

Deepak_Bhutada
Contributor III

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
New Contributor III

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
New Contributor III

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
New Contributor II

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

Thanks!

Kaniz_Fatma
Community Manager
Community Manager

Hi @Rita Mordukhayโ€‹ , This article provides information to help you troubleshoot the connection between your Databricks JDBC/ODBC Server and BI tools and data sources.

Kaniz_Fatma
Community Manager
Community Manager

Hi @Rita Mordukhayโ€‹ , Just a friendly follow-up. Do you still need help? Please let us know.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group