If you were talking to someone whose organization is considering Matillion ETL, what would you say?
How would you rate it and why? Any other tips or advice?
We're using the latest enterprise version of the solution with the public cloud deployment model. They're constantly improving themselves. I'm quite pleased with the pace of the number of changes that are coming out all the time. It's a great product and I think it's very competitive. I would recommend the solution. I would rate the solution nine out of ten.
It is perfect for when you need your data to never leave your environment using a robust tool. It also ensures the best security practices are deployed within your AWS account. I have also integrated this solution with Microsoft Azure, but the best performance is with AWS.
Give it a shot. See how easy it is to get started with the product, because the scripting which is required is minimal. Anybody who is familiar with the SQL Server platform and with SQL scripting can easily pick it up and run with it, Overall, it is a really good product.
It does the things that it does fairly well, but it would be nice to have some more features, like custom jobs. Try different tools as much as you can. Make sure the different data that you are trying to sync fits in with the integration the tool provides (or at least most of them). Otherwise, you are going to be paying a lot for not using most of its features.
Anybody can help to configure and train on it, learning how to use it. This will help speed up the process. We use the AWS version only.
Ask about pricing details.
* Experiment and test it ASAP * Watch all the videos from Matillion * Join their webinar series * Talk with existing users Remember, what Matillion does is simply orchestrate the required jobs. It stands back and lets Redshift do what it is good at.