Skip to Content

Redshift connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to an Redshift database server.

System requirements

Database server

Redshift Database Server

Client web browser

  • Chrome TM 60 or newer

  • Firefox ® 55 or newer

  • Safari ® 11.0.2 or newer

Connection instructions

Adding a server

  1. Navigate to the App Builder IDE

  2. From the Connect menu, click on the Connect to your enterprise link

  3. Click the Create button on the top left of the Data Servers panel. This will bring up the Add Server page.

    • Server Name: Identifiable name for server connection

    • Type: Redshift

    • Host Name: Endpoint associated with Redshift Database instance

    • Port: Not usually required (App Builder will use defaults for connection type), default for Redshift is 5439

    • User Name/Password: Credentials associated with Redshift Database instance

      Note

      User Name must match an existing Database in this instance for App Builder to properly connect

    attachment

  4. Click Save to complete server connection.

  5. Click Test Connection to ensure connection works properly.

Importing database

  1. Navigate to the App Builder IDE

  2. From the Build menu, click on the Build your application link

  3. Click on Data Storage Layer.

  4. Click the Create button on the top left of the Data Sources panel. This will bring up the Add Data Source page.

    • Data Source Server: Choose Redshift Server connected in previous step Data Source Name: Identifiable name for Data Source

    • Database Name: Identifiable name for Database

    attachment

  5. At bottom of pop-up, click Import