Background
One of the clients was running a third-party POS system on MySQL for their on-floor operations โ it handled daily sales fine, but the data stayed trapped in that system:
- The central management platform on SQL Server had no visibility into what was being sold on the floor.
- Every day, someone was manually re-entering sales data from one system into the other.
- The process was slow, error-prone, and completely unsustainable at scale.
- Financial reports and stock counts couldn’t be trusted until the manual entry was done โ which was always hours behind reality.
Solution
Rather than replacing either system, a Desktop Middleware application was introduced to act as a dedicated synchronization bridge between the two platforms. I took over the development and maintenance of this middleware, taking full responsibility for ensuring data moved automatically and keeping both systems aligned without any manual re-entry.
Implementation
- Database Connection & Mapping: I managed and optimized the Hybrid Database Connector responsible for extracting data from the MySQL engine and loading it into SQL Server. I ensured the mapping layer accurately handled a wide range of entitiesโproducts, menus, customers, and depositsโso that POS data aligned perfectly with the receiving Accounting and Sales Logistics modules.
- Validation & UI Enhancements: I refined the transactional logging and validation system to verify every sales and payment record before it entered the accounting ledger, successfully preventing corrupted or incomplete data from flowing through. I also maintained and updated the DevExpress interface, giving users a reliable view of the sync process and the tools to monitor, verify, and execute data transfers manually when needed.
Impact
- Manual data re-entry between the two systems was completely eliminated.
- Financial reports and stock counts became available immediately after sync, rather than hours after manual consolidation.
- Data consistency between the POS floor system and the central Accounting and Sales Logistics modules was enforced automatically on every sync cycle.
- The risk of human error in financial records tied to daily sales was effectively removed.