none
Schedule Data Factory and SAP BW RRS feed

  • Question

  • HI Guys,

    I`m new in data fatory, but i could build a pipeline that read openhub information from SAP BW and save the data in azure sql db and everthing is ok in this part.

    The problem is, it need to be a process will run daily and the dependencie to start the data factory is the SAP BW, somebody know how to do it? I was looking for some solution, but I can`t find it.

    The triggers that exists in data factory, is not prepared to use external dependencie.

    Tks

    Wednesday, September 11, 2019 8:11 PM

All replies

  • Hello rsmatsumoto and thank you for your inquiry.  If I understand correctly, you want something in SAP BW to cause the Data Factory pipeline to start.

    There are ways to trigger a pipeline run from outside Data Factory.  I am not familiar with the capabilities of SAP BW.  Can SAP BW make a call to a REST API, similar to the Data Factory Web activity?

    Link to the REST API call to trigger a pipeline

    Link to 'Getting Started with REST'

    Before using this REST API call, you will need to authenticate using OAuth2.  First,  create an Azure Active Directory App.  Then go to your Data Factory in the Azure Portal and go to Access Control (IAM) and 'Add a role assignment' to the App you created.  Contributor role will have more than enough permissions.

    You will then acquire an access (bearer) token to use in subsequent calls.  Get this token by making a call to

     https://login.microsoftonline.com/common/oauth2/authorize

    or

     https://login.microsoftonline.com/common/oauth2/token

    using the ID and secret of the App you created.  Use the returned token in the call to trigger  your pipeline run.

    Thursday, September 12, 2019 8:20 PM
    Moderator