This week, we are excited to announce on-premises connectivity for Microsoft Flow. This can be achieved by using the on-premises data gateway, that allows you to establish secured connections and integrate them with your flows. At launch, the gateway functionality will be supported by SQL Server. As part of our business application platform, this gateway can be used across Power BI, PowerApps, and Microsoft Flow to deliver dashboards, reports, applications and flows leveraging on-premises sources.
In this blog post, we are going to look at creating a connection to an on-premise SQL database.
To start off, you will need to install a gateway on a machine that is in the same network as the SQL server. This machine must be always on and be always connected to the internet. Download the gateway installer and follow the prompts to complete the installation process.
When prompted to register the gateway, be sure to use the same credentials, as the ones used to sign-in to Microsoft Flow.
Additonal details about gateway installation can be found here.
Whats up Friends?!In todays video I am joined by Microsoft Flow MVP - Ahmad Najjar and we are bringing you the SQL Connector! Power Query lets you reshape, transform and clean data from SQL Server or Azure SQL Databases so you can use it in your automations. You guessed it, saving time and money. Making Power Automate even more powerful.
Create a new SQL connection
Once you are Microsoft Flow, select the account menu and navigate to the “My Connections”
Click “Add a Connection” button in the top right corner and then select SQL server.
Select the “Connect via on premise data gateway” checkbox. Next, provide the server name, database name, credentials and make sure the correct gateway is selected.
After successfully, creating the connection – you should be able to access the on-premise database that you just connected to. You can use this connection, in any other flow just as you would use any other connection.
Execute A Sql Query Microsoft Flow
Here are some SQL server templates that you can use right now.
Microsoft Flow Execute Sql Query C#
Let us know how you are using Flow in the comments section below. Follow us on Twitter to keep up with our latest updates and to learn more about how you use Flow to work smarter.