
Fig 01 - Matillion architecture_methodology
Matillion ETL is a cloud-native data integration tool. However, it is misnamed: it should really be Matillion ELT because its processing paradigm is to extract data from source systems, load that into the relevant target and then transform the data as appropriate for the use case. This is illustrated in Figure 1.

Fig 02 - Matillion Data Loader supported environments
A second tool, Matillion Data Loader is also provided to facilitate migrations from existing environments into cloud data warehouses and data lakes. This is illustrated in Figure 2. This is a SaaS-based application that is provided free of charge. It offers a wizard-driven environment not requiring any coding. Note that, unlike Matillion ETL, Azure Synapse Analytics is not currently supported. Also note the more limited data sources supported by Data Loader.
Finally, Matillion offers a significant number (90+) of source connectors. However, most of these are application-oriented and native connectors (much to be preferred for performance reasons) to databases are relatively limited though JDBC is supported. There are facilities to build your own connectors (using a REST API), but this will only be relevant to applications and, in any case, this only applies to source systems and not to targets. The company plans to introduce a community portal where users can exchange connectors as well as other integration artefacts.
Customer Quotes
“Matillion enables our team to provide meaningful data insights quickly. And, because it’s built for modern cloud data warehouses, we can use native Snowflake functionality to transform our data.”
Cisco