Monday, April 08, 2013

Presentation on Enterprise Data Integration for Microsoft Dynamics CRM

I will be presenting for XrmVirtual tomorrow by the topic of Enterprise Data Integration for Microsoft Dynamics CRM. The session starts at 9am PST Apr 9th, 2013, and it will first kicks off by CRM SDK team to share with us some more recent updates in the latest SDK release (v5.0.15) related to UR13 and CRM Online updates.

My session will starts right after CRM SDK team's announcements and updates. In the session, I will try to cover some data integration options that you might have when working with Microsoft Dynamics CRM projects, including CRM SDK programming, Import Data Wizard, ETL, Service Bus, etc. The session will be concluded by sharing some tips and tricks that I learned when working with some large-scale data migration and integration projects, and also some lessons that I learned while designing and developing SSIS Integration Toolkit for Microsoft Dynamics CRM.

The session has been planned to be a one-hour session which includes CRM SDK team's updates, but I have got the permission from XrmVirtual team that the session can go a little longer (mainly due to the amount of information to be covered in one session), so the entire session could run for about 90 minutes although the original invite is only for 60 minutes.

The following is the download link to the meeting invite, you are more than welcome to join the session if this interests you.

Note that the session will be recorded by XrmVirtual team. If you can't make it, you will still have a chance to view the presentation at a later time. Further information about the session can be found at XrmVirtual website.

XrmVirtual is a user group for professional CRM developers who are passionate about Microsoft Dynamics CRM, and is run by two Dynamics CRM MVPs, Julie Yack and Shan McArthur.

See you then!

[UPDATE - Apr 10, 2013] I have uploaded the presentation deck file and demo code that you can download, check out here. The presentation's video recording is also available for download on XrmVirtual site if you are interested. Watching the video, you would have to bear with my accent, and my poor presentation skills.


  1. Nice presentation for your first!

    Our problem is that when we go parallel, we get generic SQL errors when we start doing inserts/selects/updates at about 3-4 parallel processes from various entities!

    Basically, SQL server cannot handle the parallel load to a particular xxxx_MSCRM db!

    Any options other than getting better hardware?

    1. Thanks Garry! When you write to CRM in parallel, the best strategy is probably to write to one entity at a time. When you write to different entities in parallel, there is a greater chance that you run into generic SQL errors, particularly if those entities have relationship involved.

      Also, the CRM team has made some improvement that reduces the chance of general SQL errors, so you might want to stay updated with more recent rollups if you are using CRM on-premise.

      Thanks again.