Excellent Entry-Level ETL/ELT Resource
June 28, 2019
Excellent Entry-Level ETL/ELT Resource
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
We used Matillion on a small, 3-person team to manage ingestion and transformation for our data warehouse, pulling from numerous datastores and vendors to a common warehouse schema.
- Shallow learning curve - Matillion is powerful, but only as complicated as you need at a given time.
- Superb helpdesk and documentation.
- Jobs are translated directly to SQL which makes them easy to debug.
- Parsing of flat files is inconsistent depending on the source
- The product is constantly evolving (good!) but that means relearning parts of the interface every few months
- Support for a larger set of APIs and database engines would be helpful
- Permitted our existing staff to take on ETL, rather than hiring an SME
With the help of the support team, we had a proof of concept up and running in an afternoon. Since Matillion comes as an AWS package, there was no configuration needed to get the instance spun up, which was fantastic. Connecting to data sources that require their own JDBC drivers took as much as an hour, but settings are portable, so this was a one-off process for each new source.