question

sandeepthandra-9921 avatar image
0 Votes"
sandeepthandra-9921 asked sandeepthandra-9921 commented

ADF - SAP BW : Application connector

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

azure-data-factoryazure-sap
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sandeepthandra-9921 ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered sandeepthandra-9921 commented

Hi @sandeepthandra-9921 ,

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sandeepthandra-9921 - Just checking if you get chance to check above and share updates.

0 Votes 0 ·

@ShaikMaheer-MSFT .. Thanks for the leads. Unfortunately, MDX is used to read/write( in some cases )data from/to data base tables. I haven't tried the API call yet. In the meantime, I also saw some possibilities with Logic apps which has predefined Actions in SAP stack. May be Logic apps can be used as orchestrator for ADF and SAP function calls.. It may take some time to test this but I was post an update once I have concrete results.

Thnx for the inputs

0 Votes 0 ·