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.
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?
Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in