09-14-2021 12:38 PM
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
09-14-2021 12:40 PM
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.
09-14-2021 12:42 PM
Hi Kaniz,
Thank you for you quick update.
Looking forward to get an answer to my question.
Thanks,
Rita
09-14-2021 12:48 PM
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😊 .
09-15-2021 09:46 AM
Hi @Semir Redzepagic ,
Is it possible for you to look into this?
It would be a great help.
Thanks.
09-20-2021 08:19 AM
Hi All
Any update?
Looking forward to get an answer to my question.
Thanks,
Rita
09-20-2021 08:29 AM
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😊 .
09-24-2021 12:27 PM
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
10-04-2021 06:52 AM
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
10-08-2021 10:18 AM
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
08-25-2022 10:17 PM
Hey! Did you get any solution to this? I am also facing the same error.
Thanks!
04-13-2022 01:08 PM
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.
04-26-2022 08:24 AM
Hi @Rita Mordukhay , Just a friendly follow-up. Do you still need help? Please let us know.