Advanced

Matillion ETL API - v0

Overview Note: v1 of the Matillion ETL API is now available. Details can be found here. The Matillion ETL API is designed to make it easy to interact with Matillion ETL programmatically....

API Examples

Overview These examples are designed to demonstrate the use of the Matillion ETL Rest API. For standard API documentation see here. The endpoints used in these examples are: /rest/v0/projects - For exporting...

Sugar CRM Data Model

Connection String Options Auth Settings Location Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Location Logfile Max...

Dynamics NAV Data Model

Connection String Options Auth Scheme Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Company Connect On Open Continue On Error Firewall Password Firewall Port Firewall Server Firewall Type Firewall User...

Oracle Eloqua Data Model

Connection String Options Auto Cache Bulk Polling Interval Bulk Query Timeout Cache Connection Cache Driver Cache Location Cache Metadata Company Connect On Open Data Retention Duration Firewall Password Firewall Port Firewall Server...

Netweaver Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Charset Client Connection Type Connect On Open Destination Endian Type Firewall Password Firewall Port Firewall Server Firewall Type Firewall...

Mailchimp Data Model

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

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