Small scale Matillion user
May 15, 2019
Small scale Matillion user
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
As a ETL tool to pull data from various data sources for which Matillion had data connectors into a central database.
It was used only by the Marketing department. Since Matillion had its own native connectors to certain platforms, it was easy to pull data from those sources. And since we didn't have a developer to write scripts for those connectors, someone less tech savvy could do it themselves by dragging & dropping. Also since Matillion was responsible to keep its native connectors up to date, a developer wasn't required to read and implement all new API documentation if there were certain changes.
It was used only by the Marketing department. Since Matillion had its own native connectors to certain platforms, it was easy to pull data from those sources. And since we didn't have a developer to write scripts for those connectors, someone less tech savvy could do it themselves by dragging & dropping. Also since Matillion was responsible to keep its native connectors up to date, a developer wasn't required to read and implement all new API documentation if there were certain changes.
- Native data connectors
- No fixed fees
- Good support
- Development timeline
- More data connectors to various ad platforms
- Need the instance live to do setup, which you then pay for
- Initial setup is very technical
- Fewer resources were needed to implement ETL processes.
It was up and running in about 3 weeks. From initial conversations to Matillion, to infrastructure setup, to testing, to actually ETL being run.
Before Matillion, we were writing scripts or using super metrics for sheets. The former was very resource intensive while the latter had limited queries and sheets could handle them. With Matillion, we could fill AWS Redshift directly.