Matillion easy and faster
March 08, 2023

Matillion easy and faster

Sahil Bhange | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

We use Matillion on top of Snowflake to perform extensive ELT data transformation.Its easy orchestration helps non-technical users to create SQL based data pipeline and schedule those as per their requirement.
Reduces involvement of Tech team due to ease of use.
Snowflake acts a source and Target for most of our data system. We populate all our finance and other organizational reports using Matillion. Matillion is being used used in DWH, BI, Marketing and other teams.

Pros

  • Excellent tool to do ELT data pipeline using Snowflake
  • Easy graphical orchestration to enable complex dependencies
  • Easy manage users and group permissions
  • Easy to schedule jobs using time dependency and job dependency
  • Provides many API's to fetch data from multiple vendors

Cons

  • Though its not a Matillion use case, but Matillion can add more machine learning and Data science capabilities,
  • easy AWS services integration
  • More sofisticated Data Lineage graph

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?

I wasn't involved with the selection/purchase process

Did implementation of Matillion go as expected?

I wasn't involved with the implementation phase

Would you buy Matillion again?

Yes

  • Easier and faster access to data
  • Easy to change and deploy ETL applications
  • With cloud Snowflake Matillion, work loads runs faster
  • Orchestration is easy implement and provides easy re-run and debug capabilities
Using Matillion from 4 years.Reduced overall deleopment and deployment time significantly.
Also easy to implement complex orchestration for dependency jobs
within 3 months with POC
With cloud, we are able to fetch all the data sources, but tech team did not approve integration with other cloud serivces due to security issues
Matillion is easy to use and easy to teach to moderate tech knowledge team members
Matillion is well suited for:Data warehouse with moderate technical skill can do wonder with SQL based ELT data pipelinesIf Org has data lake in Snowflake or other Cloud database, Matillion can access all data and DWH/BI team can create their data marts with less frictionReduces dependency on highly technical folks for data processing.

Matillion is less suited for:
Complex machine learning and data science task.

Matillion Feature Ratings

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

Comments

  • Steph Mills | TrustRadius Reviewer
    Thank you for your review. We truly appreciate you taking the time to share your experience and help others on their data transformation journey! We would love to hear more, please reach out to us at customeradvocacy@matillion.com if you would like to join our advocacy program.

More Reviews of Matillion