Advanced

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 such 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”,...

Attaching An AWS IAM Role To An Existing EC2 Instance

Attach an AWS IAM Role to an Existing EC2 Instance You can now attach or replace an AWS Identity and Access Management (IAM) role to your existing Amazon EC2 instance. IAM roles...

URL Safe Characters

Overview In certain Matillion ETL components, a property may require a URL to direct toward a resource. In many cases, it is possible to include a username and password in the URL...

Configuring SAP NetWeaver Query To Accept New Data Sources

Overview SAP ships with over 100,000 tables by default and almost all SAP Netweaver implementations are highly customised. For this reason the Netweaver component only has a limited number of Data Sources...

Software Licenses

Below is a complete list of licenses for software utilised by Matillion ETL for RedshiftSnowflakeBigQuery for normal operation. Commercial Licenses Component License Type (Apache, MIT etc.) License Link JDBC Drivers (CData Software,...

Search Tab

The search tab exists on the Matillion ETL interface in the lower-right panel. Through this tab, the user can perform a search (partial match) on any term. This search will span all...