About the services
About Fivetran
Fivetran is a closed-source, managed ELT service that was created in 2012. As of September 2021, they have built 150 data connectors and have over 2,000 customers. They are considered a reliable choice and have a large customer base. Fivetran charges on monthly active rows (in other words, the number of rows that have been edited or added in a given month).
About Stitch
Stitch is a cloud-based platform for ETL — extract, transform, and load. More than 3,000 companies use Stitch to move data records every day from SaaS applications and databases into data warehouses and data lakes, where it can be analyzed with business intelligence tools. Stitch is a Talend company and is part of the Talend Data Fabric.
Features
Focus
|
Data ingestion, ELT.
|
Data ingestion, ELT.
|
Sources
|
More than 150.
|
More than 130.
|
Destinations
|
All main warehouses and databases.
|
All major data warehouses, lakes and databases.
|
Customizability of connectors
|
Limited through Fivetran’s Cloud functions..
|
Stitch’s Import AI enables their users to push data from anywhere to their destination.
|
Database replication
|
Full table and incremental via change data capture.
Pricing is indexed on rows.
|
Full table and incremental via change data capture.
Pricing is indexed on rows.
|
Integration with data stack
|
Supports dbt transformations.
Airbyte will soon integrate with Prefect, Dagster, Great Expectations, and more. Integrations can be contributed by the community.
|
No.
|
Support SLAs
|
Available
|
Available
|
Security certifications
|
HIPAA, GDPR, SOC 2
|
HIPAA, GDPR, SOC 2
|
Vendor lock-in
|
Annual contracts.
|
Annual contracts. Can leverage Singer’s open-source connectors when used (but connectors are of low quality).
|
Purchase process
|
Requires conversations with sales.
Open-source edition deployable in minutes.
|
Self-service or sales.
|
Pricing
|
Volume-based pricing with MARs (monthly active rows). Credits are not rolled over.
|
Volume-based pricing with new added or edited rows.
|
API
|
Available through Powered by Fivetran.
|
Available.
|
Connectors
Pre-built connectors are the primary way to differentiate ETL / ELT solutions, as they enable data teams to focus only on the insights to build.
Fivetran
Fivetran offers connectors for more than 150 data sources. It supports the major data warehouses and databases as destinations. However, Fivetran doesn’t support any data lakes.
Customers can pay extra and request that Fivetran build a new data source, but no one outside the Fivetran team can build new data sources or make improvements to existing sources.
Fivetran’s customers often end up having to build and maintain custom connectors in-house with their own data engineering teams to address all their custom needs.
Stitch
Stitch supports more than 100 database and SaaS integrations as data sources, and the major data warehouse and data lake destinations.
Customers can contract with Stitch to have them build new sources for them, and anyone can add a new source to Stitch using Singer, their open-source toolkit for writing scripts that move data.
Singer integrations can be run on Stitch to take advantage of their monitoring, scheduling and credential management features. However, most Singer integrations are now deprecating in quality. So you never know the quality of a tap or target until you have actually used it.
Transformation
Fivetran
Fivetran is an ELT tool, and does not transform data prior to loading, either. It offers its own opinionated normalization out of the box, and recently added support for post-load transformations via copy-and-paste SQL and dbt.
Stitch
Stitch is also an ELT tool. It only provides the transformations required for compatibility with the destination, such as translating data types or denesting data when relevant. Aside from this, no extra transformation feature is offered.
Customizability
Every company has custom data architectures and, therefore, unique data integration needs. A lot of tools don’t enable teams to address those, which results in a lot of investment in building and maintaining additional in-house scripts.
Fivetran
Fivetran released cloud functions to let their customers edit connectors by writing small function to fetch data using Go, Java, Node.js, Python, C# or F#. Customers will need to host their functions on a serverless platform.
Stitch
Stitch’s customers can leverage Singer to build custom Singer connectors that they can plug on their Stitch account. However, of the approximately 200 Singer connectors Stitch can leverage to adapt to their needs, most are low quality, as only the top connectors are maintained actively by the Singer community.
Support & docs
Data integration tools can be complex, so customers need to have great support channels. This includes online documentation as well as tutorials, email and chat support. More complicated tools may also offer training services.
Fivetran
Fivetran provides support through an in-app form, but does not offer chat support.
Their documentation is comprehensive, but Fivetran doesn’t offer a Slack or Discourse community.
Fivetran does not provide any training services.
Stitch
Stitch provides in-app chat support to all their customers, and phone support is available for Enterprise customers.
Their documentation is comprehensive and is open source — anyone can contribute to it.
Stitch does not provide training services.
Pricing
Fivetran
Fivetran provides a 14-day free trial. It discloses a pricing based on monthly active rows, i.e., rows that are added or edited in a given month.
Fivetran’s volume-based pricing doesn’t adapt well with database replication use cases that involve the replication of millions of rows.
Stitch
Stitch provides a 14-day free trial. It discloses a pricing based on rows synced.
Stitch’s volume-based pricing doesn’t adapt well with database replication use cases that involve the replication of millions of rows.
Standard plans range from $100 to $1,250 per month depending on scale, with discounts for paying annually.