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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Synchronization betwee...
Microsoft Dynamics CRM (Archived)

Synchronization between Dynamics CRM and Azure Cloud Service

(0) ShareShare
ReportReport
Posted on by Emerson Brito 180

I have an custom application deployed to Windows Azure (cloud service) and a CRM 2013 instance running on premise. The idea is to sync data between the two applications.

A) When data is created/updated on CRM it should sync with the cloud application
B) When data is created on the cloud application it should be pushed to CRM (no updates done through the cloud app, only create)

Both sync operations should occur as close as possible to real time.

I appreciate any comments/suggestions

Thanks in advance,

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    @Emerson, Are you able to find any solution for sending data from Azure to CRM?

  • Vassil Profile Picture
    Vassil on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    Well, if you DB is somehow REST-enabled probably you can write directly somehow but the only way to CRM is via Web Services.

    Summary:

    CRM to Azure: OOTB functionality of CRM, Azure Service Bus (storage), lightweight service to write in your DB

    Azure to CRM: what you described.

    I know that you can set different types of Service bus connections via the Plug-in registration tool but I dont know there's something to make it simpler. For extra info you can check here: msdn.microsoft.com/.../gg309615.aspx

    Having in mind that you have a custom app, some custom code is needed. Even SP works pretty hard with CRM and it is "fully integrated" according to the Sales department of Microsoft.

  • Emerson Brito Profile Picture
    Emerson Brito 180 on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    I see;

    I'm familiar with the SDK and I was trying to avoid the "portal concept"  where I would be creating a client, storing some credentials with this client and using it to access CRM web services but I believe this is what you are suggesting right?

    CRM To Azure:

    Combination of azure aware plugin + service, pushes data from CRM to cloud db

    Azure to CRM:

    A worker role listens to a message queue, connects straight to a CRM end point (using CRM SDK) and perform the updates.

    That works but doesn't it sounds more complicated than it should be? The logical thinking is the same path/connection should allows messages to flow both ways or, listen to events on both sides but; looks like it can't be done.

  • Suggested answer
    Vassil Profile Picture
    Vassil on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    Hi Emerson,

    Here comes the extra coding that I mentioned. Basically the idea is to keep 2 databases in sync, so when you push from CRM to the bus, then you need a service to listen to the bus and perform a CRUD operation in the DB of your Cloud app.

    In the scenario that you're interested into you can add some extra code in your cloud app to push the changes not only to the DB of the Cloud app but also to the service bus. Then the "integration service" that you need will pick up the data and send it to CRM (you can access CRM programmatically via de CRM SDK (Microsoft.Xrm.Sdk.dll).

    Cheers,

    Vassil

  • Emerson Brito Profile Picture
    Emerson Brito 180 on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    Hi Vassil,

    Thanks for the quick reply.

    I looked into that thread and the related MSDN documents and I'm still stuck with one thing:

    The plugin will post messages to the service bus based on a CRM events, lets say: account create.

    That works fine for passing data from CRM to the cloud app.

    What I can't figure out is how to do the opposite:

    - Record is created on cloud app.

    - A message is posted to the service bus.

    - CRM intercept that message and create corresponding record in its database.

    What appear to me is it is not possible.

    Looks like the Azure aware plugin is intended to push data from CRM to Azure and not the other way around. I'm hopping I got it wrong though. There must be an elegant and resilient way to push data from Azure to CRM independent of CRM events.

    It will be a very low traffic, lightweight integration which doesn't justify the cost of some integration tools out there.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    CRM integrated with Cloud Services could be done in a better way. Our group can help you out with this.

    http://www.ndottech.com/

  • Suggested answer
    Vassil Profile Picture
    Vassil on at
    RE: Synchronization between Dynamics CRM and Azure Cloud Service

    Hi Emerson,

    You can refer to this thread: community.dynamics.com/.../147041.aspx

    Basically you can to use the Azure Service Bus and a custom service for the sync. CRM can push changes to the bus easily, so then you can process the message and update your app. The other way round you need to custom code the pushing of messages to the bus.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans