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 Supergood's 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. Site terms may apply to any integration approach, and how they apply is a determination each team makes for itself.
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.
Supergood's grades measure one thing: can a customer's engineering team get their own data out programmatically? Supergood checks six things (whether a real API exists, how access is gated, data coverage, auth quality, docs and developer experience, and stability) and rolls them into a letter grade. Supergood re-verifies grades, and they only move on evidence.
Matillion scores GOOD on MCP availability. Matillion publishes an official MCP server for the Data Productivity Cloud API as the npm package @matillion/mcp-server, updated in July 2026. Official docs cover authentication and client setup and the server exposes over 60 tools for pipelines, schedules, and environments.
Yes. Matillion publishes an official MCP server, so MCP clients like Claude, Cursor, and Codex can connect to it directly. Setup instructions are in the vendor's documentation.