Advanced

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

Generate Job Documentation

Overview Note: Job Documentation Generation is an Enterprise-only feature, meaning it is only available to customers on m4.large and m4.xlarge instances. Matillion ETL allows users to generate documentation for any given job...

JIRA Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Include Custom Fields...

Populating an Audit Table

Auditing Runtime Data Each component can make runtime information available. In this example, we are interested in how long an S3 load takes to complete and we want to show how to...

Paging with the API Query Component

This document builds on an earlier article "Writing API Profiles", and describes how to include paging in an API Profile that you have created. Other documents in this series: Using Parameters With...

Matillion Data Quality Framework

Background The term “data quality” is very broad, and typically has a dual meaning: Data that is complete, accurate and relevant A set of processes to achieve such a state We’ll focus...

LDAP Integration

Overview Matillion supports 3 authentication models – NONE, INTERNAL (default) and EXTERNAL By default (from v1.25.1) users in Matillion are authenticated against an INTERNAL user file however it is possible to authenticate...

ServiceNow Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Initiate OAuth Instance...

PayPal Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Callback URL Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Initiate...