Amazon Redshift

Follow these steps to use Amazon Redshift as your target.

Step 1 - Connect to Amazon Redshift

Create a new connection

Click Create a new connection, if it is not already selected.

In the Connection String field, enter your connection in the following format:

jdbc:redshift://<ENDPOINT>:<PORT>/<DB_NAME>

where:

• ENDPOINT: The endpoint of the Amazon Redshift cluster.

• PORT: The port number that you specified when you launched the cluster. The default port for Amazon Redshift is 5439.

• DB_NAME: The name of the target database.

Read more:

• Connection string arguments in Redshift

• Finding your cluster connection string

Provide the Username and Password that will be used to authenticate to the database.

In the Name your connection field, type in the name for this connection. Please note this connection will be available to other users in your organization.

Create a new connection to Amazon Redshift to use as the target for your ingestion job.

Use an existing connection

By default, if you have already created a connection, Upsolver selects Use an existing connection, and your Redshift connection is populated in the list.

For organizations with multiple connections, select the target connection you want to use.

Select your Redshift connection to use as the target for your ingestion job.

Step 2 - Select where to ingest the data

Select an existing schema for the ingested data in the Select a target schema list.

If you are ingesting into a single table, provide a name for the new table. If the source is a database (Microsoft SQL Server, MongoDB, MySQL, PostgreSQL) Upsolver will create new tables in the selected schema.

When ingesting multiple source schemas into Redshift you have the following options:

1. Ingest all tables into a single Redshift schema and add the source schema name to every new table created in Redshift.

2. Map every source schema into a target schema in Redshift.