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, Am...


Read More

Supported Operating System(s):

Web browser (OS agnostic)

95 Reviews of Matillion

Average User Ratings

Overall

4.28 / 5 stars

Ease-of-use

4.5

Value for money

4.0

Customer support

4.5

Functionality

4.0

Ratings Snapshot

5 stars

(37)

37

4 stars

(49)

49

3 stars

(8)

8

2 stars

(1)

1

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 95 results

June 2019

Anonymous

Verified Reviewer

Company Size: 11-50 employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

4.0

June 2019

Agile Data Engineering

We use Matillion to produce highly curated datasets for customers. Matillion has allowed us to move this workload entirely into the data warehouse where the final work product lives, and cut processing time from days to hours.

Pros

Matillion allowed us to move a legacy ETL pipeline to BigQuery with speed, precision, and confidence. It is now used exclusively by our team for all of our ELT needs. The user interface is clean, intuitive, and allows members of the team to be immediately productive. Onboarding new users has never been easier.

Cons

Feature parity between the different flavors (Redshift, Snowflake, BigQuery) is lacking, however, Matillion continues to make progress in narrowing the gap.

June 2019

Graham from Indicia

Company Size: 51-200 employees

Industry: Marketing and Advertising

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

5.0

Functionality

5.0

June 2019

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.

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.

Reasons for Choosing Matillion

Simplicity, and the fact that Matillion was built specifically for Redshift, meant it was ideal for our needs.

June 2019

Roger from Pepperjam

Company Size: 51-200 employees

Industry: Marketing and Advertising

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Customer support

5.0

Functionality

5.0

June 2019

Responsive to User Needs

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.

June 2019

Michael from Hamilton College

Company Size: 501-1,000 employees

Industry: Higher Education

Time Used: Less than 12 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

2.0

Customer support

5.0

Functionality

2.0

June 2019

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.

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.

Reasons for Choosing Matillion

Matillion was written for Snowflake, which is our preferred solution over MS SQL Server.

June 2019

Erick from Frazer

Company Size: 51-200 employees

Industry: Automotive

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

June 2019

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.

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.

Reasons for Choosing Matillion

The simple price model, out of the box features, and direct load to Big Query made the decision for our ETL. Others offered similar feature but at extremely steep prices. Although they might have looked better visually the functionalities were there, but the pricing was not.