Matillion - the swiss knife of ETL
September 01, 2020

Matillion - the swiss knife of ETL

Eduard Matei | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

We use Matillion as the main ingestion tool within the business intelligence department.
We use it to ingest data coming from different legacy systems, outputting data in the cloud datalake solution.
It's really easy to learn, configure and spend less time ingesting the data and more time getting insights from the data.
  • Python integration.
  • Easy to set up, back up and restore.
  • Scalable, works for any and all file types.
  • Python libraries.
  • Bigquery metadata.
  • Enables spending less time on ingesting data.
  • Quicker releases of feeds.
Regardless of one's needs, Matillion has different tools to address even the most complex issues that can occur in the ETL process.
It's easy to use and get along with, whether it is using the drag and drop of built components or creating your own from scratch.
It takes less than two hours for Matillion to be up and fully operational. If creating a backup instance, all code and settings can be downloaded as json files and then reuploaded in the new instance.
We have been using the same instance of Matillion from when there were about 20 jobs created. At the moment, we are creating about 10 new jobs per day, with a couple of hundred jobs running every day, with performance not being affected at all.
More robust than Talend, easier to start working with and allows less technical users to understand how a file is being processed.
Matillion can be designed to ingest a multitude of file types through an automatic process, allowing less technical users to create and control the end to end process of ETL.
API queries, python code, bash script processing, Matillion can be used to solve complex problems, creating an easy-to-follow process.

Matillion Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
Simple transformations
10
Complex transformations
8
Business rules and workflow
8
Collaboration
10
Testing and debugging
10