Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

How to connect NiFi with Hana

Contributor

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

Thanks.

1 ACCEPTED SOLUTION

Super Guru

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

View solution in original post

3 REPLIES 3

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

Super Guru

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

New Contributor