Canonical: https://molo17.com/autocrib-a-gluesync-success-story/ Markdown mirror: https://molo17.com/autocrib-a-gluesync-success-story/index.md Title: AutoCrib Success Story: SQL to IoT Data Sync Solution | MOLO17 Description: AutoCrib Success Story: Syncing SQL Server to Couchbase for 20,000+ IoT vending machines with offline-first capabilities. CASE STUDY # AutoCrib bridges ERP data and offline-first IoT devices. Bi-directional sync from Microsoft SQL Server to Couchbase for mobile IoT clients with a transaction-proof offline cache. [Book a Demo](/book-a-demo/) [See how it works](/gluesync/)  Customer AutoCrib Industry Industrial IoT / vending Company size 20,000+ machines · Fortune 500 customers Use case SQL Server → Couchbase, offline-first IoT THE CHALLENGE ## MS SQL Server apps had to reach IoT hardware inside every vending machine — including offline. AutoCrib’s MS SQL Server-based applications, used by thousands of customers worldwide, needed to connect with IoT hardware embedded in vending machines for inventory management with offline capabilities. - **Transaction-proof inventory** Data had to be transaction-proof for inventory accuracy. - **Thousands of schemas** A single Gluesync instance needed to manage 2,000+ schemas. - **Offline-first cache** IoT clients on customer premises needed a transaction-proof offline cache. - **ERP to the edge** Replicate vending software data out to devices without breaking core systems. The solution ## Couchbase plus Gluesync for bi-directional IoT sync. With Couchbase and MOLO17 Gluesync, AutoCrib found a solution that replicates from MS SQL Server to IoT devices across the fleet. SQL Server vending software Gluesync bi-directional CDC Couchbase mobile / IoT 20k+ Industrial vending machines 2,000+ Schemas on one instance 1 yr+ Saved vs building in-house > Gluesync saved us one year or more of developing our own integration between Couchbase and Microsoft SQL Server. The MOLO17 engineering team worked hand in hand with our development team to tailor the solution to fit our needs. > > **Paul Meza** Director, Product Development and Support AUTOCRIB  Want similar results? ## Start your first real-time pipeline today. Talk to the team or read another customer story. [Book a Demo](/book-a-demo/) [Read more case studies](/case-studies/)