Guides · free
Sage 100 integration guides
Answers to the questions developers ask most often about getting data in and out of Sage 100. Each guide cites its sources.
Not sure which route fits? Connecting Sage 100 in 2026: every option, honestly compared puts ODBC, BOI, eBusiness Web Services, Visual Integrator and third-party connectors in one table, with read or write, 64-bit status, skill and cost. It prints on one page, so Sage partners can send it to a client.
01How to connect Sage 100 to Shopify or a web appThree patterns that work, data mapping for orders, customers, items and stock, and how to stop duplicate orders.
02How to query Sage 100 with SQL through the SOTAMAS90 ODBC driverConnection strings, 32- and 64-bit, the ProvideX SQL dialect, and queries for customers, open orders and stock.
03The Sage 100 Business Object Interface (BOI)What it is, when you need it instead of ODBC, and a sales order example in Python.
04Sage 100 sData was removed in 2025. What replaces it?What changed in version 2025, what Sage recommends, and four options for an integration that used sData.
05Sage 100 2026 is 64-bit only: what breaks in your integration and how to fix itWhat changed from 2021 to 2026, what fails in 32-bit ODBC, BOI and scheduled jobs, the fix for each, and a vendor checklist.
06How to read Sage 100 data in Python with hundred-odbc and pandasInstall, connect, customers, open orders and items into DataFrames, the 64-bit check, and the common errors.
07Sage 100 EDI: mapping X12 850, 856 and 810 to sales orders, shipments and invoicesWhich 850 fields fill a sales order, where ship notice and invoice data lives in Sage 100, and the EDI providers that integrate with it.
08Sage 100 purchase orders, receipts of goods and inventory by warehouseCreate a purchase order and post a receipt through BOI in Python, then read on-hand and on-order stock per warehouse over ODBC.
Building a product or a practice that integrates Sage 100 for many clients? Read what Hundred plans for software vendors and Sage partners.
Hundred is a planned REST API for Sage 100. Early access, rolling out in stages.
Join early access