Data Productivity Cloud DocsDPC Docs Matillion ETL Docs

Data Productivity Cloud Docs

How-to guides and examples, reference material, and plenty more resources for navigating the Data Productivity Cloud.

Get started with the Data Productivity Cloud 🚀

The Data Productivity Cloud helps you move your data to a cloud data platform and then transform it—improving your time to value. Create and maintain complex data pipelines easily with a no-code/low-code user interface; build custom connectors for any source; and enjoy AI and high-code options to suit any need.

What is the Data Productivity Cloud?

Learn the essentials in 30 minutes

Find out what's new ⭐

We're introducing new features, connectors, and improvements all the time. Stay informed and get the most out of the Data Productivity Cloud.

Stay up-to-date with our New Features blog.

Prove your expertise with a certification!

Featured resources

Discover our most popular topics

Resources

• Data Productivity Cloud Docs
• New Features blog
• Changelog
• Roadmap

The Data Productivity Cloud

• New user tutorial
• Register an account
• Manage account users
• Learn about agents
• Read our security principles

Designer

• Getting Started
• Components
• Collaborating with Git
• Streaming pipelines

AI

• Overview
• Copilot
• OpenAI Prompt
• Pinecone Vector Query

Custom Connector

• What is Custom Connector?
• Build your own Custom Connector
• What are Flex Connectors?

Data Loader

• Batch load data into your data warehouse
• Realtime streaming with Change Data Capture

API

• Learn to use the Data Productivity Cloud API
• Endpoint Reference

Watch our latest and hottest videos

Subscribe 🔔

New

Featured

Matillion ETL Docs

How-to guides and examples, reference material, and plenty more resources for understanding Matillion ETL.

Announcements

• Latest version: 1.76
• Latest LTS version: 1.75
• If you're running an older version of Matillion ETL, you may experience 404s when using in-app links to our documentation. To navigate this issue, we advise upgrading to the latest short-term support (STS) version, or moving to a long-term support (LTS) version.

Matillion ETL basics

→

Learn the basics of Matillion ETL.

Matillion ETL overview
UI and basic functions
Environments
Variables
Jobs

Launching Matillion ETL

→

Guides for launching Matillion ETL via marketplaces, templates, BYOL, and HA.

Launching Matillion ETL overview
Cloud platform permissions
Launching via AWS CloudFormation templates
Launching via Azure Marketplace

Administration

→

Learn how to administer your Matillion ETL instances.

Admin menu
User configuration
OpenID
Migrate
Security best practices

Orchestrate

→

Create data pipelines that connect your data sources to cloud data platforms.

Data staging components
Python Script
Run DBT Command
SQL Script
Create Table

Transform

→

Transform your data for BI, analytics, and data science.

SQL
Table Input
Calculator
Join
Table Update

API

→

Use our API v1 to interact with Matillion ETL programmatically.

API v1
API v1 maps
Schedules endpoints
API profiles endpoints
Environments endpoints

Brand new videos every week

Subscribe 🔔

Academy How-To

From our experts!

Matillion Academy
Work through interactive, step-by-step guides for the Data Productivity Cloud.

Certification
Study up, take the exam and get your swag. Get certified and show off your expertise.

Matillion Community
Join a community of like-minded data professionals to discuss and shared experiences.

Matillion Exchange
Browse guides and download pipelines that can be imported straight into your projects.

YouTube
Watch guides to understand Data Productivity Cloud features, see user testimonials and more.

Slack
Join our Matillion community slack channel to get quick updates and chat to other users.