question Re: Can NiFi connect to SAP BW? in Archives of Support Questions (Read Only)

Can NiFi connect to SAP BW?

sunile_manjee — Thu, 14 Jul 2016 22:51:34 GMT

Can NiFi connect to SAP BW? I want to move data from SAP BW/Hana to HDP. Can NiFi do this? which processor would I use?

Re: Can NiFi connect to SAP BW?

slachterman — Thu, 14 Jul 2016 23:07:55 GMT

@Sunile Manjee can you use the SAP HANA JDBC connector with the ExecuteSql processor?

Re: Can NiFi connect to SAP BW?

rgelhausen — Fri, 15 Jul 2016 00:12:41 GMT

SAP has a large set of REST APIs. That's a good starting point.

Re: Can NiFi connect to SAP BW?

sunile_manjee — Sat, 16 Jul 2016 00:36:17 GMT

@slachterman and @Randy Gelhausen thanks for the answers. helpful

Re: Can NiFi connect to SAP BW?

rgelhausen — Sat, 16 Jul 2016 00:46:02 GMT

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.

Re: Can NiFi connect to SAP BW?

sunile_manjee — Sat, 16 Jul 2016 04:04:55 GMT

@Randy Gelhausen that is is awesome feedback. thanks for the insights. I more then likely would use the api for most use cases. for this specific use case a jdbc connector is required.