topic Re: Connection to Cognos in Getting Data In

Connection to Cognos

mayank2588 — Wed, 17 Jul 2013 18:00:36 GMT

I wanted to know if we can connect Splunk searches to Cognos. Cognos is built upon services oriented architecture and can be extended through SOAP, REST and XML.
Can we can use the Splunk searches and use them as an end point for Cognos to pick them up and create a report/dashboard?

Re: Connection to Cognos

sdaniels — Wed, 17 Jul 2013 18:19:47 GMT

Splunk provides SDKs written on top of our REST API for integration purposes so that you can take the data from Splunk do what you want with it. The dev.splunk.com page has some examples as well.

http://dev.splunk.com/view/sdks/SP-CAAADP7
http://dev.splunk.com/view/rest-api-overview/SP-CAAADP8

Re: Connection to Cognos

mayank2588 — Wed, 17 Jul 2013 18:35:49 GMT

Thanks for the answer.In which format does REST API export the data? is it XML format?

Re: Connection to Cognos

sdaniels — Wed, 17 Jul 2013 18:41:16 GMT

http://docs.splunk.com/Documentation/Splunk/5.0.3/RESTAPI/RESTatom

http://docs.splunk.com/Documentation/Splunk/5.0.3/RESTAPI/RESTatom#JSON_and_other_response_formats

Re: Connection to Cognos

mayank2588 — Thu, 18 Jul 2013 05:34:57 GMT

So, if I use curl to create endpoints of the saved search in XML format, write the generated XML to a file and then use that XML File as a source- will it work?

Re: Connection to Cognos

ConnorG — Wed, 05 Nov 2014 20:21:36 GMT

Hey Mayank,

I'm currently trying to connect Cognos and Splunk.

Were you successful in doing so?

Re: Connection to Cognos

bibc — Wed, 18 Mar 2015 07:02:27 GMT

Hi
I am using the Splunk ODBC driver on the Cognos Server to get splunk search result into Cognos.
In splunk you create a saved search and then you can import these into FrameWork Manager, where you can find the saved search like any other database view.
This Works great for me. I am creating Cognos dashboards with data from Splunk.

Re: Connection to Cognos

junaidrao — Thu, 14 May 2015 02:46:36 GMT

Hi Bibc,
I am trying to access data in Splunk 6.0 (Redhat linux server) through Cognos 10.2.2(Redhat linux server) however bit stuck with the connectivity and drivers. Is there any splunk ODBC driver for linux?
I was able to find windows drivers and connected splunk using MS Excel with a local system DSN. Appreciate if you can share some step by step guide or document to implement Cognos and Splunk connectivity. Thanks

Re: Connection to Cognos

dacosta — Wed, 26 Apr 2017 16:14:00 GMT

Bibc, question for you, as Im not familiar with Cognos, but why would you go thru all the work to export Splunk data into Cognos to create dashboards? when you can create dashboards in Splunk?
thank you,
D