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 ...
Need Help
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.

      • kaintxu2's avatar
        kaintxu2
        Regular Visitor
        2 years ago

        The person dealing with the gateway instalation is trying to install it in a Windows Server 2019.

         

        One athey get to the "the instalation is completed correctly" and asked for an email to be used with the gateway, they enter it but then get an error that the security configuration of Internet Explorer is blocking the content of the aplicaciones comming from the web site shown below.

         

        And they also get an error saying to start session you need JavaScript, and that JavaScript is blocked or the browser does not admit it.

         

        Has anyone come across theses issues?

         

        I know they seem as easy as changing the IE security and installing JS, but its on someone elses server and not sure if they just don´t want to do it.

         

        Kind regards