Recommendations for performance

Loading data from MSSQL2014 into OnPrem Dynamics CRM 2016 using Scribe 7.9.1 is a slow but necessary task (imho).

As the CRM only processes one row at a time, this turns out to be a serial operation, I have started to look into running .dts in parallel.

I have stumbled upon http://blog.scribesoft.com/what-is-faster-query-publishing-or-queue-publ... recommending using a .bat file to leverage parallelism. Is this stil the recommended approach?

 

Is Scribe itself not capable of running in parallel and submit the requests to the CRM simultaneously? I have tried to allow for multiple sessions in the CRM adapter configuration, but I am not seeing any performance increase.

 

The bat-file approach seems to me as a 'hack' (yet boots performance significantly) and includes som logging issues if the SCRIBEINTERNAL is the preferred  for monitoring.

 

Any recommendations will be welcome.

(7) Answers

Login