About djackson_splunk

djackson_splunk · ‎10-31-2017

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.

djackson_splunk · ‎10-31-2017

SAP provides the JDBC client, ngdbc.jar, which is found in the HANA HDB Client package. Put that driver in: $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers You will need to manually create a db_connection_types.conf in: $SPLUNK_HOME/etc/apps/splunk_app_db_connect/local In this conf file, you need the following. [hana] displayName = HANA jdbcUrlFormat = jdbc:sap://:/ jdbcDriverClass = com.sap.db.jdbc.Driver supportedVersions = 2.0 Also be aware when setting up the connection, that the port is 3xx15 where xx is the HANA instance number. For example if instance 90, then port is 39015. Database is the HANA SID. Here is an example of a connection for HANA... I've tested this with HANA Express Edition 2.0 and Splunk 7.0.0 and Splunk DB Connect 3.1.1 Here is a successful connection...

Posts	2
Solutions	1
Karma Given	0
Karma Received	3
Member Since	‎10-31-2017

Online Status	Offline
Date Last Visited	‎03-01-2022 07:04 PM

Re: How to integrate Splunk with SAP HANA?

Re: Splunk DB Connect connection to Hana