1. Set up an Amazon Redshift connection
Start establishing a connection to Amazon Redshift in either of the following ways:
- From the Resources menu, select Connections. Then, click + Create connection at the top right.
– or –
- While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.
In the resulting Application list, click Amazon Redshift.
The Create connection pane then asks you to name the new connection.
Be sure to provide a clear and distinguishable Name as soon as the connection is created. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.
Click Next to configure the connection.
2. Supply required Amazon Redshift account information
At this point, you’re presented with a series of options for providing Amazon Redshift authentication.
Region (required): Enter the portion of the amazonaws.com subdomain that corresponds to the region you identified when setting up your Redshift account.
Access key ID (required): Enter the Access key ID that you generated in your Redshift account.
Secret access key (required): Enter the secret access key associated with the Access key ID. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s Secret access key secret.
Sign in to your account at aws.amazon.com/console. Immediately, you will see the region at the top right. For example, if it says Oregon, enter us-west-2 for the Region setting in the connection.
Then, from the Services menu, navigate to Security, identity, & compliance > Identity and access management (IAM). Under Access management, select Users.
In the users Summary page, open the Security credentials tab.
If you have an existing Access key ID, you may provide it above, assuming that you already recorded the secret access key. To generate a new access key, click Create access key.
Copy this app’s Access key ID and Secret access key for use in the connection.
3. Edit advanced Amazon Redshift settings
Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Amazon Redshift connection.
4. Test and save
Once you have configured the Amazon Redshift connection, you have a few options for continuing:
- Test connection – click this button to verify that your new connection is free of errors
- Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
- Cancel – click to exit without saving any new changes
When you select Test connection, the connection is verified before continuing and the status is displayed in the Connection pane.
The new connection is now successfully added to your account. It will be applied to the current source or destination app, if you created it within a flow. Otherwise, you may proceed to register the connection with an integration.