Matillion Review
Updated May 24, 2019

Matillion Review

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

Overall Satisfaction with Matillion

We use it to transport data to our data warehouse.
  • Reading from multiple databases.
  • Writing to a data warehouse.
  • Performing data transformations.
  • Reading from other kinds of data storage in addition to relational databases.
  • Interface for API profile builder could be more user-friendly, especially for new users.
  • Could use better documentation & examples for API Profiles syntax.
  • No built-in version-control management.
  • No way to add integration tests for jobs for QA purposes.
  • If you have a lot of jobs currently running at the same time, then you cannot easily manage them, and they're relegated to the "Jobs" panel in the lower-right corner. It would be nicer to have an interface that allowed you to manage a large amount of currently running jobs (sortable columns, inline searching/filtering for currently running jobs, etc.). Maybe even have a larger view than just 25% of the window.
  • Difficult to track/identify changes made by collaborators (having a VCS/Git integration would improve this).
  • Flowchart-style UI makes building jobs relatively easy.
  • Allows you to see the task history and inspect which jobs are taking a long time.
  • Drag-and-drop flowchart-style UI makes building jobs relatively easy.
  • Inline documentation for each component is useful.
  • Waiting for an active job to finish running before revalidating & applying parameter updates can be a bit frustrating sometimes, especially for long-running jobs.
We were able to get up and running with Matillion within a few months, on and off, while also working on other things, as well as deprecating our old ETL solution.
Matillion can only run 8 jobs concurrently. Sometimes I want to be able to run more jobs at the same time, especially when they are targeted to different environments.
Matillion is good for reading and transforming data to a data warehouse, and has a variety of transformation commands. The flowchart UI makes most workflow composition relatively easy.
One thing to note is that it lacks any built-in version-control management, so you can't really save the state of your Matillion instance configuration very easily in your version control system (e.g. using Git).

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools
Not Rated