Overall Satisfaction with Matillion
We use it to take data from many sources and ingest them into our data lake. We then use Matillion to orchestrate transformation jobs on that data to eventually land it in our data warehouse.
- Variety of connectors
- Graphical interface
- Source control integration
- Some connectors have significant limitations (web services, NetSuite)
- Runs out of memory easily
- Logging not easily exportable
- Cost is okay, but is going up significantly soon. Value proposition is dwindling.
- It made it easy to get up-and-running as far as getting data into our data lake. Good for a "quick win."
- Pay-as-you-go model is good for smaller organizations.
We were able to get up and running very quickly. This is really Matillion's strength. Once we got past the peculiarities of setting up our environment, we could connect to data sources right away and ingest data into our data lake. Putting on more pieces after that was easy.
I did not make the purchase decision, but Data Services has a very high upfront cost and is not cloud-native not *was* Snowflake capable (it may be now). It's a good piece of software though.