Data Models

Overview

Below is a list of data models for use with Matillion ETL "Query" components. Data models document connection settings, tables, and views.

Where appropriate, data models are updated to reflect the corresponding driver version used by Matillion ETL.

Apache Hive	Apache Spark SQL	Bing Ads
Bing Search	Cassandra	Couchbase
Dynamics 365 Business Central	Dynamics 365 Sales	Dynamics 365
Dynamics CRM	Dynamics NAV	DynamoDB
Elasticsearch	Email	Excel
Facebook Ads	Facebook	Gmail
Google Ad Manager	Google Ads	Google AdWords
Google Analytics 4	Google Universal Analytics	Google BigQuery
Google Custom Search	Google Sheets	HubSpot
JDBC	Jira	LDAP
LinkedIn Ads	LinkedIn	Magento
Mailchimp	Marketo	MongoDB
NetSuite	OData	Open Exchange Rates
Oracle Eloqua	PayPal	QuickBooks Online
Redis	Sage Intacct	Salesforce Marketing Cloud REST
Salesforce Marketing Cloud SOAP	Salesforce	SAP HANA
SAP NetWeaver	SendGrid	ServiceNow
SharePoint REST	SharePoint SOAP	Shopify
Splunk	Square (v2)	Square (v1)
Twilio	Twitter Ads	Twitter
Xero	YouTube Analytics	YouTube (deprecated)
Zoho CRM	N/A	N/A

Table of contents