Straightforward, native ELT for cloud-based Data Warehouse solutions
April 18, 2019
Straightforward, native ELT for cloud-based Data Warehouse solutions
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Matillion is the primary ELT software used by our Data Engineering team to provide ELT orchestration for both our own and clients' AWS data platforms which are primarily built around Amazon Redshift.
Matillion allows us to rapidly develop and deploy ELT processes across our environments. With its native AWS support, it integrates seamlessly with the rest of our platform, enabling easy deployment, support, and monitoring of our Redshift workloads.
Matillion allows us to rapidly develop and deploy ELT processes across our environments. With its native AWS support, it integrates seamlessly with the rest of our platform, enabling easy deployment, support, and monitoring of our Redshift workloads.
- Very intuitive and easy to learn
- Native integration with AWS services
- Aggressive roadmap with continual enhancement
- Competitive pricing
- Push-down SQL - all transformations are native Redshift SQL, meaning fairly easy decoupling
- More granularity for security permissions
- Better orchestration of job scheduling/execution (e.g. setting maximum execution time, managing queued jobs)
- Low cost of Matillion has allowed us to power big workloads for a comparatively small outlay.
- Fast speed of development has allowed quick delivery.
We ran a brief proof of concept which was supported by Matillion themselves. We were able to get up and running within an hour, and due to the direct correlation between transformation tasks and Redshift commands, we were able to understand the components available and map out our workloads quickly.
We ran our PoC for a period of around a week and were able to begin developing real solutions almost immediately upon purchase of the license.
Being able to sample data and see data lineage as we build out jobs makes it incredibly simple to test as you go.
We ran our PoC for a period of around a week and were able to begin developing real solutions almost immediately upon purchase of the license.
Being able to sample data and see data lineage as we build out jobs makes it incredibly simple to test as you go.
Being a fairly new player in the market, Matillion is coming up against some well-established names such as Pentaho and Talend. The primary benefit for our use case was the fact that Matillion is built specifically for Amazon Redshift. While Pentaho and Talend are more mature products with some advantages (e.g. Talend's suite of data quality management tools, or Pentaho's customisation), neither are Redshift-specific products. While they support Redshift and AWS generally, they also have to cater for similar requirements across other database and platforms, which means they are not always doing things in the most optimal way for Redshift workloads or may take additional configuration.
Matillion's native AWS integration and direct mapping of features to Redshift functionality mean it squeezes every drop of performance possible out of Redshift and operates in the most optimal manner.
Think of it like performing surgery. While you could use a Swiss army knife because it supports that among other things, you might prefer to use a scalpel since it has been specifically designed to provide precision and performance for that specific job.
Matillion's native AWS integration and direct mapping of features to Redshift functionality mean it squeezes every drop of performance possible out of Redshift and operates in the most optimal manner.
Think of it like performing surgery. While you could use a Swiss army knife because it supports that among other things, you might prefer to use a scalpel since it has been specifically designed to provide precision and performance for that specific job.
Matillion Feature Ratings
Using Matillion
9 - In our organisation, the primary users of Matillion are our Data Engineering team. They are responsible for building our data pipelines and processing client data for our data warehouse.
In addition to our Data Engineers, our Cloud Services and Solution Architecture teams use Matillion to support with stack operation and proof of concept developments retrospectively.
In addition to our Data Engineers, our Cloud Services and Solution Architecture teams use Matillion to support with stack operation and proof of concept developments retrospectively.