Advanced

HubSpot Data Model

Connection String Options Auto Cache Batch Size Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Cache Tolerance Callback URL Column Sizes Company Properties File Connection Life Time Connect On...

Incremental or High Water Mark data loading

Overview It is a common use case to retrieve regular batches of data from a data source where the source table has a last updated time-stamp or other incrementing key. This makes...

Writing API Profiles

Important: New API drivers have changed the way that input parameters are set up in the rsd. With the latest version of Matillion, users must set up input parameters as inputs rather...

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