Oracle DB conection Gateway

[kaintxu2]

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,

[Anonymous]

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!

[lbendlin]

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]

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]

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

[kaintxu2]

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

[lbendlin]

Deinstall IE from that image, it is long obsolete.  Install the Edge browser for WS instead.

[kaintxu2]

For WS?

Whilel I know IE is long obsolete, I guess they just have it there. Could just having IE install really be a problem?

BTW it is being installed in a Windows 2019 Server, not WorkStation if (WS means Workstation in this case)

[lbendlin]

Sorry, I assumed that WS is clear. I meant Windows Server.  2019 or 2022.

Yes, just having IE installed is really a problem. Unless you want to endlessly fight with Trusted Sites and TLS and stuff you are better off deinstalling IE.