BT

Microsoft Invests in Hybrid Connectivity, Releases On-Premises Data Gateway

| by Kent Weare Follow 10 Followers on May 14, 2017. Estimated reading time: 2 minutes |

In a recent blog post, Microsoft announced the On-premises data gateway has reached General Availability (GA). This gateway allows for remote connectivity from many Microsoft PaaS and SaaS services to data sources residing behind a corporate firewall.

Within the Microsoft documentation, the service is referred to as

a bridge that provides quick data transfer and encryption between on-premises systems and Microsoft Cloud services. The gateway relays data from on-premises sources on encrypted channels through the Azure Service Bus. All traffic originates as secure outbound traffic from the gateway agent.

The Microsoft Cloud services that are currently supported, by the On-Premises data gateway, include:

  • Power BI – for self-service data exploration and visualization
  • Microsoft Flow – for IFTTT-like personal workflow and connectivity
  • PowerApps – a cross platform citizen developer mobile development platform
  • Logic Apps – an Integration Platform as a Service (iPaaS)

Microsoft is also planning on including support for Azure Analysis Services within the next few months.

With a gateway provisioned, some of the data sources that can be exposed include:

  • BizTalk Server
  • DB2
  • File System
  • Informix
  • MQ
  • MySQL
  • Oracle Database
  • PostgreSQL
  • SAP Application Server
  • SAP Message Server
  • SharePoint for HTTP only, not HTTPS
  • SQL Server
  • Teradata

The On-premises data gateway is a software agent that needs to be installed in your corporate network. It can be installed on the same server as the underlying data source that you would like to expose, or on its own server. In order to complete the gateway configuration, you need to provide an account, that has a work or school email address, which is managed by Azure Active Directory. This same account must have access within the Azure subscription to register the gateway in the Azure Portal.

The Azure Service Bus Relay provides the On-premises data gateway with connectivity between the corporate environment and the cloud. To facilitate this connectivity, the Service Bus Relay will create an outbound connection to the Azure where it will create a rendezvous endpoint. Requests are then tunneled through this connection to your on-premises network. For many customers, this connectivity can occur without any changes to your firewall.

Image Source: https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-install#gateway-cloud-service

During the preview of the On-premise data gateway service, there was a default that placed the gateway in your Azure Active Directory tenant’s location. This has changed, as of the GA announcement, customers

can now select the region for the gateway cloud service and Azure Service Bus communication channel that you want to use with your gateway installation.

Also included in the GA release, is the ability to delete a gateway connection resource and associate your gateway to a different Azure resource. 

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT