BI & Spreadsheets

Tableau + QuickBooks Desktop

Connect Tableau Desktop to QuickBooks Desktop using the built-in PostgreSQL connector. Create rich visualizations with live or extracted accounting data.

Quick Start

  1. Open Tableau Desktop. Under Connect → To a Server, click PostgreSQL.
  2. Enter connection details. Server: localhost, Port: 5433, Database: quickbooks.
  3. Authenticate. Username: syntra, Password: your config.toml password. Check Require SSL only if you've enabled SSL in Syntra.
  4. Choose connection type. Select Live for real-time queries or Extract for a local snapshot.
  5. Drag tables to the canvas. Add tables like invoices, customers, and invoice_lines to the data model, and define joins visually.

Live vs Extract

Live

  • Queries run against Syntra in real time
  • Always reflects current QuickBooks data
  • No extract file to manage
  • Performance depends on data volume

Extract

  • Data saved as a .hyper file locally
  • Extremely fast dashboard rendering
  • Schedule incremental or full refreshes
  • Best for large datasets and published workbooks

Custom SQL for Initial Data

Instead of dragging tables, click New Custom SQL on the data source canvas to write your own query. This lets you pre-filter and shape data before it enters Tableau:

SELECT
  i.txn_date,
  i.ref_number        AS InvoiceNumber,
  c.full_name         AS Customer,
  c.city,
  c.state,
  il.item_ref_full_name,
  il.quantity,
  il.amount,
  i.balance_remaining
FROM invoices i
JOIN customers c ON i.customer_ref_list_id = c.list_id
JOIN invoice_lines il ON i.txn_id = il.txn_id
WHERE i.txn_date >= '2024-01-01';

Tips for Tableau

  • ✓ Use Extract mode for published workbooks on Tableau Server. Schedule refreshes via Tableau's built-in scheduler.
  • ✓ Add geographic roles to Customer State/City fields for instant map visualizations.
  • ✓ Create calculated fields like DaysOutstanding = TODAY() - [txn_date] for aging reports.

Full walkthrough with screenshots: Tableau integration docs →

Visualize QuickBooks data in Tableau

Download Syntra ODBC and start building Tableau dashboards in minutes.

Download Free Trial