Setup guide - Matillion Full SaaS Amazon Redshift

This document describes the necessary steps to follow to set up your first working project in the Data Productivity Cloud for the following configuration options:

Deployment type:

Matillion Full SaaS

Cloud platform:

Provided by Matillion

Cloud data warehouse:

Amazon Redshift

---

Prerequisites

Amazon Redshift requirements

• An Amazon Redshift account with the following information:
  • The physical address of the Amazon Redshift leader node. This will be either a name or an IP address.
  • The port Amazon Redshift communicates on, configured when setting up your Amazon Redshift cluster.
  • Your Amazon Redshift username and password.

Connectivity requirements

• Access enabled for the IP addresses listed under the Full SaaS section of Allowing IP addresses.

---

Setup steps

1. Register for a Data Productivity Cloud account.
2. Create accounts for users and admins who will be active in the Data Productivity Cloud.
3. Create a project, making the following choices:
   • Select Matillion managed.
4. Create an environment using your Redshift credentials.
5. Set up secret definitions for passwords, API keys, and tokens.
6. Create a Git branch in which to begin pipeline work.
7. Create your first pipeline.

Got feedback or spotted something we can improve?

We'd love to hear from you. Join the conversation in the Documentation forum!