Forum Discussion

fabiocoelho's avatar
fabiocoelho
New Member
8 years ago

Gateway em mais de uma base

Olá.
Veja se alguem pode me ajudar.
Eu tenho um servidor sql que possui dois bancos de dados CLIENTE_A e CLIENTE_B.


Agora os dois clientes estão querendo alguns relatorios no powerbi, minha pergunta é:

Eu consigo no mesmo servidor eu ter um Gateway para dois clientes ?

O mesmo Gateway atualizar informações do CLIENTE_A e do CLIENTE_B


Mas cada cliente só ira conseguir ver os dados dele, exemplo o CLIENTE_A só ve os dados do CLIENTE_A e o CLIENTE_B só ve os dados do CLIENTE_B


Obrigado a todos


General Comment

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi fabiocoelho,

     

    See if anyone can help me.
I have a sql server that has two databases CLIENT_A and CLIENT_B.

Now the two clients are wanting some reports on powerbi, my question is:

Can I get on the same server I have a Gateway for two clients?

The same Gateway update information from CLIENT_A and CLIENT_B

But each client will only be able to see the data of him, for example the CLIENT_A only sees the data of the CLIENT_A and the CLIENT_B only sees the data of the CLIENT_B

     

     Can I get on the same server I have a Gateway for two clients?

     

    You have installed a Gateway on a server, and want to use this single Gateway to update data for two clients' reports, right? Yes, it is possible.

     

    But each client will only be able to see the data of him, for example the CLIENT_A only sees the data of the CLIENT_A and the CLIENT_B only sees the data of the CLIENT_B

     

    If you create two separate reports for ClientA and ClientB, you just need to load data from each corresponding database, instead of loading all data. If you combined data from two databases, and two clients would see the same report, then, you should apply RLS to restrict data access for them.

     

    Best regards,

    Yuliana Gu

    • fabiocoelho's avatar
      fabiocoelho
      New Member
      8 years ago

      Can I get on the same server I have a Gateway for two clients?

      You have installed a Gateway on a server, and want to use this single Gateway to update data for two clients' reports, right? Yes, it is possible.


      Exactly what I need to do, but how can I do this?