Matillion at a glance
Matillion is a cloud data transformation tool to move data quickly and easily from one platform to another. In particular, the native integration of connectors to the most common cloud platforms and services supports fast and easy integration. By using the computing power of the respective cloud services, performance can be scaled as quickly as required and, above all, at low cost.
The process consists of two elements: Data Load and Data Transformation.
Matillion Data Loader
With the Matillion Data Loader, data can be easily loaded from a cloud data warehouse - all common platforms such as Amazon Redshift, Google BigQuery or Snowflake are supported. The best thing about it is: The Data Loader is available free of charge and convinces with a fast integration of different sources with the help of connectors (such as Google Analytics, Excel, Salesforce, Facebook, YouTube, Sharepoint and many more).
For easy integration, Matillion Data Loader supports:
- Wizard for setting up data pipelines - no coding know-how required.
- Automated runs defined according to your needs
- Due to the ease of use, more employees can work with data loads and thus distribute loads
Matillion ETL
Matillion ETL is designed specifically for cloud data warehouses. Matillion is the only cloud ETL software that integrates natively with Amazon Redshift, Google BigQuery, Microsoft Azure Synapse and Snowflake. This allows you to consistently take advantage of the performance, flexibility and economics of a cloud environment.
- Intuitive web interface for setting up workflows - no coding required
- Integrated connectors to on premises and cloud platforms
- REST API support for integrating custom data sources
- Predefined transformation components such as filter, join, aggregate, rank, etc. can be used without coding
- Control resource usage by orchestrating processes
