Create Vastbase Datasource

NineData supports adding data sources of different types and environments to the console for centralized management. After a datasource is added, you can use features such as Database DevOps, Backup and Restore, Data Replication, and Data Comparison. This topic describes how to add a Massive Database (Vastbase) datasource to NineData.

Prerequisites

• The server IP address of NineData has been added to the data source allowlist. Please refer to the image below for instructions on how to obtain the server IP address.

  

• Make sure you have available data source quota; otherwise, the data source cannot be added. You can quickly check your remaining quota at the top-right corner of the NineData console.

Procedure

1. Log 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 datasource type dialog box, choose Self-Managed Database > Relational Database > Massive Database, and then configure the parameters on the Create Datasource page according to the following table.

   tip

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

4. Configure the datasource parameters:

   Parameter	Description
   Name	Enter a datasource name. Use a meaningful name so that the datasource can be easily identified later.
   Connection	Select the connection method. The console currently supports IP Address, Gateway, and SSH Tunnel.
   Configuration for IP Address	Host: Enter the public address and port of the Vastbase instance. The default port shown in the console is 5432.
   Configuration for Gateway	Gateway: Select an onboarded datasource gateway. Host: Enter the Vastbase address and port in the gateway network. If the database is deployed on the gateway host itself, you can enter localhost.
   Configuration for SSH Tunnel	Enter the public address, port, authentication method, login username, and password or private key file for the tunnel host first. After the tunnel is ready, enter the target Vastbase address and port.
   DB Account	Enter the database login username.
   DB Password	Enter the database login password.
   client character set	If the client character set is different from the server character set, enter the client character set here, for example, UTF8.
   client timezone	If your business needs time fields to be interpreted in a specific time zone, enter the client time zone here, for example, +08:00. If left empty, the database system time zone is used by default.
   Access Region	Select the access region nearest to the database instance to reduce network latency.
   Environment	Select the environment tag for the datasource, such as Production or Development.
   Encryption	Specifies whether to enable SSL-encrypted transmission. After it is enabled, you can select a connection policy in Encryption Options. The console currently displays Prefer by default. If the database side requires encrypted connections, keep this option enabled and complete the related configuration as prompted.

5. After all parameters are configured, click Connection Test on the right of Create Datasource to test connectivity. When Connection Successfully is displayed, click Create Datasource to finish creating the datasource.