How to connect NiFi with Hana

[#1]

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

Thanks.

[#2]

@Alvin Jin

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.

[#3 · Accepted solution]

@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.

[#4]

Here you go.

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