Support Questions

Find answers, ask questions, and share your expertise

Can NiFi connect to SAP BW?

avatar
Master Guru

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?

1 ACCEPTED SOLUTION

avatar

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

View solution in original post

5 REPLIES 5

avatar

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

avatar

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.

avatar
Master Guru

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

avatar

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

avatar
Master Guru

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