Matillion Data Loader v1 Documentation
  • Dark
    Light
  • PDF

Matillion Data Loader v1 Documentation

  • Dark
    Light
  • PDF

Overview

Matillion Data Loader is a SaaS (software as a service) Data Pipeline tool that copies data from popular data sources into a cloud data warehouse. We built this tool for businesses who are looking to get started with cloud data warehousing, or those looking for a simple way to move large amounts of data.

For a more detailed look at the features of Matillion Data Loader, read UI and Basic Functions.

mdl-overview

We support a wide range of data sources, such as Salesforce, Jira, and Google Analytics. The cloud data warehouses we support are: Snowflake (AWS and Azure), Amazon Redshift, and Google BigQuery. Matillion Data Loader works on several web browsers, such as Google Chrome and Firefox.

Easy to follow wizards make data integration easy and fast for IT professionals and non-technical data professionals alike.

You can register through your Google or Microsoft account, or sign up using your email address.


How does it work?

Matillion Data Loader takes advantage of the cloud to efficiently extract and load data. You will need to authenticate your data source(s) with a username/password, or OAuth. You will need to authenticate your target data warehouse with a username/password through Matillion.

Credentials are sent to the service when a Pipeline runs. The service sends data to an isolated runner in the Matillion VPC. The runner then stages the data in a staging area (e.g. Amazon S3), before loading onto the target table in the data warehouse (e.g. Amazon Redshift). You'll be able to provide your preferred staging bucket (except for Snowflake which uses internal Snowflake staging).

If you are looking to do more with your data, we offer a seamless transition to Matillion ETL, which allows for complex transformations.