Item: Matillion
Rating: 6
Author: Verified User

Use Cases and Deployment Scope

It was a self-hosted SaaS ETL for us for all data warehousing, connecting all internal and external data sources.

Pros and Cons

Easy to learn
Visual interface
Pretty reliable

Version control
Search
Explaining dependencies

Return on Investment

Short time to market
Useful with limited resources
Transparent pricing

Usability

In the scope of a sole user, it's a very powerful tool.

Time to Value

One can get a production ETL job up and running in hours starting from scratch.

Scalability

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.

Alternatives Considered

I used Airflow, AWS Data Pipeline, mETL, and night-shift. Airflow and AWS Data Pipeline is simply horrible. mETL is still better, but the GUI is not that easy.

Other Software Used

Amazon Redshift, Chartio, Kubernetes

Likelihood to Recommend

For a sole person data team, it's a good price-to-value investment. Good learning curve, fast results.

A good solution for a one man data shop

Overall Satisfaction with Matillion