1 million+ businesses helped. Get advice
Get Free Advice
Home

/

ETL Software

/

Matillion

Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee.

Matillion 2026: Benefits, Features & Pricing

Wondering if Matillion is right for your organization?

Our ETL Software selection experts can help you in 15 minutes or less.

On this page
  • Overview
  • Pricing and Plans
  • Features
  • Integrations
  • User Reviews

Overview

Matillion
Matillion
4.3
(111)

Pricing

Pricing available upon request

About Matillion

Matillion is an extract, transform, load (ETL) solution for cloud data warehouses such as Amazon Redshift, Google BigQuery and Snowflake. The centralized platform enables users to automatically schedule orchestration jobs and projects at regular pre-defined time intervals.

Key features of Matillion include live collaboration, versioning, auditing, data import/export and task management. It allows businesses to add/remove users from the local directory and grant role-based access across Active/LDAP directories or SSL certificates. Additionally, users can sort through multiple projects and notes to find specific results using the search functionality.

Matillion facilitates integration with various third-party applications such as MailChimp, Amazon RDS, Hubspot, Salesforce, Elasticsearch and more. Pricing is available on an hourly basis and on annual subscriptions. Support is extended via phone and other online measures.

Matillion Screenshots

0
0
1
2
3
4

Matillion Pricing and Plans

Starting price: $2.00
Free Trial
Free Version

Basic

$2.00

usage based

No plan information available

    Advisor Get Price CTA Image

    Confused about pricing? We've got you covered.

    Get a personalized pricing breakdown tailored to your specific needs—no guesswork, no generic estimates.

    Matillion Features

    • Popular features found in ETL
      Data Analysis Tools
      Data Extraction
      Data Quality Control
      Integration Management
      Job Scheduling
      Match & Merge
      Metadata Management
      Search/Filter
    • More features of Matillion
      Access Controls/Permissions
      Activity Dashboard
      Ad hoc Analysis
      Alerts/Escalation
      API
      Audit Management
      Audit Trail
      Automated Scheduling
      Collaboration Tools
      Data Aggregation and Publishing
      Database Support
      Data Blending
      Data Capture and Transfer
      Data Cleansing
      Data Connectors
      Data Discovery
      Data Import/Export
      Data Integration
      Data Management
      Data Migration
      Data Security
      Data Storage Management
      Data Synchronization
      Data Transformation
      Data Warehouse
      Data Warehousing
      Document Extraction
      Document Management
      Drag & Drop
      Email Address Extraction
      ETL
      Forecasting
      High Volume Processing
      IP Address Extraction
      Monitoring
      Multiple Data Sources
      No-Code
      Non-Relational Transformations
      Phone Number Extraction
      Pipeline Management
      Predictive Analytics
      Pricing Extraction
      Real-Time Analytics
      Real-Time Data
      Reporting/Analytics
      Reporting & Statistics
      Role-Based Permissions
      SSL Security
      Statistical Analysis
      Task Scheduling
      Third-Party Integrations
      Trend Analysis
      Version Control
      Visualization
      Web Data Extraction
      What-if Analysis

    Matillion Integrations

    Google Analytics 360
    Google Analytics 360
    QuickBooks Online Advanced
    QuickBooks Online Advanced
    Marketo Engage
    Marketo Engage
    Mixpanel
    Mixpanel
    Jira
    Jira
    SugarCRM
    SugarCRM

    See all 28 integrations

    Matillion User Reviews

    Overall Rating

    4.3

    Ratings Breakdown

    5

    41%

    4

    50%

    3

    8%

    2

    2%

    1

    0%

    Secondary Ratings

    Ease of Use

    4.4

    Value for money

    4.1

    Customer support

    4.5

    Functionality

    4.1

    Ravi's profile

    Ravi V.

    Verified reviewer

    Information Technology and Services

    51-200 employees

    Used daily for less than 12 months

    Review source

    Reviewed August 2021

    Very productive toolset

    5

    We are using it to do the extract load and transfer for our data warehouse

    Ratings Breakdown

    5
    Ease of use
    5
    Value for money
    5
    Customer support
    5
    Functionality
    icon
    Pros:
    - Quick to start - Consumption based model - Works well with Snowflake
    Cons:
    - Harder to find resources with skills - Cost relatively higher

    Reasons for choosing Matillion

    Feature set, cloud first approach and consumption based model

    Read More

    VR

    Verified
    Reviewer

    Media Production

    1001-5000 employees

    Used daily for less than 12 months

    Review source

    Reviewed June 2019

    Matillion Review

    4

    We're using Matillion for all the ETL in our environement: 3000 employees, around 500 BI users, around 30 different systems that we connected to. We were able to switch some existing jobs from Talend and create a whole lot more in just 6 minutes.

    Ratings Breakdown

    5
    Ease of use
    4
    Value for money
    5
    Customer support
    4
    Functionality
    icon
    Pros:
    + Fast & easy to use + Completely embedded into AWS environement + Comes light, it's not overloaded with stuff no one uses + Some really innovative features
    Cons:
    - Sometimes feels like not "fully under control", e.g. when a component runs into an OutOfMemory, the whole environement crashes. And there are different ways to trigger that... - Scheduling overview could be more sophisticated, it's kind of hard to have a proper overview there - Variable handling seems sometimes to be a bit difficult, e.g. when setting it in one process, it's not always set in sub-jobs - In some cases, one can see that Matillion is still "under development": Same features are available in some components, but are missing in others

    Read More

    RF

    Roger F.

    Verified reviewer

    Marketing and Advertising

    51-200 employees

    Used daily for more than 2 years

    Review source

    Reviewed June 2019

    Responsive to User Needs

    3

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

    Ratings Breakdown

    3
    Ease of use
    5
    Customer support
    5
    Functionality
    icon
    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.

    Read More

    VR

    Verified
    Reviewer

    Health, Wellness and Fitness

    10000+ employees

    Used daily for more than 2 years

    Review source

    Reviewed June 2019

    Best and very much compatible ETL for Redshift

    5

    Ratings Breakdown

    5
    Ease of use
    4
    Value for money
    4
    Customer support
    5
    Functionality
    icon
    Pros:
    1.)All the components and transfomrations availability 2.)Specially oriented for data ingestion process using all aws services like rds, s3, sns, redshift 3.)easy admin, ssl setup 4.)very easy diagromatical representation of jobs
    Cons:
    the latest button change for "switch version"

    Read More

    VR

    Verified
    Reviewer

    Online Media

    201-500 employees

    Used daily for more than 2 years

    Review source

    Reviewed June 2019

    First class ETL for everyone

    4

    We've been able to concentrate all data sources in one place and do a proper transformation and normalization of data to feed the Visualization layer.

    Ratings Breakdown

    4
    Ease of use
    4
    Value for money
    5
    Customer support
    4
    Functionality
    icon
    Pros:
    Easy to use for non-tech (engineers) users.
    Cons:
    Lacks testing stage before production and more flexibility to sample data.

    Read More

    VR

    Verified
    Reviewer

    E-Learning

    501-1000 employees

    Used daily for less than 12 months

    Review source

    Reviewed June 2019

    Matillion Review

    4

    Ratings Breakdown

    5
    Ease of use
    3
    Value for money
    3
    Customer support
    3
    Functionality
    icon
    Pros:
    Matillion is very easy to use. It's simplicity allows you to drag an drop components to easily create orchestrations. It also simple to create shared jobs and use the components.
    Cons:
    Although there is a decent set of components, they are not very versatile, hence I end up using a SQL script instead. For example, the S3 unload component does not allow one to specify some criteria and some fields are mandatory whereas I would not have to specify such specific criteria when doing this from an SQL script.

    Read More

    VR

    Verified
    Reviewer

    Computer Software

    201-500 employees

    Used daily for more than 2 years

    Review source

    Reviewed June 2019

    Is Great

    4

    Overall extract and load data strategies is very powerfull

    Ratings Breakdown

    4
    Ease of use
    3
    Value for money
    2
    Customer support
    3
    Functionality
    icon
    Pros:
    Is easy and is real pay as you use, that is very important for latinoamerica business
    Cons:
    That you can't write in other destinations

    Reasons for choosing Matillion

    easy

    Reasons for switching to Matillion

    is cheaper

    Read More

    VR

    Verified
    Reviewer

    Computer Software

    1001-5000 employees

    Used daily for less than 2 years

    Review source

    Reviewed June 2019

    A good solution for a one man data shop

    4

    In the scope of a sole user, it's a very powerful tool. One can get a production ETL job up and running in hours starting from scratch. After a while, it's pretty hard to figure what is where and if more than one user contributes to the flows it can be painful to understand changes.

    Ratings Breakdown

    4
    Ease of use
    4
    Value for money
    4
    Functionality
    icon
    Pros:
    Easy to learn Visual interface Pretty reliable
    Cons:
    Version control Search Explaining dependencies

    Read More

    Raul's profile

    Raul G.

    Verified reviewer

    Information Technology and Services

    201-500 employees

    Used daily for less than 2 years

    Review source

    Reviewed June 2019

    Great tool and experience

    4

    Great tool

    Ratings Breakdown

    5
    Ease of use
    4
    Functionality
    icon
    Pros:
    Easy to use, graphical way to do data flows on Google Cloud
    Cons:
    The most missing functionality, is to be able to setup data destinations additionally to BigQuery

    Read More

    Jose Mari's profile

    Jose Mari T.

    Verified reviewer

    Oil & Energy

    201-500 employees

    Used daily for less than 12 months

    Review source

    Reviewed July 2019

    Good

    5

    Overall Matillion is good and I'm sure it could be better.

    Ratings Breakdown

    4
    Ease of use
    4
    Value for money
    3
    Customer support
    4
    Functionality
    icon
    Pros:
    I like the stability of the product. We haven't updated our version since we started.
    Cons:
    Can't use simple SQL Functions like CURRENT_DATE in FIlter Component. And no Automatic Update.

    Read More

    Showing 1 - 10 of 111 Reviews

    Other Top Recommended ETL Software

    Funnel
    Funnel

    4.7 (19)

    Recently recommended 5 times

    Domo
    Domo

    4.3 (329)

    Recently recommended 0 times

    Boomi
    Boomi

    4.4 (273)

    Recently recommended 0 times

    ClicData
    ClicData

    4.6 (145)

    Recently recommended 0 times

    Advisor Get Price CTA Image

    Stuck Between Options?

    Our experts can help you compare Matillion with other top options, so you can find the best fit for your needs.

    See what companies are saying about Software Advice