Advanced

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...

Building a Data Vault

Introduction This document demonstrates how to implement a simple Data Vault model using Matillion ETL. You can download and install the example job attached at the end of the page. The example...

Getting Started With Google Analytics

Getting Started with Google Analytics in Matillion ETL When using any load component in Matillion, the first step is to understand the data to be extracted. In Matillion the Google Analytics Component...

Parallelism with Matillion ETL for Redshift

While developing Orchestration jobs with Matillion ETL for Redshift, you may have noticed that Transformation jobs which are able to run in parallel actually run serially: one after the other. Similarly, when...

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...

Integrating Slack with Matillion ETL

Overview Slack is a popular messaging tool for teams to communicate and to automate notifications from third party applications. Matillion can send messages to Slack via Amazon SNS messages. This can be...

Audit Log

Overview The Audit Log shows a list of significant activity within a Matillion Instance. Most actions by users are logged here in detail such that they are accountable for any changes made....