Overall Satisfaction with Matillion
We utilize Matillion to transform data from multiple source systems into a cloud-based database. Our department is the sole user of Matillion and is managed exclusively by our team. Matillion allows our organization to consolidate our various data sources into a singular environment where our dashboard tools access data to provide valuable insights into the various units within our organization.
- Connection to numerous data sources
- Validation of objects and components
- Ease of use to schedule run-times
- Variable driven code development
- Documentation examples
- Speed of processing
- Requires upfront investment in design of system processing.
- Assistance with upgrades
- Our team can dynamically make modifications to code and deploy them immediately.
- Source control and access via the cloud has enabled us to onboard new employees quickly.
- The only negative is that it is relatively new to folks and it takes a little time to ramp up, however, the long term ROI pays off.
Matillion was already implemented at our company and any time requirements to learn the tool was based on my ability to translate my previous ETL coding experience into Matillion's structure. Our team inherited an existing ETL process built-in Matillion and were able to add/modify/delete new objects and components within several weeks of having access to Matillion. It was necessary to understand the business rules prior to making any changes, but the tool itself is very intuitive.
SQL Server Integration Services was the only application that we examined since most of our primary data sources are built in the Microsoft environment. Matillion's ease of use and cloud-based architecture allows our team to have a single entry point to examine the most recent version of code and make modifications to it. Matillion seamlessly integrates with Snowflake and is a much easier product to work with, especially from a source control perspective.