All Apps and Add-ons

How to integrate Splunk with SAP HANA?

shivam007
Engager

HI Team,

I would like to integrate Splunk and SAP HANA (1.0 Sp09).

Could you please provide me some useful information for integration. I have already checked latest posts, but was not able to find any related info on it.

Mail id : gshivam.saurabh007@gmail.com

Regards,
Saurabh

Tags (2)

djackson_splunk
Splunk Employee
Splunk Employee

As described above, Splunk DBconnect can provide a JDBC connection to SAP HANA for data extraction, etc. I posted a separate answer explaining the setup as it is a non standard connection.

As well, if this is a SAP ERP environment, there is an app called PowerConnect for SAP.
https://splunkbase.splunk.com/app/3153/

PowerConnect is a SAP certified app that sits in the SAP ABAP layer and pushes data out to Splunk. This includes the SAP HANA instance if being used.

0 Karma

cquinney
Communicator

If you choose to download the PowerConnect app from SplunkBase you'll have to purchase a license for the add-on that sits on the SAP server. Depending on where you're located you can either purchase a license and support through RHONDOS or BNW directly.
RHONDOS - Rhondos.com
BNW - http://www.powerconnect.io/contact-us/
YouTube video on how PowerConnect works: https://youtu.be/s-76bGvRMPE
Again, PowerConnect is an SAP-certified app that sits in the SAP ABAP layer and pushes data into Splunk.

0 Karma

cladd_splunk
Splunk Employee
Splunk Employee

SAP's HANA is an in-memory data platform, making it possible to run very fast searches against data in SAP. HANA will accept queries structured to work with SQL and convert them, surfacing data results that can be accessed via ODBC.

You should be able to use Splunk's ODBC driver (http://docs.splunk.com/Documentation/ODBC) to run SQL queries that will extract results from HANA and either index them in Splunk or make them available as a lookup. Is that the type of integration you had in mind?

0 Karma

jcoates
Communicator

ODBC driver is for extracting data from Splunk, not putting data into it. DB Connect is the tool for getting data from something like Hana into Splunk.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...