analytics-dictionary / tool overview / data infrastructure

Fivetran

Fivetran is a managed ELT service with connectors for many SaaS tools and databases.

Written by Reflective Data experts · updated Oct 5, 2026

It automates extraction and loading into a warehouse, handling schema changes along the way, and is typically paired with dbt for transformation.

Convenient for standard sources; custom sources and unusual needs may require additional tooling.

// how we can help

Moving data into your warehouse? Our managed pipelines run it for you. Managed data pipelines → · Browse integrations

A data lakehouse combines the low-cost storage of a data lake with the management and query…

Single sign-on lets users access many tools with one login managed by a company identity provider.

Entity resolution is determining whether different records refer to the same real-world entity, such as a…

An idempotent process gives the same result no matter how many times it runs.

A materialized view stores the precomputed result of a query, so reports read it quickly instead…

Snowflake is a cloud data platform used as a data warehouse, with storage and compute scaled…