How to integrate Splunk with SAP HANA?

[shivam007]

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

[djackson_splunk]

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.

[cquinney]

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.

[cladd_splunk]

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?

[jcoates]

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.