Advanced

Couchbase Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Flatten Arrays Flatten Objects Location Logfile...

Cassandra Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Connect On Open Database Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Flatten Arrays Flatten Objects Location...

Password Manager

Overview For information on managing passwords via the API, see v1 API - Passwords. Many of the components in Matillion ETL require passwords to provide access to various services on behalf of...

Mailchimp 3rd Party OAuth Setup

Overview In order to connect to your Facebook data Matillion requires that OAuth is configured. Before you can configure OAuth in Matillion ETL you first need to enable it in your Facebook...

Date and Time Methods

Overview For the methods described in this article to work, you must use a Matillion ETL variable that is defined as a DateTime type and it must have a valid default value....

Loading Task Information

Overview It can be useful to take the task information from Matillion ETL and load it into a table and/or to preserve it on in file storage, allowing the user to run...

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

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