question Re: How to connect NiFi with Hana in Archives of Support Questions (Read Only)

How to connect NiFi with Hana

alvinuw — Wed, 20 Jul 2016 01:20:53 GMT

Is there a processor to put files to HANA from Apache NiFi?

Thanks.

Re: How to connect NiFi with Hana

emaxwell — Wed, 20 Jul 2016 01:28:29 GMT

You should be able to connect to HANA via a JDBC connection using the DBCPConnectionPool Controller object, then use the ExecuteSQL processor to submit queries.

Re: How to connect NiFi with Hana

sunile_manjee — Wed, 20 Jul 2016 02:14:13 GMT

@Alvin Jin I recently found out through this post the options:

Restful API (preferred method) more on api here.
SAP hann jdbc connect. more here.

@Randy Gelhausen pointed out a very important issue connecting via jdbc.

"one thing to understand here is that traditionally going direct to SAP tables is a no-no. There's a lot of relational modeling that using the SAP APIs does for you behind the scenes. Just depends on what you need."

That being said I would recommend Restful api if possible.

Re: How to connect NiFi with Hana

lezana — Thu, 11 May 2017 21:58:23 GMT

Here you go.

https://blogs.sap.com/2017/04/20/how-to-send-data-from-apache-nifi-to-hana/