Matillion a great, easy to implement resource
Updated September 02, 2022

Matillion a great, easy to implement resource

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

Overall Satisfaction with Matillion

We use Matillion for all our redshift data warehouse ETL needs.
  • Run stored procedures on AWS Postgres RDS instances
  • Sync data from diverse data sources including production databases and APIs to Redshift data warehouse
  • Version updates often are not backward compatible. As a result updating to a new version requires a huge LOE.

Do you think Matillion delivers good value for the price?

Yes

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

Yes

Did implementation of Matillion go as expected?

Yes

Would you buy Matillion again?

Yes

  • Reduced our nightly ETL pipeline time by 50%
Matillion overall is easy to use. Sometimes the documentation is slightly lacking, and mass delta updates are not as easy as we would prefer.
Matillion was up and running almost overnight. Our ops department spun up in an instance and we were off to the races.
Matillion has scaled well with our organization's growing needs and has easily handled very large ETL orchestrations.
Matillion is much easier to implement and maintain. As a result, we use Matillion for 95% of our data pipelines and only use Apache Airflow when necessary.
As a drag and drop ETL solution, Matillion is efficient, easy to use, and reliable. It is well suited to ETL data into a data warehouse. It is less appropriate for running maintenance on other data sources.

Matillion Feature Ratings

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

Evaluating Matillion's Business Outcomes

We were able to decrease our nightly ETL that was running on Jenkins by 80%.
The long term savings from Matillion have primarily come through decreased work hours associated with building, maintaining and trouble shooting ETL processes.
Matillion's connection options are robust. We have been able to connect to many different database types, as well as build direct connections with our partner APIs.
Maybe two weeks to get over the initial hurdle and then we were off to the races. For the most part Matillion is very intuitive, simple, and easy to implement.

Using Matillion

3 - Business intelligence
3 - SQL and database theory and design. With a drag and drop UI not much is required aside from that.
  • Provide up-to-date reporting for internal customers
  • Build a single source of truth across the organization
  • Perform data warehouse maintenance tasks
  • Create custom API connectors
  • Drive maintenance through stored procedure calls
  • Sync databases across multiple environments
  • Create jobs to remain SOC 2 compliant
  • Cull large database tables by pushing them to S3 and removing unnecessary data from the data warehouse
  • Create more efficient pipelines
Ease of use, high performance makes it an easy choice.