Can NiFi connect to SAP BW?

[#1]

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?

[#2 · Accepted solution]

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

[#3]

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.

[#4]

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

[#5]

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

[#6]

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