Summary

The Jitterbit Harmony Amazon Redshift Connector provides an interface for entering user-provided input such as credentials to create an authenticated Amazon Redshift connection. That connection provides the foundation to configure associated Amazon Redshift activities that interact with the connection.

Supported API Versions and Prerequisites

The Amazon Redshift connector uses the Amazon Redshift JDBC Driver and Amazon Redshift SQL Commands. Refer to the Amazon Redshift documentation and the Amazon Redshift System Overview documentation for additional information.

The Amazon Redshift connector requires the use of an agent version 10.1 or later. These agent versions automatically download the latest version of the connector when required.

Connector Overview

This connector is used to first configure an Amazon Redshift connection, establishing access to Amazon Redshift, and then used to configure one or more Amazon Redshift activities associated with that connection as a source or target within an operation:

• Query: Retrieves records from a table at Amazon Redshift and is intended to be used as a source in an operation.

• Copy: Reads data from an Amazon S3 bucket and inserts records into a table at Amazon Redshift and is intended to be used as a target in an operation.

• Insert Bulk: Inserts multiple records into a table at Amazon Redshift and is intended to be used as a target in an operation. It provides the option to set the number of records per batch and the option to stop processing the remaining records if an error is found.

• Insert Record: Inserts a record into a table at Amazon Redshift and is intended to be used as a target in an operation.

• Update Bulk: Updates multiple records in a table at Amazon Redshift and is intended to be used as a target in an operation. It provides the option to set the number of records per batch and the option to stop processing the remaining records if an error is found.

• Update Record: Updates a record in a table at Amazon Redshift and is intended to be used as a target in an operation.

• Upsert: Updates an existing record or creates a new record in a table at Amazon Redshift and is intended to be used as a target in an operation.

• Delete Record: Deletes a record from a table at Amazon Redshift and is intended to be used as a target in an operation.

Together, a specific Amazon Redshift connection and its activities are referred to as an Amazon Redshift endpoint.

Accessing the Connector

The Amazon Redshift connector is accessed from the Connectivity tab of the design component palette by using the Show dropdown to filter on Connectors.

Once a connection is configured, activities associated with the endpoint are available by using the Show dropdown to filter on Endpoints and then clicking the Amazon Redshift connection block: