Matillion ETL is a cloud-native data integration tool. However, it is misnamed: it should really be Matillion ELT. There is a complementary Matillion Data Loader.
Matillion’s primary strength and major differentiator lies in the tightness of its integration with its target environments, for which it provides specific additional capabilities. While excellent for supported environments, which will include Databricks in the next release, implementing such depth of capability also explains why Matillion does not support more targets as, obviously, there is a significant investment in each target: it is not simply a question of building a connector. However, it also limits the use of Matillion. The company is starting to introduce what it calls “tactical output connectors” which are more generic but the numbers of these is also limited.
Author/s: Philip Howard,Daniel Howard