Using Homogenous Batch / Bulk operation messages for improved performance – Data Migration / Dataverse

Microsoft has introduced Bulk Operation messages in the platform, which can now be used in SSIS Packages that use KingswaySoft's SSIS Integration Toolkit for Microsoft Dynamics 365. By enabling the Homogeneous Batch Operation Messages option in the CDS/CRM Destination Component Editor, users can see significant performance improvements when working with custom tables. The article provides a detailed analysis of different variations of batch size, threads, multiplexing users, and the Homogeneous Batch Operation option for both custom and contact tables. It also highlights the importance of being cautious when working with tables that have a higher number of fields/relationships to avoid server-side throttling errors.

Article 5d

Login now to access my digest by 365.Training

Learn how my digest works
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time