Matillion ETL Product Overview

Matillion ETL Product Overview


Overview

Matillion ETL is an ETL/ELT tool built specifically for cloud database platforms including Amazon Redshift, Google BigQuery, Snowflake and Azure Synapse. It is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.

  • Unlocks the power of your data warehouse: Matillion ETL pushes down data transformations to your data warehouse. Process millions of rows in seconds, with real-time feedback.
  • Modern, beautiful, browser-based environment: including collaboration, version control, full-featured graphical job development, and more than 20 data read, write, join, and transform components.
  • Fast setup: launch and be developing ETL jobs within minutes.

Matillion ETL User Interface

Key Features:

  • Drag-and-drop browser interface. Build sophisticated, powerful ETL/ELT jobs.
  • Push-down ELT technology uses the power of your data warehouse to process complex joins over millions of rows in seconds.
  • Live feedback, validation, and data preview, in-tool, as you build your ETL/ELT jobs.
  • Collaboration baked-in. Build jobs together in disparate locations, like in Google Docs.
  • Version control, import/export and server-side undo.
  • Over 25 data Admin Menu to administer your ETL instance.
  • Over 50 connectors to popular online services that you can connect to and pull your data from.
  • Easy UI and Basic Functions so you can build your first job in minutes.
  • In-client support.
  • Enterprise features such as Generated Documentation and Data Lineage.

This support site describes:

  • How to find, launch, and connect to Matillion ETL.
  • How to use the product.
  • A detailed description of each of the available components.
  • Procedures, techniques, and best practices to get the most out of Matillion ETL.

Please Note

If you choose to register, you can raise questions in the moderated support forums and participate in discussion threads.


Getting started

Launching

To get started with Matillion ETL, you will need to decide which version and instance type of Matillion ETL is best for you. The instance type you select affects the maximum number of concurrent users who can access Matillion ETL and the maximum number of environments you can connect to.

Check out our launch guides below or to discuss your options, contact our sales team at sales@matillion.com.

Connect To An Instance

Once you have launched Matillion ETL, you should be able to connect and start creating workflows in minutes. See the appropriate guide below for details on connecting to your instance:

Creating A Project

One of the first things to do on your new Instance is to set up a Project that contains your configurations and resources such as jobs. Check out the below guide for help with sections detailing Project creation for each version of Matillion ETL.

Set Up Credentials

Your Matillion ETL instance needs to communicate with your cloud platform and data warehouse to perform its core functions. See the appropriate guide below on Roles & Permissions for your platform:

Please Note

Although setting up "Instance Credentials" like this is important to core functionality, Matillion ETL can also use services from other cloud platforms in a similar manner. See Manage Credentials for more information.

We highly recommend browsing the rest of the "Getting Started" documentation category and then moving on to "Core Concepts" to get the best start with Matillion ETL.


Videos