This article describes how to integrate Gbase 8a jdbc to create a dataset.
Before connecting to the data, contact the database administrator to collect the following information:
SaaS users need to add an allowlist entry in Gbase 8a jdbc by entering the "DataWind public IP for access" in the allowlist settings area, granting this IP address permission to access the Gbase 8a jdbc service. The "DataWind public IP for access" can be viewed at Data Connections Overview.
Go to BytePlus, click to get into a specific project, click Data Preparation, find Data Connection in the dropdown list, and click Data Connection.
Select Gbase 8a jdbc on the page.
The configuration instructions for the SaaS version connection method are as follows:
Parameters | Configuration instructions |
|---|---|
Data connection name | The name of the new data connection, used to distinguish connections to different databases in the system. For example, gbase_8a_jdbc_20250707140533. |
Connection method | IP/Port |
Server | The public network address of gbase_8a_jdbc. For details, refer to Gbase official documentation. |
Port | The instance port of gbase_8a_jdbc. For details, refer to Gbase official documentation. |
Username | The username created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine. |
Password | The password created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine. |
The configuration instructions for the private deployment version connection method are as follows:
Parameters | Configuration description |
|---|---|
Data connection name | Name for the new data connection, used to distinguish connections to different databases in the system. For example, gbase_8a_jdbc_20250707140533. |
Connection method |
|
Server | The public network address of gbase_8a_jdbc. For details, refer to Gbase official documentation. |
Port | The instance port of gbase_8a_jdbc. For details, refer to Gbase official documentation. |
JDBC connection string | JDBC connection string. For details, refer to Gbase official documentation. |
Username | The username created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine. |
Password | The password created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine. |
Go to BytePlus, click Data Preparation --> Dataset, and click the "New" button in the upper left corner to create a new dataset.
When selecting the data connection, click New Configuration.
The subsequent steps are the same as steps 2 and 3 in Create from data connection. After completing the configuration, you will remain in the pop-up window for selecting the data connection for the dataset, where you can proceed directly to the next step of dataset creation.
Use the previously created data connection to create a dataset: click Data Preparation --> Dataset, and click the "New" button in the upper left corner to create a new dataset.
Search for or select from the dropdown the previously created data connection.