Matillion

Extract, transform, load platform for cloud data warehouses

4,3 /5 (96 reviews) Write a Review!

Matillion Overview

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.

Key features of Matillion include data export/import, collaboration, audit logs, scripting, job scheduling, version control and task management. Businesses can use the automation tools to schedule multiple orchestration jobs against a project at predefined time intervals. Plus, it enables administrators to ensure data security by managing user access across Active/LDAP directories, SSL certificates and authentication to use information from the local directory.

Matillion facilitates integration with several third-party applications to aid with data management across cloud warehouses such as Facebook, MailChimp, Amazon RDS, Hubspot, Salesforce, Elasticsearch, Google Analytics, JIRA, Marketo, and more. It also comes with an application programming interface (API) query component, which allows users to integrate the platform with any JSON or XML-based API.

Matillion Overview

Pricing

Starting from
N/A

Pricing options

Free Trial
Subscription
Value for money

Pricing is available on an hourly basis, starting at $1.37. Matillion versions for Amazon Redshift and Snowflake also support annual billing. Contact Matillion for more information.


Matillion Features

Devices
Business size
S M L
Markets
United States, Canada, Australia, China, India and 4 others, Japan, Germany, Brazil, Mexico
Supported Languages
English

Media

Matillion ETL workflow screenshot
Matillion SQL editor screenshot
Matillion component failure screenshot
Matillion RDS query screenshot
Matillion documentation screenshot
Matillion video Matillion screenshot: Matillion ETL workflow screenshot Matillion screenshot: Matillion SQL editor screenshot Matillion screenshot: Matillion component failure screenshot Matillion screenshot: Matillion RDS query screenshot Matillion screenshot: Matillion documentation screenshot

Matillion Reviews

Matillion Reviews

Overall rating
4,3
/
5
Excellent
38

Very good
49

Average
8

Poor
1

Terrible
0

Value for Money
4,1
Features
4,1
Ease of Use
4,4
Customer Support
4,6
91% recommended this app
Verified Reviewer

Best and very much compatible ETL for Redshift


Graham L.

Easy to use solution, allowing rapid delivery of ELT processes

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.


Roger F.

Responsive to User Needs

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


Michael S.

Great for pipelining data to warehouse/lake, not getting it back

It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions.


Erick B.

Matillion Review

Matillion is a great out of the box product with minimal requirements. You spin the machine up, allow your database's firewall to communicate with Matillion. Start creating jobs, schedule them, and sit back. It helps you focus on visualizing your data.


Verified Reviewer
Industry: Health, Wellness & Fitness
Company size: 10 000+ Employees

Best and very much compatible ETL for Redshift

Used Daily for 2+ years
Reviewed on 2019/06/25
Review Source: Capterra

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"

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Graham L.
Industry: Marketing & Advertising
Company size: 51-200 Employees

Easy to use solution, allowing rapid delivery of ELT processes

Used Daily for 2+ years
Reviewed on 2019/06/14
Review Source: Capterra

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Roger F.
Industry: Marketing & Advertising
Company size: 51-200 Employees

Responsive to User Needs

Used Daily for 2+ years
Reviewed on 2019/06/13
Review Source: Capterra

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.

Rating breakdown

Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Michael S.
Industry: Higher Education
Company size: 501-1 000 Employees

Great for pipelining data to warehouse/lake, not getting it back

Used Other for 6-12 months
Reviewed on 2019/06/13
Review Source: Capterra

It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions.

Pros

It is extremely fast and easy to pull data from various sources and pipe it into Snowflake. The graphic interface lets this happen without programming.

Cons

There is almost no ability to get data back from your warehouse into the other systems to synchronize the data. It's great to have it all in the warehouse, but it seems pretty critical to have that data flowing back to other systems that are part of your environment.

The pricing model is frustrating. You are billed for when the machine instance is ON, not when it is actively doing something. So, if you have a couple hours of job that run in a day, you have to shut down the machine to save money the rest of the day. With it shut down, development can't happen. So, we had to turn it on and off all the time. It would be much better if they billed as it is used, not as it is on.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 6.0/10

Erick B.
Industry: Automotive
Company size: 51-200 Employees

Matillion Review

Used Daily for 1-5 months
Reviewed on 2019/06/14
Review Source: Capterra

Matillion is a great out of the box product with minimal requirements. You spin the machine up, allow your database's firewall to communicate with Matillion. Start creating jobs, schedule them, and sit back. It helps you focus on visualizing your data.

Pros

It is a pay for what you use type of software. Most other ETL platforms are a flat monthly fee, sometimes at crazy prices. The pay for what you use model makes it easy to justify cost to leadership. You can schedule jobs to make sure you maximize your time.

Cons

The user experience feels a little dated. Some things could be better displayed/ explained.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 8.0/10

User recommendation
8,3/10
Based on 96 user ratings
Compare user recommendation rating with alternatives
Compare with alternatives

Matillion Pricing

Matillion Pricing

Starting from
N/A
Free Trial
Subscription
Value for money

Pricing is available on an hourly basis, starting at $1.37. Matillion versions for Amazon Redshift and Snowflake also support annual billing. Contact Matillion for more information.

Pricing is available on an hourly basis, starting at $1.37. Matillion versions for Amazon Redshift and Snowflake also support annual billing. Contact Matillion for more information.

Value for Money
4,1/5
Based on 96 user ratings
Compare value for money rating with alternatives
Compare with alternatives

Matillion Features

Matillion Features

API
Access Control
Activity Dashboard
Analytics
Applications Management
Automatic Notifications
Collaboration Tools
Commenting
Custom Development
Customizable Branding
Customizable Templates
Data Import/Export
Drag & Drop Interface
Real Time Notifications
Reporting & Statistics
Role-Based Permissions
Search Functionality
Software Testing Management
Third Party Integration
Workflow Management
Features
4,1/5
Based on 96 user ratings
Compare features rating with alternatives
Compare with alternatives

Categories

Additional information for Matillion

Additional information for Matillion

Key features of Matillion

  • Data Analysis
  • Data Filtering
  • Job Scheduling
  • Metadata Management
  • Version Control

Matillion FAQs

Matillion FAQs

Below are some frequently asked questions for Matillion.

Q. What type of pricing plans does Matillion offer?

Matillion offers the following pricing plans:

Pricing model: Subscription

Free Trial: Available

Pricing is available on an hourly basis, starting at $1.37. Matillion versions for Amazon Redshift and Snowflake also support annual billing. Contact Matillion for more information.

Q. What are the main features of Matillion?

Matillion offers the following features:

  • Data Analysis
  • Data Filtering
  • Job Scheduling
  • Metadata Management
  • Version Control

Q. Who are the typical users of Matillion?

Matillion has the following typical customers:

Small Business, Large Enterprises, Mid Size Business

Q. What languages does Matillion support?

Matillion supports the following languages:

English

Q. What type of pricing plans does Matillion offer?

Matillion has the following pricing plans:

Subscription

Q. Does Matillion support mobile devices?

We do not have any information about what devices Matillion supports

Q. What other apps does Matillion integrate with?

Matillion integrates with the following applications:

Jira, Mailchimp, Marketo Engage, NetSuite, ServiceNow, Sigma, SugarCRM, Twitter, Xero, Zendesk

Q. What level of support does Matillion offer?

Matillion offers the following support options:

Phone Support, Online Support, Video Tutorials