Skip to main content

Create an AWS Redshift Data Source

NineData supports adding different data source types and environments for unified management. Added data sources can use Database DevOps, Backup and Recovery, Data Replication, and Database Comparison features. This page explains how to add AWS Redshift to NineData.

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.

    server_ip_address

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

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 selector, choose AWS > Cloud Database > Redshift, then configure the fields on the Create Datasource page.

    tip

    If you select the wrong type, click the arrow_down icon at the top of the creation page to choose another data source type.

  4. Configure the data source parameters:

    Parameter
    		Description
    NameEnter a data source name.
    ConnectionSelect a connection method. The current page supports Private Network, IP Address, Gateway, and SSH Tunnel. If you already created a private-network connection, you can select it first.
    Private network connectionIf you select Private Network as the connection method, select a private-network connection that you created previously.
    Connection methodThe current value is Connection Address.
    Connection addressEnter the Redshift connection address and port. The console default port is 5439.
    Authentication databaseEnter the database name used for authentication. The console default prompt is dev.
    DB AccountEnter the database login username.
    DB PasswordEnter the database login password.
    Access RegionSelect the access region closest to the instance.
    EnvironmentSelect the environment for the data source, such as production or development.

  5. After configuring the fields, click Connection Test to test connectivity. After the test succeeds and the page displays Connection Successfully, click Create Datasource to create the data source.