topic Re: How to integrate Splunk with SAP HANA? in All Apps and Add-ons

How to integrate Splunk with SAP HANA?

shivam007 — Mon, 27 Apr 2015 15:22:39 GMT

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

Re: How to integrate Splunk with SAP HANA?

cladd_splunk — Fri, 11 Sep 2015 16:22:54 GMT

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?

Re: How to integrate Splunk with SAP HANA?

jcoates — Mon, 23 Oct 2017 02:12:05 GMT

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.

Re: How to integrate Splunk with SAP HANA?

djackson_splunk — Wed, 01 Nov 2017 02:21:16 GMT

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.

Re: How to integrate Splunk with SAP HANA?

cquinney — Wed, 14 Aug 2019 17:34:51 GMT

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.