- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to connect NiFi with Hana
- Labels:
-
Apache NiFi
Created 07-19-2016 06:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a processor to put files to HANA from Apache NiFi?
Thanks.
Created 07-19-2016 07:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Created 07-19-2016 06:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 07-19-2016 07:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Created 05-11-2017 02:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content