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.