Getting Data In

Connection to Cognos

mayank2588
New Member

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?

0 Karma

bibc
Explorer

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.

0 Karma

dacosta
Explorer

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

0 Karma

junaidrao
New Member

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

0 Karma

sdaniels
Splunk Employee
Splunk Employee

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

0 Karma

ConnorG
Path Finder

Hey Mayank,

I'm currently trying to connect Cognos and Splunk.

Were you successful in doing so?

0 Karma

mayank2588
New Member

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?

0 Karma

mayank2588
New Member

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

0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...