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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...

SplunkTrust Application Period is Officially OPEN!

It's that time, folks! The application/nomination period for the 2026-2027 SplunkTrust is officially open. If ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...