All Products
Search
Document Center

Quick BI:Add an AnalyticDB for MySQL 3.0

Last Updated:Jan 20, 2025

This topic explains how to add an AnalyticDB for MySQL V3.0 data source.

Prerequisites

  • An AnalyticDB for MySQL V3.0 database has been created.

  • You have obtained the username and password for accessing the AnalyticDB for MySQL V3.0 database.

Limits

Only space administrators or developers are permitted to add data sources.

Procedure

  1. Add the whitelist.

    Before connecting to Alibaba Cloud MySQL, add the IP address of Quick BI to the whitelist of AnalyticDB for MySQL V3.0. For more information on how to add to the AnalyticDB for MySQL V3.0 whitelist, see Set a Whitelist.

  2. Log on to the or the international Quick BI console.

  3. Follow the steps shown in the figure below to add a data source.

    1. Navigate to the data source creation interface from the data source creation entry.

    2. Select the Alibaba AnalyticDB for MySQL data source.

      image

    3. Choose the Alibaba AnalyticDB for MySQL V3.0 database version.

      image

  4. Select the engine type you want to connect to and complete the configuration in the Add AnalyticDB for MySQL V3.0 Data Source dialog box.

    • Select the XIHE engine (MPP)

      Name

      Description

      Display name

      The display name in the datasource config list.

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

      Database address

      The public address and port of the deployed Alibaba AnalyticDB for MySQL V3.0. If you use a VPC data source, you must enter the internal address and internal port of the deployed database.

      Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the database address in the connection information. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com

      Port

      The port number of the database. The default value is 3306.

      Database

      The name of the database to be connected.

      Account and password

      The account and password of the database. Make sure that the account has the create, insert, update, or delete permissions on tables in the database.

      VPC data source

      If the database uses the Alibaba Cloud VPC network, select VPC data source and configure the following parameters.

      • Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret that have access privileges to the destination database. Make sure that the account has the Read permission on the destination instance. If the account has the Write permission, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see Create a Custom Policy.

        You can log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. For more information, see Obtain an AccessKey.

      • Instance ID and region: The instance ID and region of the database.

        Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the instance ID and region of the instance.

      Note

      If you select a VPC data source, you must enter the internal address and internal port of the database.

      Initial SQL

      You can select this option to configure initial SQL.

      The SQL statements that are executed to initialize the data source connection. Only SET statements are allowed. Separate statements with a semicolon.

    • Select the Spark engine

      Name

      Description

      Display name

      The display name in the datasource config list.

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

      Database address

      The public address and port of the deployed Alibaba AnalyticDB for MySQL V3.0. If you use a VPC data source, you must enter the internal address and internal port of the deployed database.

      Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the database address in the connection information. Example: am-xxxxxxxxxxxxxxxxxxxx.ads.aliyuncs.com

      Port

      The port number of the database. The default value is 3306.

      Database

      The name of the database to be connected.

      Resource group name

      The name of the resource group in the database.

      Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the resource group name in Cluster Management > Resource Management > Resource Group Management.

      Account and password

      The account and password of the database. Make sure that the account has the create, insert, update, or delete permissions on tables in the database.

      VPC data source

      If the database uses the Alibaba Cloud VPC network, select VPC data source and configure the following parameters.

      • Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey Secret that have access privileges to the destination database. Make sure that the account has the Read permission on the destination instance. If the account has the Write permission, the system automatically adds the whitelist. Otherwise, you need to manually add it. For more information, see Create a Custom Policy.

        You can log on to the RAM console to obtain the AccessKey ID and AccessKey Secret. For more information, see Obtain an AccessKey.

      • Instance ID and region: The instance ID and region of the database.

        Log on to the cloud-native data warehouse AnalyticDB MySQL console to obtain the instance ID and region of the instance.

      Note

      If you select a VPC data source, you must enter the internal address and internal port of the database.

      Initial SQL

      You can select this option to configure initial SQL.

      The SQL statements that are executed to initialize the data source connection. Only SET statements are allowed. Separate statements with a semicolon.

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

    image

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

What to Do next

After creating a data source, you can proceed to create datasets and analyze data.