About the services
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.
About Matillion
Matillion is a self-hosted ETL solution, created in 2011. It supports about 100 connectors and provides all extract, load and transform features. Matillion is used by 450 companies in 40 countries. Being self-hosted means that Matillion ensures your data doesn’t leave your infrastructure. You might have to pay for several Matillion instances if you’re multi-cloud.
Focus
|
Data ingestion, ELT.
|
Data ingestion, data transformation, and business intelligence.
|
Sources
|
More than 130.
|
More than 100.
|
Destinations
|
All major data warehouses, lakes and databases.
|
All major data warehouses, lakes and databases.
|
Customizability of connectors
|
Stitch’s Import AI enables their users to push data from anywhere to their destination.
|
No.
|
Database replication
|
Full table and incremental via change data capture.
Pricing is indexed on rows.
|
Full table and incremental via SELECT/replication key, timestamp or change data capture for AWS-hosted Matillion ETL instances.
|
Integration with data stack
|
No.
|
No.
|
Support SLAs
|
Available
|
Available
|
Security certifications
|
HIPAA, GDPR, SOC 2
|
GDPR
|
Vendor lock-in
|
Annual contracts. Can leverage Singer’s open-source connectors when used (but connectors are of low quality).
|
Annual contracts. Self-hosting implies a higher lock-in.
|
Purchase process
|
Self-service or sales.
|
Sales only.
|
Pricing
|
Volume-based pricing with new added or edited rows.
|
Based on the number of Virtual Core Hours used.
|
API
|
Through API.
|
No.
|
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.
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.
Matillion
Matillion integrates with about 100 data sources. Customers can request Matillion to build a new data source, but no one outside the company can build new data sources or make improvements to existing sources.
Matillion only supports Redshift, Snowflake, BigQuery, Azure Synapse Analytics and Delta Lake as destinations.
Transformation
Stitch
Stitch, like several other stitch alternatives in the market, functions as an ELT tool. Its primary focus is on executing the transformations essential for ensuring compatibility with the destination platform. These transformations include tasks like translating data types and denesting data when necessary. However, Stitch does not offer additional transformation features beyond these essential functions.
Matillion
Matillion offers post-load transformations through what it calls Transformation Components. Users can create Transformation Components via point-and-click selection or by writing them in SQL.
Matillion does not support external transformation tools, such as dbt.
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.
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.
Matillion
Matillion doesn’t provide any customizability, unfortunately.
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.
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.
Matillion
Matillion provides support through an online ticketing system accessible through a support portal or via email.
Documentation relies on articles accessible through the support portal.
Matillion does not have any Slack or Discourse community to provide help.
The company doesn't provide training services, but tutorial videos can be found on YouTube.
Pricing
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.
Matillion
Matillion offers a 14-day free trial. Its pricing depends on the cloud platform on which the customer's data warehouse runs.
The pricing model is based on Virtual Core Hours, which will depend on the instance size customers run. Annual billing plans are available with discounts.
