Tableau integration

Connect QuickBooks Desktop to Tableau through ODBC

Build sales and receivables dashboards from QuickBooks invoices and customers. Syntra’s QuickBooks ODBC driver gives Tableau a SQL data source with cached reporting and configurable Enterprise live reads.

This walkthrough uses Tableau Desktop on Windows and QuickBooks Desktop Pro, Premier, or Enterprise 2018+. QuickBooks Online requires a different connector.

Prepare the QuickBooks connection

• Install Syntra on your QuickBooks machine, authorize the company file, and allow the initial sync to finish.
• For this local setup, run Tableau Desktop on the same Windows machine. Syntra’s installer supplies a System DSN named Syntra QuickBooks.
• Tableau Desktop 2023.3 and newer use 64-bit ODBC drivers. Check the 64-bit System DSN if your data source does not appear.

Connect Tableau to the Syntra ODBC data source

1. Open Tableau Desktop. Under Connect → To a Server → More, choose Other Databases (ODBC).
2. Select the Syntra QuickBooks DSN. It uses Syntra’s local endpoint at 127.0.0.1:5433 and database qbconnect.
3. Enter the credentials from Syntra’s config.toml. The default username is qbconnect; use your configured password.
4. Select the public schema and choose a table, or use New Custom SQL for a specific reporting dataset.
5. Start with an Extract for a repeatable reporting snapshot. Evaluate Live mode against the queries and freshness requirements of your dashboard.

For DSN-less configuration and connection troubleshooting, see the Tableau connection reference. The bundled driver connects to Syntra; a separate PostgreSQL installation is not required.

Example: sales by customer in Tableau

Use this query to get one row per invoice. Keeping this dataset at invoice level avoids repeating an invoice’s total for every line item.

SELECT
  txn_id,
  txn_date,
  ref_number AS invoice_number,
  customer_ref_full_name AS customer,
  total AS invoice_total,
  balance_remaining
FROM invoices
ORDER BY txn_date DESC;

1. Create a worksheet and put customer on Rows.
2. Add SUM(invoice_total) to Columns to compare invoiced sales by customer.
3. Add txn_date as a date filter for the reporting period.
4. Create a second worksheet using SUM(balance_remaining) for outstanding balances, then combine the worksheets in a dashboard.

This example measures invoice totals, not a reconciled profit-and-loss report. For accounting reports, review the native QuickBooks report reference.

Live connections, extracts, and QuickBooks data freshness

Live: query Syntra when Tableau needs data

A Live connection sends queries to Syntra instead of a Tableau extract. Syntra may answer from its local cache, so Live mode alone does not guarantee the newest QuickBooks edit. The Pro plan adds direct Enterprise live reads for supported tables when configured.

Extract: work from a reporting snapshot

An extract stores the retrieved data in Tableau. Refresh the extract to retrieve a newer dataset, and account for Syntra’s sync timing as well. Use the same filters and read settings when comparing Live and Extract performance.

Publishing and scheduled refresh

A workbook that connects locally still needs a connection on its refresh host. For Tableau Server, configure the matching driver and DSN on the server and make sure the service account can reach Syntra. A DSN pointing to 127.0.0.1 refers to the refresh machine itself, not your original workstation.

Validate the server platform, network access, credentials, and licensing before scheduling refreshes. Follow Tableau’s ODBC publishing guidance and contact Syntra support for your deployment.

Troubleshoot the Tableau integration

• Missing DSN: check the driver architecture and the System DSN visible to the account running Tableau.
• No connection: confirm Syntra is running and the DSN points to the right host, port, and database.
• Repeated totals: avoid summing invoice-header totals after joining them to invoice lines. Use a dataset with a consistent row level.
• Stale dashboard: check both the Tableau extract refresh and Syntra’s last sync or live-read configuration.

For other reporting tools, see QuickBooks to Excel and QuickBooks to Power BI. Review the QuickBooks ODBC driver comparison if you are evaluating alternatives.