Stertak Sync

Abstract

Stertak Sync is a data synchronization solution designed to integrate Dynamics 365 with QuickBooks, enabling seamless and automated two-way data synchronization between these platforms. The system provides a robust architecture for mapping, transforming, and syncing key business data, such as accounts, invoices, customers, and sales transactions, ensuring data consistency across both systems. The core components of Stertak Sync include the Stertak Table, which stores entity configurations; the Stertak Counter Table, which tracks synchronization progress; and the Stertak Flow, which manages the rules and logic for data transformation and flow between Dynamics 365 and QuickBooks. Stertak Sync also incorporates error handling, logging mechanisms, and scheduling features to ensure reliability and transparency in the synchronization process. Additionally, it supports Power Automate integration, allowing users to trigger additional actions based on synchronization events. The project leverages modern technologies such as C sharp for Dynamics 365 integration, the QuickBooks SDK, and Python for API management. Security is ensured through encrypted data transmission, role-based access control, and auditing of synchronization activities. Stertak Sync enhances operational efficiency by automating routine data transfers and eliminating manual data entry errors, making it an invaluable tool for organizations relying on Dynamics 365 and QuickBooks for their business processes. This report details the system architecture, implementation, and testing procedures, along with the challenges encountered and solutions applied during the development of Stertak Sync.