ADF - SAP BW : Application connector

Question

Hi,

We are doing a data copy from Azure managed instance to HANA table(BW application) via ADF and we would like to communicate to SAP BW via ADF.

Communication is needed to trigger a BW process once data load is finished from Source to HANA/BW via ADF. This can be worked out if I can call a BAPI ( BW application )- This needs a BW connector or at least to execute an unix command in SAP BW via ADF.

Is this feature possible? Appreciate if you have any leads..

Thanks,
Sandeep

Answer 1

Hi @sandeep thandra ,

Thank you for posting query in Microsoft Q&A Platform.

Are you looking for SAP BW MDX connector? If yes its available in Azure data factory. Click here to know more about this. This connector supports Copy activity and Lookup activity.

Usually if we don't have connector for our resource type, then best way to communicate with our resource is making API call. Web activity in Azure data factory will help to do the same. So in your case if you would like to do same then at the end of your pipeline after copy success make API call to your resource using Web activity.

Hope this helps. Please let us know how it goes and if any further queries. Thank you.