Configure Amazon Redshift Connection Details

Amazon Redshift is a fully managed cloud data warehousing solution that makes it simple and cost-effective for handling huge volumns of data.

After you save the connection details for Amazon Redshift, you can start using it as a data source in your data pipelines.

The Lazsa Platform offers various options for retrieving database credentials to establish a secure connection. You can either directly provide the credentials within the connection details, where they are securely stored in the Lazsa-managed secret manager. Alternatively, you can choose to retrieve credentials programmatically from your designated secrets management tool.

To configure the connection details of Amazon Redshift, do the following:

Sign in to the Lazsa Platform and click Configuration in the left navigation pane.
On the Platform Setup screen, on the Cloud Platform, Tools & Technologies tile, click Configure.
On the Cloud Platform, Tools & Technologies screen, in the Databases and Data Warehouses section, click Configure.

(After you save your first connection details in this section, you see the Modify button here.)
In the list of available database and data warehouse options, click .

On the RDBMS screen, do the following:

In the Details section, provide the following details:

Field	Description
Name	Give a unique name to your Amazon Redshift configuration. This name is used to save and identify your specific Amazon Redshift connection details within the Lazsa Platform.
Description	Provide a brief description that helps you identify the purpose or context of this Amazon Redshift configuration.

In the Configuration section, provide the following information:

Field	Description
Select RDBMS Subtype	Select Amazon Redshift from the dropdown list.
Host	Specify the host or IP address of the server where Amazon Redshift is running.
Port	Enter the port number on which Amazon Redshift is listening for connections.
Database Name	Provide the name of a specific database within Amazon Redshift that you want to connect to.

Depending on how you want to retrieve the credentials to connect to Amazon Redshift, do one of the following:

Field	Description
Connect using Lazsa Orchestrator Agent	Enable this option to resolve your Amazon Redshift credentials within your private network via Lazsa Orchestrator Agent without sharing them with the Lazsa Platform. Select the Lazsa Orchestrator Agent that you want to use from the list of your configured agents. If you select an agent installed in an Amazon EKS cluster, the secrets management tool AWS Secrets Manager is auto-selected. Provide the name and the key of the secret where you store your Amazon Redshift credentials. If you select an agent installed in an Azure AKS cluster, the secrets management tool Azure Key Vault is auto-selected. Provide the Vault Name and the name of the secret where you store your Amazon Redshift credentials.
Select Secret Manager	Select Lazsa and type your Amazon Redshift username and password. In this case, the user credentials are securely stored in the Lazsa-managed secrets store. Select AWS Secrets Manager. In the Vault Configuration dropdown list, the AWS Secrets Manager configurations that you save and activate in the Vault Configuration section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Secret Name, Username Key, and the Password Key for the Lazsa Platform to retrieve the secrets for Amazon Redshift. Select Azure Key Vault. In the Vault Configuration dropdown list, the Azure Key Vault configurations that you save and activate in the Vault Configuration section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Vault Name, Username Secret, and Password Secret for the Lazsa Platform to retrieve the credential values.

Field

Description

Connect using Lazsa Orchestrator Agent

Enable this option to resolve your Amazon Redshift credentials within your private network via Lazsa Orchestrator Agent without sharing them with the Lazsa Platform.

Select the Lazsa Orchestrator Agent that you want to use from the list of your configured agents.

If you select an agent installed in an Amazon EKS cluster, the secrets management tool AWS Secrets Manager is auto-selected. Provide the name and the key of the secret where you store your Amazon Redshift credentials.
If you select an agent installed in an Azure AKS cluster, the secrets management tool Azure Key Vault is auto-selected. Provide the Vault Name and the name of the secret where you store your Amazon Redshift credentials.

Select Secret Manager

Select Lazsa and type your Amazon Redshift username and password.

In this case, the user credentials are securely stored in the Lazsa-managed secrets store.
Select AWS Secrets Manager. In the Vault Configuration dropdown list, the AWS Secrets Manager configurations that you save and activate in the Vault Configuration section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Secret Name, Username Key, and the Password Key for the Lazsa Platform to retrieve the secrets for Amazon Redshift.
Select Azure Key Vault. In the Vault Configuration dropdown list, the Azure Key Vault configurations that you save and activate in the Vault Configuration section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Vault Name, Username Secret, and Password Secret for the Lazsa Platform to retrieve the credential values.

Use a secure connection (SSL)?
This toggle allows you to enable or disable a secure connection using SSL (Secure Sockets Layer) for communication between the Lazsa Platform and Amazon Redshift. Enabling SSL enhances the security of data transmission by encrypting the communication channel.
JDBC Connections String Options
JDBC (Java Database Connectivity) is a Java-based API that enables a client to interact with relational databases. The JDBC Connection String is a URL-like string that provides the necessary details for establishing a connection to Amazon Redshift.
Click Test Connection to validate whether you have configured the correct connection details and you can connect to Amazon Redshift successfully.
Secure configuration details with a password
To password-protect your Amazon Redshift connection details, turn on this toggle, enter a password, and then retype it to confirm. This is optional but recommended. When you share the connection details with multiple users, password protection helps you ensure authorized access to the connection details.
Click Save Configuration. The configured connection details, you can see the configuration listed on the Databases and Data Warehouses screen.

Sample Connection Details Configured for Amazon Redshift: