Search code examples
c#.netdynamics-crm

How to export/import Data from Microsoft Dynamics crm

I am a Java developer and new to C# and .Net so my question may seem to be very basic but answer with some example reference will be highly appreciable.

My application wants to communicate with Microsoft Dynamics CRM. Basically I want to sink the data between my App and Dynamics CRM.

I am looking answers for following:

  1. Do Microsoft Dynamics CRM provides some API to export data?
  2. Is there any a kind of listener which my App can keep listening to know that database have been modified?
Solution

  • To answer your questions directly:

    1. Yes. CRM has a fairly robust API. You can utilize the REST services (recommended for client side browser customization) or download the full SDK for more complex integrations. You can build data export logic fairly easily with, especially, the full SDK. However, if you are on-premise you might just want to look at going directly to SQL and running 'select' statements if an automated export is all you want.

    2. Yes. You can develop plugins which fire on CRUD operations and/or you can develop custom workflows which help facilitate automation. The full SDK has information (and there are tons of resources on the web) which help with this.

    Based on the limited information you have posted, I would think you would want to investigate plugin and custom workflow development so you can monitor when records are manipulated and then trigger your integration logic.