Contact Us Today!

Optimizing Data Integrations

Optimizing Data Integrations

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.

Once the integration has completed, you can view statistics.

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

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:

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 Services, Backup and Disaster Recovery, Cloud Based Computing and Unified Communication Systems.


theProfessor

theProfessor

Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.