Harnessing the Power of Microsoft Dynamics CRM's New Bulk Data Load API
Microsoft Dynamics CRM has never been an information island by itself. It is often the case that you need to integrate your CRM data with other applications or databases in your organization or from third-party partners.
When it comes to Microsoft Dynamics CRM data integration, the performance of data loading has always presented a challenge. To be more specific, writing data through the CRM web service interfaces is slow, just like any other web service interfaces. With a direct database connection, you can potentially write thousands or even millions of records to your target table within a second. However, when you write to CRM web service interfaces, the best you can typically expect would be a few dozen records per second using a single-threaded data load process that targets a single CRM server.