web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Integrate Microsoft Dy...
Service | Customer Service, Contact Center, Fie...
Answered

Integrate Microsoft Dynamics CRM 2013 OnPremises with Power Platform

(0) ShareShare
ReportReport
Posted on by Fabio N. Bonifacio 35

Hello, 

My client still using an old OnPremises implementation of Microsoft Dynamics CRM 2013, to support his Customer Relationship Central, and would like to build a mobile APP with Power Apps to extend the use of Dynamics to his field technicians. 

We have been working on an upgrade for Dynamics 365, but due to a budget limitation for 2020, they have postponed the decision, 

Any recommendations on how we could work that out, considering the current scenario? Power Automate? OnPremises Gateway? Data Integrator?

I have the same question (0)
  • Verified answer
    protc Profile Picture
    protc on at

    Hi Fabio,

    Thank you for your query.

    In this scenario, you can use the Power Platform On premise data Gateway and install it on the SQL server and use the SQL connector on Power apps to read the data from On prem SQL DB or You can manually create a custom connector for your required scenarios using Web API that Dynamics 365 provides.

    But still, the users should not write any data back into the SQL DB. For online Reading and Writing using connectors is possible because D365 Online uses CDS for storage.

    docs.microsoft.com/.../gateway-reference

  • Fabio N. Bonifacio Profile Picture
    Fabio N. Bonifacio 35 on at

    Protim, thank you for your answer.

  • Fabio N. Bonifacio Profile Picture
    Fabio N. Bonifacio 35 on at

    Is it possible to connect to an online Dynamics 365 Field Service instance with this same gateway?

  • Verified answer
    protc Profile Picture
    protc on at

    You're Welcome!

    This gateway is only for Power Platforms users.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 60 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 52 Super User 2025 Season 2

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 36 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans