Supports connecting to MySQL databases to create datasets.
This section describes two methods for creating a data connection.
(1) Go to BytePlus, select a specific project, click Data Preparation, find Data Connection in the dropdown list, and click Data Connection.
(2) On the page, select the MySQL connection.
(3) Enter the required basic information, test the connection, and click Save after the connection is successful.
(4) After confirming that the basic information of the data connection is correct, the data connection is complete.
(5) This connection can be used as a data source to create a dataset: click Data Preparation --> Dataset, and click the "Create" button in the upper left corner to create a new dataset.
(6) Search or scroll through existing connections and select the previously created data source.
(1) Go to BytePlus, click Data Preparation --> Dataset, and click the "Create" button in the upper left corner to create a new dataset.
(2) When selecting a data connection, click Create Configuration.
The subsequent steps are the same as steps (2) and (3) in 2.1. After the upload is complete, you will remain on the pop-up window for selecting a data connection for the dataset, and you can proceed directly to the next step of dataset creation.
Name | Description |
|---|---|
Data connection name | The name of the new data connection, used to distinguish connections to different databases in the system. For example, MYSQL. |
Server | The IP address where the MySQL database is deployed. |
Port | The instance port of MYSQL. |
Username | The username for accessing the MYSQL database. To obtain it, contact the operations personnel of the corresponding engine. |
Password | The password for accessing the MYSQL database. To obtain it, contact the operations personnel of the corresponding engine. |
Permission mode | Supports both read and write modes. |
vpcMode | This option supports two values: yes or no. If the database you want to connect to is BytePlus RDS or a self-hosted MySQL service on BytePlus ECS, and it is in the same region as DataWind, you can use the VPC internal network connection mode to access the database via its private IP address. |
VPC ID | To learn how to obtain the VPC ID, refer to the document "获取数据库 VPC ID" |