Dynamics Community Forum Thread Details

Dynamics Flow for On-premise

Hi everyone,

Anyone has implement Dynamics Flow with On-premise 2013 or later version. If yes than i can i do that?

I went through some articles where they mention about the "Gateway" but i don't have any idea of On-premise. I went through below link,

Best Regards,

Shahbaaz

Hi Shabaaz,

for Microsoft Flow, you can use Onpremise Data Gateway. You will install it on your SQL server and then setup an SQL Connector.

[View:https://flow.microsoft.com/en-us/blog/on-premises-data-gateway/]

But this is only good for reading the data. You should not write directly into the database!

CRM often triggers events when you update fields or create records. This won't happen if you make the changes to the DB directly.

You can manually create a custom connector for your required scenarios using Web API that Dynamics 365 provides.

[View:https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank]

[View:https://msdn.microsoft.com/en-us/library/gg334767.aspx#bkmk_basicQuery]

I have also tried to generate Open API definition from OData Metadata to make the custom connector but it is too large to be processed.

Quick Links

Leaderboard

André Arnaud de Cal... 291,280 Super User 2024 Season 2

Martin Dráb 230,214 Most Valuable Professional

nmaenpaa 101,156

Leaderboard

Dynamics Flow for On-premise