Connection to Cognos

[mayank2588]

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?

[bibc]

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.

[dacosta]

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

[junaidrao]

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

[sdaniels]

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

[ConnorG]

Hey Mayank,

I'm currently trying to connect Cognos and Splunk.

Were you successful in doing so?

[mayank2588]

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?

[sdaniels]

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

[mayank2588]

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