CRM Software Logo

Microsoft Dynamics 365 & Dynamics CRM experts provide reviews and opinions to aid professionals with the Dynamics 365 selection process.

 
 
Beringer Technology Group

Optimizing Data Integrations

Email | Print

If you are tasked with integrating data, then you know there are a wide variety of challenges to overcome. If one of the challenges is dealing with very large data sets, then your design should be optimized for speed and performance.

 

I find Scribe Online is a great cloud based platform to migrate and transform data between systems, especially when working with Microsoft Dynamics 365. This product has a very intuitive interface. Scribe online can be configured to integrate data from disparate systems at high speeds. The latest release dubbed “Granite” now offers a deeper dive into each operation, and reveals which ones are slowing down the integration.

 

Optimizing Data Integrations

Here’s an integration map I built using Scribe Online. The map queries Dynamics 365 for the existence of a quote created by a foreign system. If it exists in Dynamics 365, then I’ll update it.

Optimizing Data Integrations

 

Once the integration has completed, you can view statistics.

Optimizing Data Integrations

 

 

Dive into the details, and you will discover that the Quote Lookup process accounts for almost 75% of the entire integration time.

Optimizing Data Integrations

 

 

Time to optimize the integration. Microsoft exposes an API call that will allow you to lookup \ create \ update a record all in a single call. Scribe Online exposes this with their Upsert block.  Here’s what my optimized integration map now looks like:

Optimizing Data Integrations

 

Beringer Technology Group is a Scribe certified partner, and has deep experienc migrating and integrating data. Can we help integrate your data with Dynamics 365? Please reach out to us today.

 

Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in Microsoft Dynamics 365 and CRM for Distribution. We also provide expert Managed IT ServicesBackup and Disaster RecoveryCloud Based Computing and Unified Communication Systems.

Ask This Expert a Question / Leave a Comment

 

 
 
Show Buttons
Hide Buttons