COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: danii64 on 12 Nov 2018 10:47:10 AM

Title: CloudantDB data source connection with CA 11 error
Post by: danii64 on 12 Nov 2018 10:47:10 AM
Hi All,


I'm trying to connect to CloudantDB data source for Cognos Analytics but i am unable to connect to it. im getting the error below.

Has anyone been able to successfully connect to CloudantDB or CouchDB from Cognos Analytics? Any documentation or helpful hints would be greatly appreciated


ERROR:
SQL30081N  A communication error has been detected. Communication protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location
where the error was detected: "169.45.6.71".  Communication function detecting
the error: "recv".  Protocol specific error code(s): "*", "*", "0".
SQLSTATE=08001

Thanks in advance!
Title: Re: CloudantDB data source connection with CA 11 error
Post by: MFGF on 13 Nov 2018 01:47:46 AM
Quote from: danii64 on 12 Nov 2018 10:47:10 AM
Hi All,


I'm trying to connect to CloudantDB data source for Cognos Analytics but i am unable to connect to it. im getting the error below.

Has anyone been able to successfully connect to CloudantDB or CouchDB from Cognos Analytics? Any documentation or helpful hints would be greatly appreciated


ERROR:
SQL30081N  A communication error has been detected. Communication protocol
being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location
where the error was detected: "169.45.6.71".  Communication function detecting
the error: "recv".  Protocol specific error code(s): "*", "*", "0".
SQLSTATE=08001

Thanks in advance!

Hi,

I'm looking at the list of data sources you can connect to from Cognos Analytics, and I don't see Cloudant. Can you provide details on how you are trying to connect? I suspect you might need to deliver the data into a database CA can connect to - such as Db2 Warehouse on Cloud...

The supported environments page is here:

https://www-01.ibm.com/support/docview.wss?uid=swg27047186

Cheers!

MF.
Title: Re: CloudantDB data source connection with CA 11 error
Post by: the6campbells on 04 Dec 2018 12:40:01 AM
Cloundant is not supported by Dynamic Query