This is your compare tray

Apps you want to compare will be listed here. Launch a head to head comparison at any time.

Matillion

Extract, transform, load platform for cloud data warehouses

visit website

Matillion Pricing, Features, Reviews and Alternatives

Matillion product overview

Price starts from

$

2

Usage Based

What is Matillion?

Matillion is an extract, transform, load (ETL) solution for cloud data warehouses including Amazon Redshift, Snowflake and Google BigQuery. It enables users to gather data from various sources and deliver them in structured and semi-structured frameworks using platform's data transformation capabilities. The search functionality lets enterprises find specific results across notes, jobs, and components within projects through term-based searches.

Typical customers

Freelancers
Small businesses
Mid size businesses
Large enterprises

Platforms supported

Web
Android
iPhone/iPad

Support options

24/7 (Live rep)
Email/Help Desk
Phone Support
FAQs/Forum

Training options

Documentation
Webinars
Live Online
Videos

Matillion pricing information

Value for money

4.1

/5

106

Price starts from

$

2

Usage Based

Pricing options

Free plan
Subscription
Free trial
Pricing range

Value for money contenders

Matillion features

Functionality

4.1

/5

106
Total Features39 7 categories

Most valued features by users

API
Third Party Integrations
Access Controls/Permissions
Collaboration Tools
Activity Dashboard
Data Import/Export
Search/Filter
Data Connectors

Functionality contenders

Matillion users reviews

Overall rating

4.3

/5

106

Positive reviews

91%

Write a review
Rating breakdown
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8.32/10
Rating distribution

5

4

3

2

1

43

53

8

2

0

Pros
Overall it is user-friendly, easy to develop & deploy, secure ELT for big data use cases. It supports a lot of already built useful connectors, which helps to reduce marketability cost and time.

AR

Anonymous Reviewer

The support team has been very responsive in resolving some Azure-related issues, tuning our instance, and helping to understand the nuances of how it works.

BR

Brian R.

Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it.

GL

Graham L.

Cons
When they eventually respond to messages it is with an unhelpful response. Generally they will blame us for issues on their end, or they misunderstand the problem completely.

EC

Ellis C.

There is no restart-from-point-of-failure option for failed loads. Everything has to start from scratch or remaining jobs need to be run manually.

DC

Despina C.

The pricing model is frustrating. You are billed for when the machine instance is ON, not when it is actively doing something.

MS

Michael S.

Overall rating contenders

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

The best ELT tool on the market

Reviewed 2 months ago

Matillion is the single most important piece of software I use on a day-to-day basis. Its' ability to blend a ton of out-of-the-box functionality with the ability to script custom components in Python to author our own integrations is invaluable. It has enabled us to build transformed data within our warehouse, use pre-authored integrations to pull data from vendors, write our own integrations to pull from vendors, and is the single tool we use along with Redshift to provide visibility to all of the data within our business. I am a huge fan of Matillion and have used it in 2 different orgs. It is one of the only software tools I will champion across any org I move to.

Pros

-Extremely easy deployment with cloud formation template. -Excellent pre-authored integrations that are easily extensible/customizable. -Easy to use UI to build complex transformations. -Extremely flexible logic with static and grid variables to intelligently execute jobs and branch as needed.

Cons

-No automated scheduling based on dependent table updates. (This is possible to set up, but not out of the box.) -Support SLAs have gotten worse over time.

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Easy to use solution, allowing rapid delivery of ELT processes

Reviewed 2 years ago

We came to Matillion while looking for a tool that would allow us to orchestrate our load processes for Amazon Redshift. We'd used other ETL tools previously, were blown away by how easy it was to pick up and understand Matillion. We liked the simplicity, and the fact that we could always dig into the SQL that was generated. New features are added frequently, and we usually find one or two improvements that directly impact us with each release. Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it. 2+ years later, and we're using Matillion to run all our ELT jobs across various data warehouse projects, and very happy with it.

Pros

- Very intuitive design environment - super quick to learn. - Components map closely to SQL capabilities in Redshift. - Easy to view the SQL generated. - Sample, row count, and data lineage make it easy to unit test as you build. - Powerful management options via REST API (orchestration, Github integration, etc.). - Native AWS integration. - Aggressive release cycle, constantly adding new features. - Easy to document in-workflow. - Lots of third party integrations.

Cons

- User concurrency/licencing model (simple, but can't be customised to fit your need). - Exception handling could be improved. - A single Task View would be helpful for multi-environment/project support.

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

A good tool for large-scale ETL into Cloud Data Warehouses

Reviewed 2 months ago

We're able to rapidly load large amounts of data into Snowflake and schedule any SQL tasks to run against snowflake.

Pros

Web-based, Runs in AWS so it can sit close to your data if you're using a cloud warehouse. You only have to pay per minute that you have the instance on which is a BIG plus.

Cons

Not nearly as many features and user-friendly data transformation tools as a competing software such as Alteryx has. As such, this tool is not as convenient or flexible for detailed data transformations. We mostly use it for bulk loading which it is very fast and good at.

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Responsive to User Needs

Reviewed 2 years ago

Gets better and better with each release. Keep up the good work!

Pros

I've been using Matillion for about 2 and a half years. I've seen the software improve so much in that time. If I ever found a feature to be lacking, it would be included within the next couple release cycles. The software really seems to adapt as user needs have been evolving. Some of my favorite recent features are the ability to configure some components with just text (really saves me time) and the many Grid orchestration components which allow me to greatly reduce the complexity of the orchestration jobs.

Cons

UX is sometimes lacking or inconsistent. For example, let's say my goal is to replace an existing job with a new job of the same name. I delete the old job, and import the new one with the same name. All Orchestration components that used that job will understand to use the new job, but for some reason the scheduler doesn't. Also, jobs will have validation errors simply because the components haven't been validated (grey borders). It can be confusing because you may be searching for an error in your work when all you actually have to do is revalidate the job.

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Just started using Matillion this week

Reviewed 2 months ago

Overall experience with Matillion has been great. The first call with [SENSITIVE CONTENT] set the tone of who and what Matillion can offer our company. [SENSITIVE CONTENT] was kind, not pushy, relatable, and truly tried to understand our use case. [SENSITIVE CONTENT] really sold us on proceeding with a demo after sharing some of the functionality of the MDL tool available for free in AWS marketplace....

Pros

Matillion is incredibly easy to deploy in AWS. In addition, the security and compliance aspects are all handled on the customer side due to the deployment method. The UI is easy to use and the price point was the most competitive.

Cons

We haven't used it enough to encounter negative aspects yet but having to pay for the full amount of time the VM is up is going to be cost prohibitive for our small team.

Matillion FAQs and common questions

Matillion has the following pricing plans:
Starting from: $2.00
Pricing model: Free
Free Trial: Available


Matillion has the following typical customers:
Large Enterprises, Mid Size Business, Small Business


Matillion supports the following languages:
English


Yes, Matillion has an API available for use.


Matillion integrates with the following applications:
Aurora, PayPal, Google Analytics, Dropbox Business, Amazon S3, Jira, NetSuite CRM+, Amazon DynamoDB, QuickBooks Online Advanced, Gmail, Zuora, Amplitude, NetSuite, Twitter, Stripe, SugarCRM, Google AdWords, Facebook, ServiceNow, Microsoft Dynamics 365 Business Central, Mixpanel, Mailchimp, Instagram, Marketo Engage, Xero, HubSpot CRM, Oracle Eloqua, Shopify, Zendesk, Microsoft Excel


Matillion offers the following support options:
24/7 (Live rep), Email/Help Desk, Phone Support, FAQs/Forum

Most popular Matillion comparisons

MatillionvsXplenty

Related categories