Advanced

MongoDB Connection Options

Connection String Options Auth Database Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Database Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Flatten Arrays Flatten Objects Location Logfile...

Dynamics CRM Data Model

Connection String Options Auth Scheme Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Caller Id Connect On Open CRM Version Default Precision Device Credential Location Device Credential Password Device Name...

Netsuite Query Data Model

Connection String Options Account Id Aggregate Column Mode Application Id Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall...

Google BigQuery Data Model

Connection String Options Allow Large Result Sets Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Connect On Open Dataset Id Destination Table Firewall Password Firewall Port Firewall Server Firewall Type...

Google Spreadsheets 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 Header Initiate OAuth Location Logfile Max...

Getting started with the API Driver in Matillion ETL

Overview API Query Component in Matillion ETL allows you to integrate with almost any JSON or XML based API. The component converts the API into a pseudo SQL dialect that can then...

Marketo Data Model

Connection String Options Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Check Prompt Mode Connect On Open Encryption Key Firewall Password Firewall Port Firewall Server Firewall Type...

Google Adwords Data Model

Connection String Options Auto Cache Batch Size Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Client Customer Id Connection Life Time Connect On Open Developer Token Firewall Password Firewall...

Excel Connection Settings

Data Model Connection Options Allow Formula Buffer Changes Empty Value Mode Excel File Has Cross Sheet References Header Ignore Calc Error Logfile Max Log File Size Null Value Mode Orientation Other Pseudo...

OData Data Model

Connection String Options Allow Resource Url Auth Scheme Auto Cache Azure AD Resource Azure AD Tenant Batch Size Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Cache Tolerance Callback...