On-premises Data Gateway connection (servicebus access through a VIP)

[fabson69]

Hi,

Our company prevent the Microsoft on-premises data gateway from connecting to the servicebus in Azure.

The only way to communication with the Azure Service Bus on ports 443 is through a F5 VIP that will simply forward the packets received from the gateway to the servicebus address. Since the VIP has a different address than the orignial one (urlinthegatewaydiagnostictest.servicebus.windows.net), is it possible to change that url in the gateway configuration ? Has someone experienced this before ?

Many thanks

[v-xicai]

Hi @fabson69 ,

You may open the config file located at this link 

C:\Program Files\On-premises data gateway/EnterpriseGatewayConfigurator.exe.config .

Append the xml configuration carefully. Please replace the IP Address and Port provided by your Network Administrator.

For references:

How to configure Power BI Enterprise Gateway Proxy configuration?

Connecting to on-premises data sources with On-premises data gateway

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fabson69]

Hi Amy,

Thank you for your proposal, but we are not allowed to use proxies :(. 

kind regards,

Fabrice

[GilbertQ]

Hi there

THis is not something that I have seen or experienced before.

I would suggest logging a support ticket to see if they can assist you with these technical details

[lbendlin]

I guess this is possible somewhere in the GatewayCore DLL config settings, somewhere around here

    <bindings>
      <!-- The packet size is 8 MB and in the worst case, the compressed packet can be slightly larger than that; so using 8.5 MB -->
      <GatewayNetTcpRelayBinding>
        <binding name="GatewayServiceBusTransferBinding" connectionMode="Relayed" transferMode="Buffered" receiveTimeout="06:00:00" maxReceivedMessageSize="8500000" maxBufferSize="8500000" maxBufferPoolSize="8500000" maxConnections="1500" isDynamic="false">
          <reliableSession ordered="true" inactivityTimeout="00:10:00" enabled="false" />
        </binding>
      </GatewayNetTcpRelayBinding>
    </bindings>

. Probably worth raising a ticket with Microsoft for some real time tests. 

[fabson69]

Hello Ibendlin,

Thank you for your suggestion. I can see the bindings indeed but not the service endpoints declaration. 

There is also the solution of using the local hosts file, with the VIP IP next to the service bus namespace.

I will raise a ticket now at Microsoft to see what is possible and supported.

Best regards