Add an RDS MySQL data source

Prerequisites

• An active RDS MySQL instance with a configured whitelist is required. For more information about creating an instance, see Create an RDS MySQL instance.

• You must have a workspace. For more information, see Create a workspace.

  Note

  After you activate DataV-Note (Intelligent Analysis), the platform provides a default workspace that you can use.

Limitations

DataV-Note (Intelligent Analysis) currently supports three connection methods: public endpoint, internal endpoint, and VPC endpoint.

• Public endpoint: Supports instances in all regions.

• Internal endpoint or VPC endpoint: Supports only instances in the China (Shanghai) region.

Procedure

1. Go to the Data Sources page.

   1. Log on to the DataV-Note console.

   2. In the navigation pane on the left, select your workspace, and then choose Data > Data Sources.

2. Click New Data Connection to create a data source.

3. Configure the data source.

   1. Configure the basic information.

      Specify the name and type for the data source. The following table describes the parameters.

      Parameter	Description
      Data source identifier	A custom name for the data source. The name must be unique within the workspace.
      Data source description	A description of the data source. You can briefly describe its purpose.
      Data source type	Select RDS MySQL.
      Whitelist	To allow DataV-Note (Intelligent Analysis) to access your database, add its IP addresses to the whitelist for your RDS MySQL instance in the RDS MySQL console. For more information, see Set an IP whitelist. Public IP whitelist: On the data source configuration page, find the system IP addresses in the prompt below the Data source type parameter. Internal whitelist/VPC whitelist: Log on to the RDS MySQL console and click the instance ID. In the navigation pane on the left, click Database Connection and locate the CIDR block for your network type. Note If the default whitelist group of the instance contains 0.0.0.0/0, all IP addresses are allowed to access the instance. In this case, you do not need to configure a whitelist.

   2. Configure connection information.

      You connect to the RDS MySQL data source by using its network endpoint.

      Endpoint and port	The public, internal, or VPC endpoint of the database. Public endpoint: The public endpoint of the RDS MySQL instance. You can log on to the RDS MySQL console, click the instance ID, and view the public endpoint and port number in the Database Connection section. Internal endpoint/VPC endpoint: The internal endpoint of the RDS MySQL instance. You can log on to the RDS MySQL console, click the instance ID, and view the internal endpoint and port number in the Database Connection section.
      Database logon information	Enter the Database Name, Username, and Password for the RDS MySQL database that you want to access. You can log on to the RDS MySQL console, click the instance ID, and find the database name and logon credentials in the Account Management and Database Management sections of the navigation pane.
      Enable encrypted connection	Before you enable an encrypted connection, make sure that your database instance supports the SSL protocol. Enabled: Adds sslmode=require and ssl=true to the connection string. Disabled: Adds sslmode=disable and ssl=false to the connection string. Note SSL is a protocol that provides security and data integrity for network communications. sslmode=require encrypts data in transit, whereas sslmode=disable does not. ssl=true enables an SSL-encrypted connection, whereas ssl=false disables it.
      Check connectivity	Specifies whether to automatically test the connection when you create the data source.

4. Verify the connectivity.

   The Check Connectivity option determines whether the system tests the connection between DataV-Note (Intelligent Analysis) and the RDS MySQL data source:

   • Enabled: The system automatically tests the connection.

   • Disabled: The system does not test the data source connectivity. You must test it manually before you can use the data source.

   Note

   After the data source is created, its connection status appears in the data source list. The possible statuses are as follows:

   • Connection normal: Indicates that the data source is available. You can use the data source for subsequent query and analysis operations.

   • Connection failed: DataV-Note cannot access the data source. Click the icon below the data source to run a test. Fix any reported errors.

   • Untested: Click the icon below the data source to test the connectivity. You can use the data source for queries and analysis only after the connection is normal.

5. Click OK to create the data source.

Next steps

After the data source is created, you can perform the following operations as needed:

• Use the data source: Go to the edit page of your project to perform queries and analysis. For more information, see Data Analysis.

  Note

  Only data sources with a Connected status can be used in projects.

• Manage the data source: Perform tasks such as refreshing cached tables or deleting the data source. For more information, see Manage data sources.

References

• If you have questions or suggestions when you use DataV-Note (Intelligent Analysis), contact us.

• For more information about data sources, see Data Source Management.