Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple gateways, multiple servers with 1 user.

Hi all!

I have 2 ERP system, both on premise each on a different server.

I am creating a workflow using Power Automate which takes data from the 2 systems, run a few tasks and then create a power BI  report.

 

How should I install the gateways?

Can I install a gateway on each server and authenticate with the same user and password?

 

Thank you, Tal

General Comment
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I think for on-premise gateway will be needed. Power Automate is loading data service or to pbix ?

     

    Either Power Automate or Power bi will require on premise gateway

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi

      the I will connect the gateway to Power Automate

      We are not sure what will be the target of the data

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Power automate will send API request to the #1 ERP system, proccess the json, modify a few fields and post it to the #2 ERP (SAP buinsess One with a Hana DB)

     

    I am sure that data gateway will be needed, my quiestion is can I install the datagate way on each of the ERP server and authenticate with the same user?