Forum Discussion

kaintxu2's avatar
kaintxu2
Regular Visitor
2 years ago

Oracle DB conection Gateway

Hi Everyone,

 

we need to connect to an Oracle DB. There will be multiple users who will be accessing it to create reports.

 

Can the gateway be installed on the server so that everyone uses the same gateway, or is it necessary to install it on each workstation that is going to access the Oracle DB?

 

Sorry for such an obvious question, but It is the first time I need to deal with gateways and I am still totally lost here on how to deal with them.

 

Kind regards,

Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You install gateways on dedicated VMs  (they should ideally be running 24/7).  Then you install the same Oracle drivers and TNSNAMES.ORA entries on the gateway - make the setup identical to the workstation.

     

    Then go to the Power BI Service and create a connection based on the TNS entry.

    • kaintxu2's avatar
      kaintxu2
      Regular Visitor
      2 years ago

      Thanks for the reply.

       

      Quick follow up. Do you only need to install it in 1 VM and then all users can access the DB, or are there more instalations needed? 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Technically one VM is enough but for business continuity you will want to have at least two gateway cluster members.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi kaintxu2 

     

    For more detailed guidance about gateway, you may read the following blog: 

    The Power BI Gateway; All You Need to Know - RADACAD

     

    There are multiple levels of controls on user access when it comes to gateway setup in Power BI. Each gateway can have three types of user access at the gateway level and another three types of user access at the data source level. You may make some users have gateway-level permissions to manage data sources and users of the gateway, and have the other users have data-source-level permissions to only the specific data sources they need to use. Above blog has a detailed introduction about user management in Users and Access Controls for Gateway section. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!