Installation
System Requirements
Section titled “System Requirements”- Operating System: Windows 10 or Windows 11 (64-bit), or Windows Server 2019 and newer
- QuickBooks Desktop:
- Pro or Premier (2018 or newer): Syntra ODBC serves reads from its local cache and writes directly to QuickBooks. Writes require QuickBooks to be running.
- Enterprise (2018 or newer): everything Pro and Premier support, plus live reads directly from QuickBooks data, so queries can return up-to-the-second data without waiting for a cache sync.
- Disk Space: ~100 MB for Syntra itself, plus cache storage. Cache size varies by company file: small files stay under 50 MB, large files with many transactions can reach 500 MB or more.
- RAM: Syntra ODBC’s own process footprint is roughly 50 MB of resident memory. Your machine still needs enough RAM to run Windows and QuickBooks Desktop alongside it. If your machine already runs QuickBooks comfortably, it has more than enough headroom for Syntra.
Download
Section titled “Download”- Visit the download page and click Download Syntra ODBC
- Run the installer (
syntra-odbc-setup.exe) - Follow the installation wizard
Installer Components
Section titled “Installer Components”The installer includes:
| Component | Description |
|---|---|
| Syntra ODBC Server | Core server that connects to QuickBooks and serves SQL queries |
| Syntra ODBC Driver (64-bit) | Bundled ODBC driver for 64-bit applications such as modern Excel and Power BI |
| Syntra ODBC Driver (32-bit) | Bundled ODBC driver for 32-bit applications. Both DSNs (Syntra QuickBooks 64-bit and 32-bit) are registered automatically |
| Syntra Query Explorer | Built-in SQL client for browsing tables and running ad-hoc queries |
| Windows Service | Optional: run Syntra ODBC as a background service |
Post-Installation
Section titled “Post-Installation”After installation:
- Launch Syntra ODBC from the Start Menu or Desktop shortcut
- Set up your QuickBooks connection
- Make your first SQL query
Firewall
Section titled “Firewall”The installer automatically adds a Windows Firewall rule for port 5433 (the default Syntra server port). If you use a custom port, you’ll need to add the rule manually.