Advanced

Data Transfer Between Databases

Overview. It may be useful to move tables from one database or cluster to another, a common issue when it comes to backing up work or sharing it with other users. AWS...

Environment Settings

Environment Settings An Environment in Matillion describes a single connection to a database, on which Matillion ETL jobs can be run. Numerous Environments can be set up at once, meaning different users...

Manage Backups

Overview This feature is only available for instances hosted on AWS. Matillion ETL does NOT automatically backup any of your work without proper configuration of the service described in this article. Before...

Loading Data

Overview 'Loading' data in Matillion means taking a data source and converting into a table on a target platform. Matillion ETL offers many ways to load data through its components that can...

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