Skip to main content

Notifications

Customer Service forum
Suggested answer

Integration between D365 OnPremise and Dynamics CRM Cloud

Posted on by 15

hi, I am looking for a solution for integration of On Premise D365 with Cloud CRM. How integration works and what are the pre-requisites are required. Please shed more light on this integration process. It will really helps a lot. Any thread that is already there OR any documentation will be a great help. Thanks in advance.

SVRR

  • Suggested answer
    Yogesh Mulay Profile Picture
    Yogesh Mulay 47 on at
    Integration between D365 OnPremise and Dynamics CRM Cloud

    1. Data Integration using Microsoft's Integration Tools

    • Azure Data Factory:

      • Use the "Self-hosted Integration Runtime" to securely connect to your on-premise D365 data sources.
      • Build data pipelines to extract, transform, and load (ETL) data between on-premise and cloud environments.
      • Utilize connectors for Dynamics 365 and other data sources (e.g., SQL Server, file systems).
      • Schedule and monitor data flows using Azure Data Factory's orchestration capabilities.
    • Logic Apps:

      • Create workflows to trigger actions and data exchanges based on specific events or conditions.
      • Use connectors for Dynamics 365, on-premise data gateways, and other cloud services.
      • Build complex integration scenarios with branching, looping, and error handling.
    • Power Automate:

      • Design simpler automation flows to streamline routine tasks and data transfers.
      • Use pre-built connectors or create custom connectors for specific needs.
      • Trigger flows based on events in Dynamics 365 or other systems.

    2. Custom Integration using APIs and Web Services

    • Dynamics 365 Web API:

      • Use the Web API to interact with both on-premise and cloud Dynamics 365 environments.
      • Leverage OData (Open Data Protocol) for querying and manipulating data.
      • Implement authentication and authorization mechanisms for secure access.
    • Azure Functions:

      • Build serverless functions to handle integration logic, data transformations, and API calls.
      • Trigger functions based on events from Dynamics 365, Service Bus, or other sources.
      • Scale automatically to handle varying loads.
    • Azure Service Bus:

      • Use queues or topics to enable reliable messaging between on-premise and cloud systems.
      • Ensure message delivery even in the event of temporary outages or network issues.

    3. Hybrid Integration Platforms (HIP)

    • Azure Integration Services:

      • Explore connectors for Dynamics 365 and other systems within your landscape.
      • Design and manage integration flows using a visual interface.
      • Monitor integration health and performance through dashboards.
    • Third-party HIPs:

      • Evaluate different vendors based on features, pricing, and compatibility with your systems.
      • Consider factors like ease of use, scalability, and support.

    Reference Materials:

     Please mark my answer verified if this is helpful!
  • ananeto Profile Picture
    ananeto 144 on at
    Integration between D365 OnPremise and Dynamics CRM Cloud
    I guess that you probably solved this long ago SVRR, but coming across your post, I just wanted to leave a note for future readers that one thing you have to be careful with are the existing integrations with your On Premise D365.
     
     
    Thank you,
     
    Ana
  • Cariblayor Profile Picture
    Cariblayor 35 on at
    RE: Integration between D365 OnPremise and Dynamics CRM Cloud

    In a perfect world, the migration from Microsoft Dynamics CRM on-premises to Dynamics 365 online would easily include the existing integrations to Microsoft Dynamics CRM on-premises. This should be even simpler in case you already had D365 and wanted to go fort a Dynamics 365 on premise to cloud migration. Read More here. Microsoft Dynamics 365 Cloud Vs On-Premise Comparison.

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,508 on at
    RE: Integration between D365 OnPremise and Dynamics CRM Cloud

    Hello,

    you can refer this article for Microsoft Dynamics 365 Cloud vs On-premise Comparison,

    https://www.dynamicssquare.com/microsoft-dynamics-365-cloud-vs-on-premise/


    I hope it helps,

    Thanks.

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Integration between D365 OnPremise and Dynamics CRM Cloud

    Hello,

    You could use one of the third party tool for your integration -

    www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-365

    From On-premise to cloud integration you can create app in azure app registration and create application user in crm then assign role. Now use this user to connect to cloud from your integration project c#.

    docs.microsoft.com/.../walkthrough-register-app-azure-active-directory

    You can use Web API OR Organization service to interact with CRM -

    docs.microsoft.com/.../overview

    docs.microsoft.com/.../overview

    From Cloud to On-premise CRM instegration you will have to enable IFD on your crm instance so that it can reached from internet.

    docs.microsoft.com/.../configure-the-dynamics-365-server-for-ifd

    You could also use power automate to connect to your on-premise sql using Onpremise Data gateway

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

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: xrmdynamicscrm.wordpress.com/

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans