Create a Vastbase Data Source

Add a Vastbase data source to NineData for Database DevOps, backup and restore, data replication, database comparison, and other supported features. This guide covers connection mode, client character set, client time zone, encrypted transmission, 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 you have available data source quota; otherwise, the data source cannot be added. You can check your remaining quota in the NineData Console header.

Procedure

1. Sign in to the NineData Console.

2. Go to Datasource > Datasource.

3. Click the Datasource tab, and then click Create Datasource. In the data source type dialog, choose Self-Managed Database > Relational Database > Massive Database. On the Create Datasource page, configure the parameters 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 it is easy to find and manage later.
   Connection	Select how NineData connects to the data source. The console 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, 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 application needs time fields to be interpreted in a specific time zone, enter the client time zone here, for example, +08:00. If this field is 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	Choose whether to enable SSL-encrypted transmission. After it is enabled, select a connection policy in Encryption Options. The console displays Prefer by default. If the database requires encrypted connections, keep this option enabled and complete the related configuration as prompted.

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 Vastbase.