Matillion API
Two documented public REST APIs cover the product line: the Data Productivity Cloud API and the legacy Matillion ETL v0/v1 API, each with its own auth and conventions. Access rides on a Matillion license. Docs are mid-migration into the Maia hub and links break.
Frequently asked questions
Matillion scores C on the API Report Card. Two documented public REST APIs cover the product line: the Data Productivity Cloud API and the legacy Matillion ETL v0/v1 API, each with its own auth and conventions. Access rides on a Matillion license. Docs are mid-migration into the Maia hub and links break.
Matillion has an official API, but teams routinely hit its limits: gated access, partial coverage, or paid tiers. Most end up supplementing it with exports or an unofficial API layer like Supergood.
Matillion is a cloud-native data integration and transformation platform headquartered in Manchester (UK) with a major US office in Denver.
Vertical: misc (horizontal data infrastructure). Matillion is not a vertical-SaaS product and does not map cleanly to any Supergood named vertical. Ingest + transform into Snowflake/Databricks/Redshift/BigQuery/Synapse, pull data from Salesforce, NetSuite, Workday, SAP, Marketo, Dynamics, ServiceNow, Oracle, Postgres, MySQL, S3/GCS/Azure Blob, Kafka, etc., land in the warehouse, then run cleansing/aggregation/transformation pipelines.
High within the cloud ELT / data integration category. Matillion is consistently named in the Gartner Magic Quadrant for Data Integration Tools and is one of the most cited Snowflake and Databricks ecosystem partners.
Data and operations that flow through Matillion on behalf of customers: Source-system data extracts, CRM (Salesforce, Dynamics, HubSpot), ERP (NetSuite, SAP, Oracle, Workday), marketing (Marketo, Eloqua), service desk (ServiceNow, Zendesk), payments and billing (Stripe, Zuora), HRIS (Workday, BambooHR), product analytics (Segment, Amplitude), databases (Postgres, MySQL, Oracle, SQL Server, MongoDB), file stores (S3, GCS, Azure Blob), and streaming sources (Kafka, Kinesis).
Founded in 2011. Originally an AWS Marketplace AMI product for Redshift, Matillion has fully repositioned around the SaaS Data Productivity Cloud since ~2022 while continuing to maintain Matillion ETL for instance-based customers.
Two parallel API surfaces (Matillion ETL v0/v1 vs Data Productivity Cloud) with different auth, pathing, and payload conventions force integrators to learn both. DPC API documentation is in flux and now redirects into the Maia docs hub, breaking long-standing links. Full sourced list under Sources below.
Common alternatives include Fivetran, Informatica IDMC (Intelligent Cloud Services), Talend (Qlik), Airbyte, Coalesce, dbt Labs. Graded alternatives appear under "More from the report card" below.
Grades measure one thing: can a customer's engineering team get their own data out programmatically? We check six things (whether a real API exists, how access is gated, data coverage, auth quality, docs and developer experience, and stability) and roll them into a letter grade. Grades get re-verified, and they only move on evidence.