Dynamics 365 and Cloud Database Integration for Near Real-Time Data Synchronization
Client
The end Client is a US-based association that makes a solid contribution to American musical culture.
Challenge
The end Client had a Cloud database connected to a number of their corporate systems. After migration to Dynamics 365, they faced a problem with synchronizing data between their new CRM and the Cloud database, which started to affect interactions with their clients. Therefore, the end Client required a neat solution that would enable an ongoing data transfer between their new Dynamics 365 and the Cloud database.
Solution
ScienceSoft's MS Dynamics consultants delivered an integration solution composed of two Windows services.
The first one performs regular data synchronization between Dynamics 365 and the Cloud database. As this service is easily configurable by non-IT users, the end Client needs no IT assistance to change check frequency and data types depending on their needs. To ensure quick user adoption of the solution, ScienceSoft provided a training and delivered a detailed manual.
The second Windows service runs real-time synchronization of time-sensitive data (for the end Client’s business), such as contacts, memberships and attachments. This service performs data checks every 5 seconds and initiates data changes in the Cloud database or Dynamics 365 with regard to the priority of the data source.
Finally, to enable correct data collection, mapping and updating, ScienceSoft’s team did the necessary tweaks to the Cloud database and Dynamics 365.
Results
The delivered integration solution helped the end Client to solve their post-migration challenge of client data inconsistency among corporate systems. Due to easy configurability of the solution, the end Client has a full control of the data flows. Also, as business-critical data is synced in less than 5 seconds, the end Client managed to improve their clients’ brand experience.
Technologies and Tools
Dynamics 365 API, Microsoft Azure SQL Database, .NET C#.
