Fivetran

Fivetran

by Fivetran • • ETL Tools

No reviews yet
Free plan available View plans

Fivetran is a managed data integration platform that loads SaaS and database sources into cloud warehouses and data lakes, priced by monthly active rows.

Fivetran is a managed data integration platform that moves data from SaaS applications, databases and other sources into a cloud data warehouse or data lake and keeps it current. It replaces the pipeline code a data team would otherwise write, run and repair each time a source changes its API or its schema. Fivetran Inc., founded in 2012 and based in Oakland, California, builds and operates it. The company completed its merger with dbt Labs in June 2026 and is initially operating as Fivetran + dbt Labs. The platform sells from fivetran.com under one plan that covers its three metered parts: Connections, Transformations and Activations. Connections are fully managed connectors. A team picks a source and authorises it; Fivetran runs the first load, then incremental syncs that pull only new or modified data. Database sources can be read from binary logs, logical replication or change tables where the source supports it. Automatic schema migrations carry new columns and type changes through to the destination. Column blocking keeps unneeded or sensitive fields out of the warehouse, and column hashing masks personal data during the load on the connectors that support it. Transformations run SQL models in the destination after each sync or on a schedule, with Quickstart data models for common sources and Integration for dbt Core. The Managed Data Lake Service writes Iceberg tables to object storage, and Activations push warehouse data back into business applications. The Connector SDK lets engineers write a Python connector for a source the catalogue lacks. A REST API and an official Terraform provider manage connections and schedules as code. Hybrid Deployment runs the pipeline workers inside a customer's own cloud while Fivetran hosts the control plane. Fivetran is built for data engineering and analytics teams that want a warehouse or lake fed automatically rather than by hand-built pipelines. That includes analytics engineers standardising on Snowflake, Databricks, BigQuery, Azure or AWS, platform teams that manage infrastructure through Terraform, and organisations in regulated industries that need hybrid deployment, customer-managed keys or PCI DSS Level 1 on the higher plans. It is bought as one usage-based subscription measured in monthly active rows, with a free plan to start on and no per-user charge on the paid plans. Its everyday jobs are landing marketing, sales and finance application data beside replicas of production databases for BI reporting, building the data foundation for analytics and AI work, and moving a legacy integration stack onto a managed service. It sits upstream of the warehouse and the BI layer, beside dbt Core for modelling and Apache Airflow for orchestration. Its documentation, changelog, status page, support portal and full API reference are public at fivetran.com.

Features

  • Included: Managed source connector library
  • Included: Custom connector builder
  • Included: Incremental loads after the first sync
  • Included: CDC mode for database sources
  • Included: Automatic schema drift handling
  • Included: Sync frequency down to minutes
  • Included: Column selection and exclusion
  • Included: In-flight column hashing
  • Included: Post-load transformations in the warehouse
  • Included: Data lake destinations in open formats
  • Included: Per-sync run logs and row counts
  • Included: Sync failure notifications
  • Included: Single-table resync
  • Included: Pipelines managed by API or Terraform
  • Included: Self-hosted data plane option
  • Not included: Open source ETL engine

Additional Features

  • Fully managed source connectors
  • Connector SDK for custom Python connectors
  • Incremental syncs after the initial load
  • Log-based change data capture for databases
  • Automatic schema migrations
  • 15-minute syncs on the Standard plan
  • 1-minute syncs on the Enterprise plan
  • Column blocking
  • Column hashing on supported connectors
  • Transformations run after each sync or on a schedule
  • Quickstart data models
  • Integration for dbt Core
  • Managed Data Lake Service with Iceberg tables
  • Sync logs with record counts and timings
  • Email alerts on sync failures
  • Table re-sync on supported connectors
  • REST API
  • Official Terraform provider
  • Hybrid Deployment of pipeline workers in your own cloud
  • Activations to business application destinations
  • Audience Hub
  • Role-based access control
  • Custom roles and SCIM
  • SSH and VPN tunnels
  • Customer-managed keys
  • PCI DSS Level 1
  • Private networking

Best for

  • Analytics engineering teams feeding Snowflake, Databricks or BigQuery
  • Data teams replacing hand-built pipeline code with a managed service
  • Platform teams that manage pipelines as code through Terraform
  • Marketing and revenue analytics teams centralising ad and CRM data
  • Teams already modelling in dbt Core
  • Regulated organisations that need hybrid deployment or customer-managed keys
  • Small teams starting on the Free plan under its usage allowance
  • Enterprises consolidating data integration under one annual agreement

Use cases

  • Replicating production databases into a cloud warehouse
  • Loading SaaS application data for BI reporting
  • Change data capture from operational databases
  • Running dbt models automatically after each load
  • Building Iceberg tables in a data lake on object storage
  • Masking personal data before it reaches the warehouse
  • Syncing warehouse audiences back into business tools
  • Managing pipelines as code with Terraform
  • Keeping pipeline workers inside a private cloud
  • Building the data foundation for AI and agent workloads
  • Migrating a legacy integration stack to a managed service

Screenshots & Videos

Explore Fivetran in action

Fivetran Homepage
View full size
Fivetran Homepage

User Reviews

Write a Review

No reviews yet

Be the first to share your experience with this software.

Want to claim this brand?

To claim this brand, please contact support.