Matillion is a popular ELT tool, but it may not be right for every business.
The right ETL solution enables you to collect insights from the data you collect. But the wrong platform can leave you stuck with poor data quality and disjointed sources.
So, is Matillion the right data ingestion tool for your business needs?
Today we'll break down its key advantages, notable downsides, and share the 10 top Matillion alternatives that might be a better fit for your organization.
Matillion is a data aggregation and ELT tool that focuses on large businesses. Matillion is made of two separate tools: Matillion Data Loader and Matillion ETL.
Confusingly, Matillion does not actually offer an ETL tool at all---it simply calls its ELT tool "Matillion ETL" because it's a more common term.
Unlike most tools that only offer a managed SaaS solution, Matillion features an on-premise deployment option as well. It's also a platform with an all-in-one solution that includes both data extraction and data transformation.
That said, Matillion has some serious downsides. Its pricing model is fairly outdated, with a credit-based (hourly) structure that can be hard to predict from one month to the next.
Matillion users also run the risk of vendor lock-in, since it's built as an all-in-one platform and doesn't integrate as well with third-party tools.
And perhaps most critically, Matillion only has 110+ data source connectors---one of the smallest libraries among best-in-class ETL/ELT tools.
Free: Limited to 1 million rows per month
Basic: $2.00/credit
Advanced: $2.50/credit
Enterprise: $2.70/credit
Native GUI-based data transformation features that are very robust and help teams organize queries and relationships
Both managed SaaS and on-premise deployment solutions available
Combined platform with both data loading and transformation capabilities make it easier to implement best data security and data governance practices
Supports major destinations including Snowflake, Google BigQuery, Amazon Redshift, Microsoft Azure Synapse Analytics, and Databricks
Only 110+ data connectors built in
GUI-based transformation interface can be intimidating at first
Only supports ELT workflows, so businesses looking for ETL need to find another solution
Credit-based pricing that can be hard to understand and predict month-to-month
Vendor lock-in due to Matillion being an all-in-one solution with fewer integrations with other third-party tools
Portable is a platform that offers support for the data connectors you won't find with Matillion.
With Portable, you not only get access to all existing connectors (built for long-tail sources most major platforms don't offer), but you can request custom connectors.
The Portable team can turn around new connectors in a few days or even a few hours, and maintains them indefinitely at no extra cost.
Manual: Unlimited data sources including destinations, volumes, and sources using manual sync
Scheduled data flow: $200 per data flow with unlimited sources as well as destinations and volumes
Custom: Talk to sales team
250+ data source connectors
Support for major cloud data warehouses
No limits on destinations, sources, or volumes---even on free manual plan
Creation of new data connectors at no extra cost
Premium customer support on all plans
Portable comes with 250+ prebuilt connectors, more than twice as many as Matillion. All the connectors are available on all plans.
Portable develops and maintains brand new long-tail connectors upon request, at no extra charge.
Portable provides top-quality support for all customers without extra fees or add-ons required.
More than 250 connectors, designed around the long-tail sources Matillion and other tools tend to ignore
Pricing per data flow is transparent and simple to forecast from month to month
Full-featured free plan lets you experiment with and use all connectors free of charge, with no caps on volume or number of data sources
Bespoke connectors built and maintained for free
Portable focuses on long-tail connectors and doesn't support common data sources like Salesforce or QuickBooks
Doesn't support databases as sources
Only available in the U.S.
Portable is ideal for businesses who need less-common connectors, but don't have the ability (or desire) to code and maintain those connectors on their own.
CData is a set of data tools designed for universal connectivity. Like Matillion, CData is a data integration platform that can handle several features with a broad suite of tools for ELT, ETL, visualization, data connectivity, and more.
Standard: $49/month (one data source)
Professional: $99/month (limited to five data sources)
Enterprise: $199/month (limited to 10 data sources; custom pricing for more than 10 sources)
250+ connectors (CData calls these "drivers")
CData suite of software tools including Arc, Sync, and Connect Cloud
Speed optimized for data sources
Access for NoSQL data types as if they were SQL
Support for all kinds of workflows including ETL, ELT, and Reverse ETL
Both cloud-based SaaS product and on-premises deployments available
CData provides more than 250 data connectors (drivers) built-in.
If you want access to a data source not supported natively by CData, you can use the CData Universal API Driver to create a new connector.
CData provides email support on all plans and offers additional levels of support for customers on higher tiers.
Simple per-source pricing for data extraction
Built-in connectors for a wide array of well-known data sources
Like Matillion, an all-in-one suite of tools that can handle most types of data ingestion workflows
Option for on-premise data platform deployment
Using an entire suite instead of a stack of individual tools can make it harder to determine pricing
Reviewers have said that documentation can be difficult to understand and use
All-in-one platform can mean it's more challenging to integrate third-party tools
Limited support for custom fields
CData is a great fit for teams looking for an all-in-one platform for managing an entire data pipeline.
Hevo is a cloud data integration tool that comes with built-in transformation capabilities. It's a no-code platform and supports ETL, ELT, and reverse ETL workflows.
Free: One million events (limited to 50+ data connectors)
Starter: Starts at $239/month
Business: Custom quote
For Reverse ETL workflows, businesses will need to use Hevo Activate:
Free: Access to 4 data warehouses and 3 SaaS targets
Starter: $199/month (limited to 4 data warehouses and 4 SaaS targets)
Business: Contact sales
Flexible pricing
150+ data connectors (free plan is limited to 50+ connectors)
Real-time data migration capabilities
Built-in data transformations through Python
Live, round-the-clock support
The free Hevo plan includes 50+ data connectors. Paid plans include 150+.
You can design an individual connector using Hevo's REST API. You can also connect to long-tail data sources through its Webhooks API.
Hevo offers 24/7 customer support on all plan types. Starter plans include live chat support, while Business users have access to a dedicated account manager.
Support for all workflows, including ETL, ELT, and Reverse ETL pipelines
No-code platform doesn't require programming expertise
Generous free plan for businesses that use well-known data sources and only need up to a million events
Limited support for long-tail connectors, especially on the free plan
Pricing based on usage can be challenging to forecast month-to-month
Transfers between tools can require manual mapping
Hevo is the best Matillion alternative for teams that use common data sources and need a no-code platform.
Rivery is a SaaS ELT big data orchestration platform that offers both a no-code and code option. You can build Rivery ELT scripts, called "rivers," using a GUI or with Python.
Starter: $0.75 per credit
Professional: $1.20 per credit
Enterprise: Custom pricing
One credit equals 1 API pipeline execution, 100 MB of data replication, or one logic or transformation execution
14-day free trial
200+ data sources
15+ supported data management destinations
24/7 customer support
Full support for ELT, Reverse ELT, and transformations
Self-service starter kits with common data connections and transformations already set up
Rivery currently has over 200 connectors that are pre-built and available to use on any plan.
You can create a new data sources with the Rivery Custom API. The Rivery team can also design custom data connectors upon request.
Rivery is well-known in the business for its customer support, scoring 9.8 at G2 (compared to an industry average of 8.5). The level of support depends on your plan.
Comprehensive API support for development teams
Starter kits and a no-code GUI makes it simple to create new data pipelines without technical knowledge
Recognized for its excellent customer service
Pricing based on credits is complicated and can be difficult to estimate ahead of time
GUI can become too cumbersome for complex connections and data sets
Error messages are often ambiguous and can make it difficult to determine (and fix) the issue
Rivery is ideal for teams that are looking for a no-code option that's fast to set up.
Fivetran is one of the most established ETL and business intelligence tools. Fivetran focuses on larger enterprises.
Standard Select: Est. $60/month (limited to one user and 500k active monthly rows)
Starter: Est. $120/month (limited to 10 users)
Standard: Est. $180/month
Enterprise: Est. $240/month
Business Critical: Contact sales
A 14-day free trial is available
160+ data connectors
Robust support for the largest and most well-known enterprise applications
Native warehouse transformation that's especially efficient with complex data models
Replication using change data capture
Fivetran provides more than 160 data source connectors.
You can request custom data connectors through the Fivetran website, but the development time is slow. You can also design your own connectors, but you won't be able to access the Fivetran REST API unless using the Standard Select plan or higher.
Fivetran provides 24/7 support on all its plans. The more expensive plans have SLAs available.
One of the most reliable data integration platforms, trusted by some of the biggest players across industries
Integrations with the biggest corporate sources and destinations
Near-real-time or real-time data sync
More expensive than other Matillion alternatives
Complex pricing model that can vary month to month and be hard to predict
There isn't a lot of support of long-tail connectors for data and there's a slim chance they'll be developed by the company itself
Fivetran does not support ETL workloads, which means that companies using ETL will require an alternative tool
Businesses that make use of the most widely-available data sources and have more resources for an enterprise-level data integration tool.
Segment is an ETL platform for customer data. This emphasis gives Segment a number of unique characteristics, including merging personas and segmentation based on the customer journey.
Free: 1,000 visitors per month and two data sources
Team: $120/month for up to 10,000 monthly users
Business: Custom pricing
300+ data sources
Tools for managing data and debugging
User profiles, customer segments, and pixel embedding
Export functionality to CRM and marketing tools and platforms
Segment offers 300+ connectors that are included in all plans.
Segment comes with a built-in Functions tool to develop custom connectors. Your team is responsible for the development and maintenance of these connectors.
Each plan comes with Standard support. Segment provides additional levels of support that you can add on for a fee.
Simple and easy-to-use user interface
Integrated tool to connect with and load data from new sources
Unique features for segmenting customers which aren't found with other platforms like Matillion
Pricing based on the number of visitors could be costly and could charge for anonymous users several times
Some connectors can't use the full range of API data, which means you'll have to modify existing connectors to import all available data
The focus is primarily on marketing and sales, and not as applicable for other use cases
Segment is a great choice for data teams that handle customer and marketing data.
Precog is a cloud-based ETL tool that takes a different method of operation. In lieu of manual connectors, Precog uses an artificial intelligence engine to extract new data sources.
Pricing is customized based on the number of data sources.
10,000+ data sources available out of the box
100+ supported destinations
Available as cloud SaaS product and on-premise
No-code platform that's very scalable for new data sources
Precog provides 10,000+ connectors, far more than any other Matillion alternative. These aren't coded by hand, but created with Precog's AI engine.
You can create new connectors using Precog's AI engine. You can also request custom connectors and the Precog team will deliver them in under 48 hours.
Precog provides customer support according to the plan you select.
More connectors, thousands more than Matillion or other competitors
Transparent pricing based on data sources
Unique, no-code data integration platform that uses AI
Both SaaS and on-premise deployments available
Newcomer to the ELT area with relatively small user community
No-code, automated connectors can feel restricting for technical team members
Pricing can be expensive for teams that need several connectors
Precog is ideal for teams that require long-tail data connectors and prefer a no-code environment.
Airbyte is an open-source ELT platform. Airbyte includes a free plan for self-hosting as well as a paid SaaS plan.
Open source: Free, as you'll be hosting the software yourself
Cloud: $2.50/credit (one million rows equal 6 credits; 1 GB equals 4 credits)
Cloud high volume: Custom pricing for users who need more than 5,000 credits
170+ connectors for data sources (not all of them available on the cloud service)
Open-source solution
Change data capture support for databases
Supports data warehouses and data lakes as destinations
Pricing based on credits, or the option to host the software for free
Native warehouse data transformations
Airbyte currently has more than 170 connectors on its open source platform. Some of them are not accessible on the latest cloud service, but all will likely be added soon.
You can request custom connectors on the Airbyte website, but the selection process is unclear. You can also create and maintain new connectors yourself using the Airbyte CDK.
Even though it's relatively new, Airbyte has a robust community of more than 12,000 users. Paid plans also come with in-app chat support with a one-hour response time.
Open-source platform with a large user community
Engineer-centric platform that includes a CDK to accelerate development
Support for 20 destinations, more than many competitors
You'll have to design your long-tail connections and keep them up-to-date on your own using the Airbyte CDK
Credit-based pricing models are difficult to predict
The Airbyte cloud service is missing a variety of well-known data sources and destinations (e.g., WordPress, Google Analytics 4, Apache Kafka)
Engineering teams that are ready and able to design and maintain connectors using Airbyte's CDK.
Meltano is among the latest newcomers into the ELT world, after it spun out of GitLab in 2021. Meltano is an open-source platform that integrates with the Singer protocol.
As of this writing, Meltano does not offer paid plans. However, a cloud-based SaaS solution is in development with a launch date set in 2023.
300+ data sources
Native integration using Singer data integration format
SDK for fast development of custom connectors
Integrated testing and version control
Engineer-first focus in design and interface
Meltano connects to 300+ data sources.
Meltano's CDK is compatible with Singer to build your own connectors. You can also use the open-source Singer protocol and any connectors created by the community.
Meltano has a small but growing community. Meltano might provide paid support in the near future when it launches its cloud service.
Open-source, free platform
Features such as Git version control, separate staging and dev environments, and end-to-end CI testing are integrated natively
Integration with Singer makes it simpler to create flexible connectors
Meltano is specifically designed by engineers and doesn't provide a no-code or low-code option
There is there isn't a managed SaaS plan available currently
Smaller user base and no official support
Singer-based connectors can fail without warning without additional support from Meltano
Meltano is best for teams of data engineers with a high degree of technical proficiency.
Stitch is an ETL tool that focuses on business intelligence. Stitch has built-in data transformations that work with a variety of native tools.
Standard: Starts at $100/month (limited to five million active monthly rows, one destination, and 10 sources)
Advanced: $1250/month (limited to 100 million rows and three destinations)
Premium: $2500/month (limited to one billion rows and five destinations)
14-day free trial
More than 130 data sources
Automation tools such as monitoring and alerts
Support for the most well-known data lakes and data warehouses
Built-in capabilities for transformation using a UI, Java, SQL, or Python
Stitch has 130+ data sources. Certain connectors are only accessible on the higher-tiered plans.
Stitch integrates with Singer, which makes it easier to create new connectors. However, your team will be responsible for the development and ongoing maintenance.
Stitch provides basic support via chat and email for all customers during business hours. Customers with more expensive plans may qualify for phone support and a dedicated representative.
Robust transformations with a variety of built-in tools
Integration with Talend suite of data tools
Cost-effective solution that will meet the requirements of most small and medium businesses
Support for data lakes and warehouses as destinations
Row-based pricing model can be costly and is difficult to predict
Customer support is limited on the most basic plans
Singer connectors aren't maintained by Stitch and can break unexpectedly
Stitch is made for teams who plan to make use of commonly used data sources, or that are comfortable with the creation and maintenance of new connectors for Singer.
Matillion is a popular ELT tool that markets itself as an ETL tool. It's an all-in-one platform with robust GUI-based data transformation features and the option to deploy on-premise instead of only in the cloud.
But before choosing Matillion, there are several downsides to consider.
It has one of the smallest libraries of data source connectors in the industry, at just 110+.
It has an opaque pricing structure that can be hard to predict. And you can expect vendor lock-in once you switch to Matillion, since it doesn't work as well with third-party solutions.
There are other ETL/ELT tools out there with the same features but without the disadvantages.