Create Vastbase Data Source

NineData supports adding data sources of different types and environments to the console for centralized management. After a data source 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) data source to NineData.

Prerequisites

• 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 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 data source type dialog box, choose Self-Managed Database > Relational Database > Massive Database, and then configure the parameters on the Create Datasource page using the table.

   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. Use a meaningful name so the data source 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 data source 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 data source, 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 data source.

Result

After the connection test succeeds and you create the data source, it appears in the data source list. You can use it in NineData features that support this data source type.