Feedback on Matillion ELT
Overall Satisfaction with Matillion
We're exploring Matillion as an ELT tool when we migrate our workloads to the cloud. This software is not in production yet as we're still exploring. Once accepted, this software will be used in our Information Management department. This business problem that is addressed by this software is ELT.
Pros
- Drag n Drop to build orchestration and transformation jobs
- Simplicity
- Pay as you Go
- Ability to scale up and down
- Minimal code compared to the competition
- Cloud based
Cons
- Ability to migrate jobs created for one platform to other easily (for e.g. from Redshift to Snowflake).
- There is a scope of improving developer productivity by enhancing the user interface. Sometimes the UI is confusing.
- Some times the orchestration and transformation job diagrams become very complex. Need to come up with design patterns for proper diagram preparation.
- Pay as you model for ELT processing is appealing.
- Easy and quick to build simple orchestration and transformation jobs.
- Need more education material for greater adoption by the user community.
Simple transformation jobs are easy to build and run. We're able to build and run jobs within a week.
We've our own home-grown Java based ETL application. This application calls for code changes frequently, which is not the case with Matillion.
Comments
Please log in to join the conversation