Query based vs. Query Publisher based integration

What is the current best practice when doing integrations into Dynamics 365 (on prem)?

 

Source data resides in SQL Server, but should I design using a Query based dts applying Bulk features?

Or, should I use a Query based publisher using the MSMQ?

 

Data arrives typically once each day and holds data for 2.000-50.000 account updates. Peak load is 500.000 accounts...

 

All articles and blog posts are 5+ years old on this subject and I suspect that Scribe has been enhanced since then.

 

I'd love to hear your thoughts on this.

(7) Answers

Login