Integrations
Syntra ODBC works with any SQL client. Here are quick-start guides for popular tools.
TypeScript SDK
Full IntelliSense on every QuickBooks table. Use @syntraodbc/drizzle-schema or @syntraodbc/client for type-safe queries out of the box.
BI & Spreadsheets
Excel
Connect Excel to QuickBooks via ODBC or Power Query. Build live spreadsheets with QB data.
BI & Spreadsheets
Power BI
Build dashboards and reports with live QuickBooks data using the PostgreSQL connector.
BI & Spreadsheets
Tableau
Visualize QuickBooks data with Tableau Desktop using Live or Extract connections.
Programming
Python
Query QuickBooks with pyodbc, SQLAlchemy, or pandas for data analysis and automation.
Programming
Node.js
Connect Node.js apps to QuickBooks using the pg package. Build APIs and integrations.
ORMs & Frameworks
Prisma
Use Prisma ORM with QuickBooks as a PostgreSQL data source. Type-safe queries.
ORMs & Frameworks
SQLAlchemy
Full SQLAlchemy support: models, queries, and sessions with QuickBooks data.
ORMs & Frameworks
Drizzle
Lightweight TypeScript ORM with QuickBooks via PostgreSQL. Schema inference included.
Don't see your tool? Syntra ODBC works with any SQL client that can speak to the Syntra SQL server.
View connection string reference →