Amazon Redshift is a data warehouse product that helps customers to handle large-scale data storage and database migrations.
Two connectors are available for Amazon Redshift:
-
Databases: Amazon Redshift – Use this connector to extract, load, and transform (ELT) workflows and other data warehouse automation needs, such as sending or retrieving data.
-
Connectors: Amazon Redshift (REST API) – Review the Using the Amazon Redshift Data API documentation for your use case, and configure this connector as required.
Amazon Redshift documentation: API guide , Authentication
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, select Amazon Redshift.
The Create connection panel opens with required and advanced settings.
At this point, you’re presented with options for providing Amazon Redshift authentication.
Region (required): Select the region for this Redshift account. By default, [us-east-1] is selected.
Access key ID (required): Enter the Access key ID you generated in your Amazon 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 safe.
-
Sign in to your account at aws.amazon.com/console.
-
You can see the region at the top right. For example, if it says Mumbai, enter
ap-south-1for the Region setting in the connection. -
From the Services menu, navigate to Security, identity, & compliance > Identity and access management (IAM).
-
Under Access management, select Users.
-
Select the required user and on the user's Summary page, click Security credentials.
-
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.
Username (required): Enter the Amazon Redshift database username. For information on how to create a database user, see Configuring connections in Amazon Redshift.
Databasename (required): Enter the Amazon Redshift database name as configured by the administrator.
Clustername (required): Enter your Redshift cluster name.
Once you have configured the Amazon Redshift connection, you have a few options for continuing:
-
Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
-
Save & close – click to test and save the connection and exit the Create connection panel
-
Close – click to exit without saving any new changes
-
Test connection – click this button to verify that your new connection is free of errors
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.
Amazon Redshift (REST API) documentation: API guide , Authentication
Start establishing a connection to Amazon Redshift (REST API) 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, select Amazon Redshift (REST API).
The Create connection panel opens with required and advanced settings.
At this point, you’re presented with options for providing Amazon Redshift (REST API) authentication.
Region (required): Enter the portion of the amazonaws.com subdomain that corresponds to the region you identified when setting up your Amazon Redshift account.
Access key ID (required): Enter the Access key ID that you generated in your Amazon 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 safe.
-
Sign in to your account at aws.amazon.com/console.
-
You can see the region at the top right. For example, if it says Oregon, enter
us-west-2for the Region setting in the connection. -
From the Services menu, navigate to Security, identity, & compliance > Identity and access management (IAM). Under Access management, select Users.
-
In the users Summary page, click 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.
Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Amazon Redshift (REST API) connection.
Once you have configured the Amazon Redshift (REST API) connection, you have a few options for continuing:
-
Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
-
Save & close – click to test and save the connection and exit the Create connection panel
-
Close – click to exit without saving any new changes
-
Test connection – click this button to verify that your new connection is free of errors
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.
Comments
Please sign in to leave a comment.