Easily set up your ETL/ELT pipeline with Matillion
Updated June 13, 2019
Easily set up your ETL/ELT pipeline with Matillion
Score 6 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
We're using Matillion to mainly load data from three places into our RedShift clusters. The first one is from a s3, the second is syncing data from our production DB.
- Managing Schedule
- Intuitive UI
- Easily integrates with the rest of AWS
- Create different versions is easy
- The deployment process is quite manual; need to export and import, create a new version. Would be nice if there's a repo for continuous integration
- The Python script module is very limited. We try to use it to parse data on a file with 500 records, and it constantly crashes. It does not have the capabilities to run Python programs
- In the Mongo module, the field must exist in the source system. Working with NoSQL DB, some fields might not exist just yet, and essentially we'll have to create everything downstream once the field appears in the source system.
- Accelerated development of ETL data pipeline.
- Easy onboarding for new users.
- Easily create scheduled jobs to maintain a RedShift environment.
We were able to set up within an hour. I set up my first job (loading a CSV file from S3 to RedShift) by lunch.
- RedPoint Data Management & Quality, AWS Lambda, Microsoft SQL Server, PostgreSQL, MySQL, SAS DataFlux, SAS Data Management Platform and SAS Data Integration Studio
Overall from an ease of use and set up standpoint, it stacks up better than most of the other tools I've used. However, Matillion doesn't quite expand and scale up as well as the other solutions.