Advanced

Input Data Report

Overview The Input Data Report can be found through the menu Project Input Data Report. The Input Data Report lists each column used by each Table Input component such that a user...

Project Sharing

Overview It is possible for users to create a project that is private and unavailable to other users. This project can have access permissions edited to allow other users access. This requires:...

Cross-Account S3 Access

Overview This document describes the AWS setup needed to allow Matillion to load data from an S3 file in a different AWS account. Amazon’s authentication model makes this possible without the S3...

Adding A 3rd Party JDBC Driver

Overview Matillion ETL’s Database Query orchestration component uses JDBC to query relational databases that are acting as data sources for your application. A number of commonly-used JDBC drivers are provided with Matillion...

Import / Export

Overview Jobs, environments and variables can be exported from one Matillion ETL instance to be imported to another. One way of accomplishing this export is through the API. A more user-friendly method...

Project Collaboration

Overview A given Matillion ETL instance can host multiple users (depending on instance size) at one time. A given Matillion ETL instance can host multiple users at one time. Each user is...

Microbatch Replication

Overview This article describes how to set up a near-real-time data replication pipeline using a microbatching job in Matillion ETL. In this scenario, the data source is an OLTP system which constantly...

Authentication With API Profiles

Overview This document builds on an earlier article "Writing API Profiles", and describes how to add authentication to an API Profile that you have created. To recap, a Matillion API Profile contains...

Manage Connections

Manage Connections Matillion ETL allows multiple connections to the same instance. These connections are each given an ID so that each user can see what other connections are doing within the instance...

Using Parameters With API Profiles

Overview This document builds on an earlier article "Writing API Profiles", and describes how to include parameters to an API Profile that you have created. The Matillion API Profile contains RSD “files”,...