Connector frameworks

Fivetran

A managed service that copies data from 700+ sources into your warehouse or lake, now merged with dbt Labs.

fivetran.com · founded 2012 (Y Combinator, 2013) · Oakland, California · researched 2026-10-10

Scope: Fivetran runs hosted connectors that replicate SaaS apps, databases and files into a destination you own, with schema management, delete capture and an SCD2 history mode on some connectors; with dbt it now also transforms, and with Activations writes back to apps. It is not an accounting system and does no bookkeeping or reconciliation; it copies Xero's tables as they are.
Backing: Private, venture-backed; its site cites a $5.6B valuation. Merged with dbt Labs in an all-stock deal announced 13 October 2025 and completed 1 June 2026; the combined company said it would approach $600M ARR. Acquired Teleport Data and HVR (2021); steward of Great Expectations and GX Core (May 2026).
Serves: mid-market, enterprise, smb
Covers: integration, reporting
To ownpurse: Neighbour. Fivetran is how mid-market and enterprise finance teams get Xero and their bank and billing data into one warehouse today. It solves breadth, not ownership: it copies tables to a warehouse for analysts; ownpurse keeps every fact on the owner's machine and rebuilds the books.

What it is

Fivetran is the best-known managed ELT service: hosted connectors that copy data from 700+ SaaS apps, databases and files into a warehouse or lake you own. It was founded in 2012 by George Fraser and Taylor Brown and is based in Oakland. On 1 June 2026 it completed an all-stock merger with dbt Labs, first announced on 13 October 2025 with combined ARR approaching $600M. Fraser is CEO and Tristan Handy President, and the combined company says it serves more than 100,000 data teams.

It does what it does well: connectors that keep running without anyone watching them. It does not do bookkeeping. It copies Xero’s tables as Xero shapes them.

How it works

Fivetran syncs incrementally where the source allows it, captures deletes as soft-delete flags, and on supported tables offers history mode: Type 2 versions with _fivetran_start, _fivetran_end and _fivetran_active. History is guaranteed only from the moment you switch it on, and a re-sync marks earlier records inactive and starts again.

The Xero connector is candid about the source. Reference tables are re-imported every sync and contacts once a day. Deletes are captured for accounts, bank transactions, contacts, invoices, manual journals and payments. Xero does not update UpdatedDateUTC on invoice_line_item, so a changed account code needs a full re-sync. You create your own Xero app and authorise it. Each organisation can be linked to only one connection, and an uncertified app is limited to 25.

Data and access

The pricing is by monthly active rows per connection, on a declining curve. Inserts, updates and deletes count, and every new history-mode row counts too. There is a $5 base charge for each Standard connection between 1 and 1M MAR, and a free plan with 500,000 MAR. The pricing changed on 1 March 2025. The REST API is on every plan, and your data sits in your own destination, so export is not the issue. Cost and lock-in to the pipeline are.

Agents

The official MCP server (MIT, first published January 2026, v0.5.1 on 6 October 2026) is read-only by default. A scope setting raises it to read/write or read/write/delete, and a deny list blocks specific actions. Write tools ask the client model to confirm, but the server does not enforce it. The Connector SDK ships plugins for Claude Code, Codex, Gemini CLI and Copilot, and dbt Summit 2026 added dbt Wizard, a Context Layer, and Lake Compute, a DuckDB engine over Iceberg.

Customers

Mid-market and enterprise data teams. It names OpenAI, LVMH, Pfizer, Verizon and Spotify. A small business can start free, but the product assumes a warehouse and someone to run it. Review-site ratings could not be confirmed. The common complaint is cost under MAR pricing, and both Meltano and dltHub publish guides to leaving it.

History

Fivetran went through Y Combinator in 2013, bought Teleport Data and HVR in 2021, and became steward of Great Expectations in May 2026. Merging with dbt makes it the default enterprise stack for moving data and modelling it.

For ownpurse

Fivetran is the answer larger firms already have to getting their data together: a pipe into a warehouse they rent. ownpurse is the answer for a person or small business that has no warehouse and wants to own the record. Borrow the candour of the Xero notes (the UpdatedDateUTC gap is why ownpurse runs a weekly full sweep) and the read-only-by-default MCP scopes. Avoid history that starts when someone switches it on and resets on a re-sync, and a price on every change: in ownpurse history is the record itself, and reading it costs nothing.

Data and access

Public API: Yes. REST management API (connections, destinations, users, Connector SDK packages); the data itself is read in your own warehouse
Auth: API key and secret; system keys for service accounts
Limits: Rate limits documented on a separate page (figures not confirmed); the source's own limits apply to syncs
What access costs: API on all plans including the trial; usage billed by monthly active rows per connection, with a $5 base charge per Standard connection between 1 and 1M MAR; inserts, updates and deletes count; every new history-mode row counts
Export: All replicated data is in your own destination; Managed Data Lake keeps Iceberg tables in your cloud storage
Notes: The Xero connector requires you to create your own Xero app and authorise it; one organisation per connection; an uncertified Xero app is limited to 25 active connections.

Price

Model: Usage-based by monthly active rows (MAR), priced per connection on a declining curve, plus model runs for transformations
Entry: Free plan: 500,000 MAR, 5,000 model runs a month
Top: Business Critical, or Enterprise License Agreements at a fixed annual price
Notes: Pricing changed 1 March 2025 (re-sync rules, per-connection curves); a $5 per-connection base charge appears on the 2026 pricing page. Example on the pricing page: four ad and marketing connectors for $511.15 a month. Annual contracts save 5% to 22.6%.

Agents

MCP: official
AI features: fivetran/fivetran-mcp (MIT, created January 2026, v0.5.1 on 6 October 2026) answers questions about your account and can manage connections; AI coding-agent plugins for Claude Code, Codex, Gemini CLI and Copilot to build Connector SDK connectors; an AI Connector Agent that generates connectors from API docs; dbt Wizard and a Context Layer (September 2026).
Agent writes: The MCP server is read-only by default; FIVETRAN_SCOPE can raise it to read/write or read/write/delete, and DISALLOWED_ACTIONS denies specific actions.
Approval: Write and delete tools carry advisory warnings asking the client model to confirm, but the server does not enforce confirmation.
Notes: Agents manage pipelines, not books; the Context Layer exposes warehouse context 'via preferred MCP or AI tools'.

Integration and customers

Connects to: 700+ connectors on the Standard plan, destinations across the major warehouses and lakes, dbt, Activations (reverse ETL) and the Python Connector SDK
Notes: Xero connector: re-imports reference tables every sync and contacts daily; captures deletes on accounts, bank transactions, contacts, invoices, manual journals and payments; supports history mode; notes that Xero does not update UpdatedDateUTC on invoice_line_item, so changed account codes need a full re-sync.
Scale: Combined with dbt Labs: more than 100,000 data teams (June 2026); approaching $600M ARR at the announcement (October 2025); dbt alone had 80,000+ teams.
Ratings: Not confirmed (G2, Capterra and TrustRadius unreachable on 2026-10-10).
What customers say: Not confirmed from review sites. Generally known for reliable, set-and-forget connectors; cost under MAR pricing is the recurring complaint, and competitors (Meltano, dltHub) publish migration guides aimed at it.

Timeline

2012
Founded by George Fraser and Taylor Brown; Y Combinator in 2013
2021
Acquires Teleport Data and HVR
2025-03-01
Updated pricing launches, with new re-sync rules and per-connection pricing
2025-10-13
Fivetran and dbt Labs announce an all-stock merger
2026-01-13
fivetran-mcp repository created
2026-05-13
Becomes steward of Great Expectations and GX Core
2026-06-01
Merger with dbt Labs completes; Fraser CEO, Handy President; dbt Core v2.0 alpha under Apache 2.0
2026-09-16
dbt v2, dbt State and Managed Data Lake GA; Context Layer and Lake Compute (DuckDB) in private beta

Borrow and avoid

Borrow: Publishing per-connector quirks plainly (UpdatedDateUTC not bumped on line items, which tables are re-imported); history-mode columns as a familiar SCD2 projection of a fact log; delete capture listed per table; an MCP server that is read-only by default with scopes and a deny list.
Avoid: History that starts only when switched on and resets on a re-sync; pricing per changed row, which makes history and deletes cost money; advisory-only confirmation for agent writes.

Sources

Not confirmed against a primary source

Total funding raised and the round behind the $5.6B valuation
Acquisitions of Census and Tobiko Data (not on Fivetran's press pages reached)
Fivetran-only ARR and customer count after the merger
Dollar rate limits for the REST API
Date the $5 per-connection base charge began (2026 pricing page; no date given)
Review-site ratings and counts (G2, Capterra, TrustRadius unreachable)
Whether Xero's 2026 egress fees fall on the customer's own app under Fivetran's setup (inferred from the setup guide)

On the spectrum

0 to 4. The grey tick is ownpurse.

Custody: 2
Where it runs: 1
History: 2
Openness: 2
Breadth: 3
Autonomy: 2
Agent-ready: 3
Easy to connect: 4
Market: 4

See it on the map

Also in connector frameworks

ownpurse is not affiliated with Fivetran or any company named here. Names are their owners' trademarks. Figures come from the company's own pages and the press, as linked, as of 2026-10-10; scores are our reading of them against the definitions in the landscape. This is not legal or financial advice.