Matillion a great, easy to implement resource
Updated September 02, 2022
Matillion a great, easy to implement resource
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 was up and running almost overnight. Our ops department spun up in an instance and we were off to the races.
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.
Matillion Feature Ratings
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