
Systems of record
Saved query
SQL Server · open_orders
HubSpot API
deals
SFTP folder
/invoices · CSV
Data stores
Northwind project · kept current
open_orders
merge by order_id
deals
merge by deal_id
invoices
merge by invoice_id
Last run 6:00 · only changed rows fetched
38 / 1,240
Syncs and data stores
Kept current without anyone rebuilding an export.
A sync brings in a saved query, an app's API or a folder on an interval, a clock time or cron, and merging by key fetches only what changed. Your source stays the system of record.







