Dynamics Mechanics

Introduction to Data Integration Patterns


Listen Later

In this episode (brought to you by KingswaySoft), we discuss data integration strategies and considerations when building Dynamics 365 systems. Integration is a very significant topic when it comes to more complex and intricate systems that require interaction with other corporate systems. When we migrate and deploy systems to cloud environments, we must take even more care as the consequences of poor decisions become more severe.  

Topics discussed in this episode

  • Considerations for choosing between data replication versus direct query integration strategies
    • What is the data volume?
    • What is the data velocity (of change)?
    • What are the data freshness requirements?
    • Forecasted cost of CRM database storage?
  • Challenges of the direct data query pattern from Dynamics online to on-premises assets
    • Network Latency
    • External team dependencies (security/network teams)
    • Corporate policies and guidelines
  • Integration patterns for cloud and on-premises
    • Architecting data to live as close to Dynamics as possible
    • Ways users can access on-premises data externally
    • Using virtual entities

Show Resources

  • Cache-Aside Pattern (referred to as the proxy cache pattern)
  • Azure CosmosDB
  • Virtual Entities

Subscribe to the CRM Audio Podcast Network to hear other podcasts like this one.

Got feedback or suggestions for a future episode? Email [email protected]

This episode is a production of Dynamic Podcasts LLC.

...more
View all episodesView all episodes
Download on the App Store

Dynamics MechanicsBy Stephan Smith