Create an AWS Redshift Data Source

Add an AWS Redshift data source to NineData for Database DevOps, backup and restore, data replication, database comparison, and other supported features. This guide covers connection mode, private connection settings, credentials, environment settings, and the connection test.

Before you begin

• The server IP address of NineData has been added to the data source allowlist. The server IP address can be viewed by selecting the target region in Access Region on the Create Datasource page.

  

• Make sure data source quota is available; otherwise, the data source cannot be added. Check the remaining quota in the NineData Console header.

Procedure

1. Sign in to the NineData Console.

2. In the left-side navigation pane, choose Datasource > Datasource.

3. On the Datasource tab, click Create Datasource. In the data source type dialog, choose AWS > Cloud Datasource > Redshift, and then configure the parameters on the Create Datasource page.

   tip

   If you select the wrong type, click the icon at the top of the Create Datasource page to reselect the data source type.

4. Configure the data source parameters:

   Parameter	Description
   Name	Enter a data source name.
   Connection	Select the connection method. The console currently supports Private Network, IP Address, Gateway, and SSH Tunnel. If a private connection has already been created, Private Network is recommended.
   Private Connection	When Private Network is selected, choose the created private connection here.
   Access Method	The current fixed value is Connection Address.
   Connection Address	Enter the Redshift endpoint and port. The default port shown in the console is 5439.
   Authentication Database	Enter the database name used for authentication. The console currently displays dev as the default hint.
   DB Account	Enter the database login username.
   DB Password	Enter the database login password.
   Access Region	Select the access region nearest to the instance.
   Environment	Select the environment tag for the data source, such as Production or Development.

5. After you configure all parameters, click Connection Test next to Create Datasource to test connectivity. When Connection Successfully is displayed, click Create Datasource to create the data source. Otherwise, review the connection settings and run the test again.

Result

After the connection test succeeds and you create the data source, it appears in the data source list. Use it in NineData features that support AWS Redshift.