Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.
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.
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.
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!
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.
The post How to install the Data Gateway appeared first on Joe Gill.
Business Applications communities