Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to connect NiFi with Hana

Solved Go to solution
Highlighted

How to connect NiFi with Hana

Contributor

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

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to connect NiFi with Hana

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.

3 REPLIES 3

Re: How to connect NiFi with Hana

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

Re: How to connect NiFi with Hana

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.

Re: How to connect NiFi with Hana

New Contributor