¶ AWS Redshift Connection in EaConnect
The following configuration values are required to connect to AWS Redshift:
- Cluster Identifier
- Database Name
- Database Username
- Redshift Cluster Region
- AWS access keys (Access Key ID and Secret Access Key) for an IAM user with the "AWSRedshiftFullAccess" permission policy.
¶ Prerequisite
Before you proceed, make sure you have the following:
- AWS Redshift cluster with the necessary access credentials.
- Redshift Cluster Region
¶ Steps to Obtain Required Credentials
Step 1: Get the Redshift Cluster Identifier Name
1.Sign in to the AWS Management Console.
2.Navigate to the Amazon Redshift console by searching for "Redshift" or selecting it from the list of services.
3.In the Redshift dashboard, you will see a list of your clusters. Click on the cluster for which you want to obtain the identifier.
4.On the cluster details page, you will find the "Cluster Identifier" under the "Cluster Details" section. This is the name of your Redshift cluster.
Step 2: Get the Redshift Cluster Database And User
5.While still on the cluster details page in the AWS Management Console, navigate to the "Configuration" tab.
6.In the "Cluster Database Properties" section, you can find the "Master user name." This is the Redshift cluster database user's name.
Step 3: Create a User with AmazonRedshiftFullAccess Permission Policy
1.Sign in to the AWS Management Console.
2.Navigate to the Identity and Access Management (IAM) console by searching for "IAM" or selecting it from the list of services.
3.In the IAM dashboard, click on "Users" in the left-hand navigation pane.
4.Click the "Add user" button to create a new IAM user.
5.Enter the username for the new IAM user and configure other user details as needed. Then click "Next: Permissions."
6.In the "Set permissions" page, choose "Add user to group" if you have created a group for Redshift access in a previous step. Add the user to this group. If you haven't created a group earlier, you can choose "Attach policies directly" in the "Add permissions" section.
7.In the "Attach permissions policies" section, search for and select the "AmazonRedshiftFullAccess" policy. This policy provides full access to Amazon Redshift.
8.Review the user's configuration to ensure it's accurate. Make sure that you've attached the "AmazonRedshiftFullAccess" policy. Click "Next: Review."
9.Review the user's details and permissions. If everything is correct, click "Create user."
10.The new IAM user is created, and you will see a success message. Make sure to save or download the user's security credentials, including the Access Key and Secret Access Key, and share them securely with the user.
¶ Create AWS Redshift Basic Connection
- In EAConnect, click Create New.
2. Enter the information obtained to set up the connection and click save.
3. Confirm that the connection is active and not Idle.
