Advanced

Magento Data Model

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

SCM Integration

Overview For some customers the best practice topology is to have multiple instances of Matillion ETL (e.g. for Development, Test and Live) and then manage the migration using source control management system...

Adding Filename as a column to new Table

Overview A question we are often asked is how to add the source filename as a column in the Redshift table. Unfortunately the Redshift COPY command doesn’t support this however there are...

Obtaining an API token and passing it into a RSD script

Some API profiles require a refresh token to be passed in as part of the header. Examples include the Volo API and the Hubspot API. Some of these refresh tokens expire regularly,...

New Google Analytics Data Sources

The Google Analytics Query component comes with some Data Sources out of the box. These Data Sources have certain Google Analytics fields in them. Each Data Source also comes with the option...

QuickBooks Online Query Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Cache Tolerance Callback URL Company Id Connect On Open Country Code Firewall Password Firewall Port Firewall...

Square 3rd Party OAuth Setup

Below we outline how to connect Matillion ETL to your Square account using a simple OAuth setup. The process can be understood in 2 parts - collecting details from your Square account...

YouTube Data Model

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

Marketo 3rd Party OAuth Setup

Below we outline how to connect Matillion ETL to your Marketo account using a simple OAuth setup. The process can be understood in 2 parts - collecting details from your Marketo account...

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