Amazon Redshift Data Source Configuration Guide

Overview

Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse service that supports fast complex analysis on large datasets. By configuring the Amazon Redshift data source, you can achieve data synchronization and integration with other systems, leveraging Redshift's powerful capabilities for data warehousing and analytical needs.

Parameter Configuration

To ensure a successful connection to Amazon Redshift, provide the following information when configuring the data source:

1. Data Source Name: Specify a unique and easily recognizable name for your Redshift data source.
2. JDBC Address: Provide the identifier of your Redshift cluster. Provide the JDBC connection address for Redshift, typically in the format jdbc:redshift://endpoint:port/database. For example, jdbc:redshift://amazon-redshift-endpoint:5439/mydatabase.
3. Username: Provide the username with access to the Redshift database.
4. Password: Provide the password for the specified database user.
5. Database Time Zone: Fill in the server time zone setting of the database. By default, the server uses UTC (Coordinated Universal Time) as the time zone. If the server is in a different time zone, select the corresponding time zone here.
6. Data Source Description (optional): Add descriptive information to help you or other administrators understand the purpose or characteristics of this data source.

Connection Configuration

For connection configuration, you can choose one of the following connection methods:

• Direct Connection: Ensure that the connection information you enter is accessible over the public network. If the source has enabled an IP access whitelist, ensure that the outbound IP address of the data integration service has been added to the whitelist. For specific IP addresses, please contact technical support.

• Via SSH Tunnel: To enhance security, you can choose to connect to Aurora MySQL via an SSH tunnel. Enable this option and provide the following SSH tunnel-related configuration information:

  • SSH Server Address: Provide the IP address or domain name of the SSH server.
  • SSH Port: Specify the port number on which the SSH server is listening, typically 22.
  • Username: Provide the login username for the SSH server.
  • Password: Provide the password corresponding to the SSH server login username.

When setting up the connection, consider the following:

• Security Group Configuration: Ensure that the security group associated with your Redshift cluster allows inbound connections from the IP address of the system initiating the connection.

Notes

• Ensure the security and stability of the AWS Redshift service by appropriately configuring IAM roles and policies.
• Protect your database credentials to prevent unauthorized access.
• Regularly review and rotate database credentials to maintain security.
• When configuring, refer to the relevant AWS Redshift documentation and support resources to ensure accuracy.

Configuration Completion

After configuration is complete, you can select this Amazon Redshift data source in data synchronization tasks to perform data import and export operations.

• Use the "Test Connectivity" feature to verify whether the data source is accessible and whether the configuration information is correct.
• After successful verification, you can continue to read or write data from the Redshift database according to the requirements of the data workflow.

Please ensure that you have read and followed the above guidelines to successfully configure the AWS Redshift data source. If you need further assistance, refer to the relevant Amazon Redshift documentation or contact technical support.