This topic was translated by AI and is currently in queue for revision by our editors. Alibaba Cloud does not guarantee the accuracy of AI-translated content. Request expedited revision

Add an AnalyticDB for MySQL 2.0

Updated at: 2025-01-20 09:12

Connect your Alibaba Cloud AnalyticDB for MySQL 2.0 database with Quick BI by adding it as a data source. Once connected, you can perform data analysis and visualization within Quick BI. Quick BI facilitates connections to Alibaba Cloud AnalyticDB for MySQL 2.0 over the Internet. This topic guides you through the process of adding an Alibaba Cloud AnalyticDB for MySQL 2.0 data source.

Prerequisites

  • You must have an AnalyticDB MySQL cluster created, with the cluster version being 2.0.

  • If you are utilizing the cloud-native data warehouse AnalyticDB MySQL 2.0, you can integrate it with Quick BI for data analysis by adding an AnalyticDB for MySQL 2.0 cloud data source.

Limits

Only space administrators and developers are authorized to add data sources.

Procedure

  1. Log on to the Quick BI console.

  2. Navigate to the data source creation interface using the designated entry point.

    1. Access the data source creation interface.

    2. Choose Alibaba AnalyticDB for MySQL as the data source type.

      image

    3. Select Alibaba AnalyticDB for MySQL 2.0 as the database version.

      image

  3. In the Add Analyticdb For Mysql 2.0 Data Source dialog box, fill in the required configuration details.

    Name

    Description

    Name

    Description

    Select database version

    Select AnalyticDB for MySQL 2.0.

    Display Name

    The display name in the datasource config list.

    The name cannot contain special characters or start or end with spaces.

    Database Address and Port

    The address and port of the classic network where the AnalyticDB for MySQL 2.0 database is deployed.

    Database

    The name of the database to connect to AnalyticDB for MySQL 2.0.

    Accesskey ID and Accesskey Secret

    The AccessKey ID and AccessKey Secret with access privileges to the target AnalyticDB for MySQL 2.0 database.

    Log on to AccessKey Management to obtain the AccessKey ID and AccessKey Secret.

    Initialize SQL

    After enabling, you can configure the SQL statement to be executed after the data source connection is initialized.

    Only SET statements are allowed for the SQL statement executed after each data source connection initialization, separated by periods.

  4. Click Connection Test to verify the data source connectivity.

    image

  5. Once the test is successful, click OK to finalize the addition of the data source.

What to Do next

After the data source is established, you can proceed to create datasets and analyze data.

  • On this page (0, M)
  • Prerequisites
  • Limits
  • Procedure
  • What to Do next
Feedback