• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Azure » How to install the Data Gateway

How to install the Data Gateway

25th January 2019 by Joe Gill

PowerPlatform DataGateway - Joe Gill MVP

I wrote a post a little while ago about how to use Flow to synch Dynamics 365 record changes to an on prem database using the Data Gateway. In this post I wanted to show how easy it is to install the Data Gateway.  The data gateway acts a bridge between your on-premise data sources and your cloud services such as PowerBI, PowerApps, Flow and Logic Apps. You install the Data Gateway on an on-premise (non domain controller) computer and under the hood it uses the Azure Relay Service for connectivity. The Relay Service use outbound calls over standard TCP ports and should work out of the box unless you have security/proxy restrictions on your network.

If you are using the PowerPlatform you can install it from the PowerApps portal. Alternatively the Data Gateway can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=53127 if you are using it with Logic Apps.How to install the Data Gateway Joe Gill Dynamics 365 Consultant

The install wizard is straight forward and you need to login with the account that will be used to link the GateWay to your subscription.How to install the Data Gateway Joe Gill Dynamics 365 Consultant

You then select a name for your gateway and enter your recovery key. Once you select configure and refresh your PowerPlatform form you will see the gateway is available for use.How to install the Data Gateway Joe Gill Dynamics 365 Consultant

As I mentioned the Data Gateway acts a bridge between your cloud and on-premise enviroments and to use it you create a connection. On the connection screen click the Gateway check box and select the gateway you want to use and enter the connection details and credentials.  You can now use this connection access your on-premise data source and in my case this is a SQL Server instance. What could be easier!How to install the Data Gateway Joe Gill Dynamics 365 Consultant

If you having any problems connecting to your Data Gateway then go to the computer where it is installed and run the Data Gateway desktop application to restart, reconfigure or run diagnostics.How to install the Data Gateway Joe Gill Dynamics 365 Consultant

Share This On Social:
  • Tweet
  • How to install the Data Gateway Joe Gill Dynamics 365 Consultant

Filed Under: Azure, Power Platform

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Dataverse Anonymization

25th April 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill