Fivetran

Fivetran maintains a library of 700+ fully-managed, pre-built connectors to SaaS, database, and API sources (Salesforce, HubSpot, Stripe, PostgreSQL, MongoDB, etc.). Each connector abstracts authentication, schema detection, incremental sync logic, and API pagination handling. Connectors are deployed as managed services on Fivetran infrastructure, eliminating the need for custom extraction code. The platform automatically handles rate limiting, retry logic, and API version changes without user intervention.

Fivetran automatically detects source schema on first sync and maps columns to destination data types. When source schemas change (new columns, type changes, table additions), Fivetran detects these changes and either auto-applies them or alerts users based on configuration. The platform maintains a schema history and supports rollback to previous versions. Schema mapping is bidirectional for reverse ETL (Activations), allowing data to flow back to source systems with automatic type coercion.

Fivetran maintains multiple security and compliance certifications including SOC 2 Type II, HIPAA BAA, ISO 27001, PCI DSS Level 1, HITRUST, and GDPR compliance. The platform provides encryption in transit (TLS) and at rest, role-based access control (RBAC), audit logging, and data residency options. Fivetran undergoes regular third-party security audits and penetration testing. The platform supports single sign-on (SSO) and multi-factor authentication (MFA) for enterprise accounts.

Fivetran allows users to configure sync frequency per connector, with options ranging from 15-minute intervals (Standard tier) to 1-minute intervals (Enterprise tier). Schedules can be set to specific times of day, days of week, or continuous polling. Fivetran automatically handles sync timing across multiple connectors to avoid resource contention. The platform provides sync history showing execution time, rows synced, and any errors. Failed syncs are automatically retried with exponential backoff.

Fivetran monitors sync health and provides alerts for failures, schema changes, and data anomalies. The platform tracks sync status (success, failure, partial), row counts per sync, and execution time. Users can configure email or webhook alerts for sync failures, and Fivetran automatically retries failed syncs with exponential backoff. The platform provides a dashboard showing connector health across all pipelines, with drill-down into sync logs and error messages. Fivetran also detects schema changes and alerts users to potential breaking changes.

Fivetran allows a single connector to load data into multiple destinations (data warehouses, data lakes, etc.) simultaneously, with independent sync schedules and transformation pipelines per destination. This enables teams to maintain multiple analytics environments (dev, staging, production) or serve different use cases (BI, ML, data science) from a single source connector. Data is loaded in parallel to all destinations, and Fivetran manages schema consistency across destinations.

Fivetran implements incremental sync strategies tailored to each source: timestamp-based incremental (for sources with updated_at columns), cursor-based incremental (for sources with auto-incrementing IDs), and native CDC (for databases with transaction logs like PostgreSQL WAL, MySQL binlog, Oracle LogMiner). The platform automatically detects the optimal sync strategy per table and maintains cursor state to avoid re-syncing historical data. For supported sources, Fivetran can capture deletes and updates in near-real-time, reducing data warehouse storage and compute costs.

Fivetran natively integrates with dbt (data build tool) to orchestrate SQL transformations on loaded data. Users define dbt models in their repository, and Fivetran schedules and executes dbt runs on a configurable cadence (hourly, daily, etc.) after data loads complete. Fivetran manages dbt state, handles dependencies between models, and provides execution logs and failure alerts. The platform supports both dbt Cloud and dbt Core, with pricing based on monthly model runs (MMR) rather than compute time.

Fivetran Activations (powered by acquired Census technology) enables reverse ETL: syncing transformed data from warehouses back to SaaS destinations (Salesforce, HubSpot, Marketo, etc.). Users define activation rules (e.g., 'sync high-value customers to Salesforce'), and Fivetran automatically maps warehouse columns to destination fields, handles upserts, and manages identity resolution. Activations support both batch and streaming modes, with automatic schema mapping and type coercion. The platform tracks activation history and provides audit logs for compliance.

Fivetran provides a Connector SDK allowing teams to build custom connectors for proprietary or niche data sources not in the pre-built library. The SDK abstracts authentication, pagination, schema detection, and incremental sync logic, requiring developers to implement only source-specific API calls. Custom connectors are deployed to Fivetran infrastructure and can be shared with other team members or published to the Fivetran marketplace. The SDK supports versioning and automatic updates without breaking existing deployments.

Fivetran uses a proprietary Monthly Active Rows (MAR) metric to meter usage and calculate pricing. MAR is defined as the number of rows moved (from source to destination) in a calendar month, regardless of row size or complexity. Pricing is tiered: free tier includes 500K MAR/month, and paid tiers charge per MAR consumed (e.g., $0.002–$0.01+ per row depending on source complexity). Fivetran provides usage dashboards showing MAR consumption per connector and per destination, with alerts for approaching limits. Annual contracts offer up to 22% discounts.

Fivetran offers a managed data lake service that loads data directly into open table formats (Apache Iceberg, Delta Lake) on cloud object storage (S3, GCS, Azure Blob). The service handles schema management, partitioning, and compaction automatically, reducing operational overhead compared to self-managed data lakes. Data is stored in open formats, reducing vendor lock-in and enabling direct query access from any SQL engine (Spark, Presto, Trino, etc.). Fivetran manages data lifecycle policies (retention, archival) and provides cost optimization recommendations.

Fivetran exposes a REST API (available on Standard tier and above) enabling programmatic management of connectors, transformations, and activations. The API supports CRUD operations on connectors (create, read, update, delete), triggering manual syncs, retrieving sync history and logs, and monitoring connector health. The API uses standard REST conventions with JSON payloads and supports pagination for large result sets. Authentication is via API tokens, and rate limiting is enforced per account.

Fivetran offers a hybrid deployment option allowing customers to run Fivetran agents on-premises or in private networks, enabling secure access to data sources that cannot be exposed to the public internet. The agent runs on customer infrastructure and communicates with Fivetran cloud services via outbound HTTPS connections. This enables Fivetran to access databases, APIs, and systems behind firewalls without requiring inbound network access or VPN tunnels. Agents are managed and updated by Fivetran, reducing operational overhead.