Matillion is fast, fairly flexible, and easy to use
August 14, 2020

Matillion is fast, fairly flexible, and easy to use

Avishua Stein | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

It's being used by our BI team, to ingest data into our Data Warehouse and distribute primarily to clients via Tableau, GSheets, emails, SFTP, etc. We also use it internally. Almost all our usage is for loading data although we use some transformation components when bringing in semi-structured data. Our team supports the entire organization.
  • Move large amounts of data quickly from various sources into Storage/Data Warehouse. This is important for any ETL tool.
  • The built-in API connectors are very useful and are usually granular enough to save us loads of development time.
  • Matillion usually responds to support tickets in a day or two.
  • A couple of times, we've had components stop working. We were basically told to keep checking the release notes for fixes. It would be nice if they prioritized maintaining existing components over developing new ones.
  • It can be hard for multiple users to work on the same job.
  • Most of their documentation is good, but sometimes their support pages link to missing docs.
  • Matillion has saved us a lot of development time when connecting to certain APIs--up to months between making requests and connecting to our Data Warehouse.
The GUI is simple and easy to work with. Components connect to each other and you have options for how to handle successes/failures. Managing schedules is easy in the GUI and doable in bulk through their API.
It has scaled well for our usage, but we have some worries about what will happen when we begin working with larger datasets (10TB for one table) each day.
Similar simple GUI but Matillion's is much cleaner, easier to manage and debug, and easier to connect to cloud databases. Matillion is also much faster.
Matillion is well suited for ingesting data from multiple sources, especially when the raw data is being stored in cloud storage. We have AWS Lambda connected to S3 and Matillion so triggering ingestion jobs when data is delivered is simple. Sending alerts for job failure or success to Slack/email is easy.

Matillion is probably less appropriate for scenarios where multiple people are going to be working on one job.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
Complex transformations
Not Rated
Business rules and workflow
Testing and debugging
Not Rated