Item: Matillion
Rating: 8
Author: Verified User

Overall Satisfaction with Matillion

Use Cases and Deployment Scope

We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.

Pros and Cons

Pros

Components available to do work with any source
Ability to connect to sources without preconfigured component with extensability
Able to kick off jobs from SNS, SQS

Cons

There are so many options that the learning curve could be long for a newbie
Can only parallelize the load in 16 partitions so it can't make use of parallelism of Redshift
Menu items for admins may not always work and would have to resort to shell scripting (offered)

Return on Investment

Allows quick development and deployment

Usability

Matillion makes it easy for novices to quickly perform data movement and create transformations.

Time to Value

Within 2 days

Scalability

We have a 24 node Redshift cluster but COPY can utilize only 16 multi-part upload due to Matillion which is annoying.

Alternatives Considered

Informatica Cloud

Matillion is purely cloud solution versus Informatica Cloud still requires PowerCenter to do any serious transformation work.

Other Software Used

Looker, Amazon Redshift, GitHub

Likelihood to Recommend

ETL development can happen without much programming using graphical ETL dev tools and Matillion makes it simple. If data movement is what your organization needs then Matillion is your tool. If you need heavy programming for most performant or reusability then Matillion is not very useful.

Matillion Feature Ratings

Comments

Please log in to join the conversation

ETL made easy for non-programmers