What do you like best?
User Friendly (but simple) user interface is big plus point. Tools which I have used are either power full with complex User interface or simple and basic. Because of simple user interface and drag and drop functionality it provides various components right from AWS, Google Cloud, Azure and also can execute python, R scripts or custom programs.
This enables users / developer to learn it very quickly than any other tool or scripts.
What do you dislike?
Many cloud base tools always provides trial of 7 / 14 / 30 days (or some credit) so that more people can try it out. I am sure there must be reason but if you can provide such facility then more people get opportunity to try it out and provide. like google provides $300 credit along with it if Matillion provides then clients can try end to end data flow.
Recommendations to others considering the product:
There are few factors can be considered in mind
1) Minimal Learning Curve: Matillion has pre-defined courses which are very practical and takes your practical implementation. within a couple days of efforts any developer can get familier with tool and get started with project.
2) User Interface: User Interface is such that it is easier for anyone (Like business analyst) to review the flow and rectify rather than line by line coding. This makes it easier for long run
3) Cloud base: This is light weight as zero installation is required. So from developer perspective this is best thing one can get
4) Execution and validation is very quick so it can be done easily.
So I would definitely recommend tool for anyone who is starting data management project.
What problems are you solving with the product? What benefits have you realized?
our proposed flow is where we need to connect data sources from AWS (Redshift) , SQL Server and load into Big Query. So Matillion comes very handy with connectors and all possible combinations of joining, combining data at interface.
Connecting diverse datasets is huge benefit. Lot of tools do not offer cloud components. As compare to it, this is big advantage.