Smartbi

Prerequisites

Before you begin, make sure you have:

• Smartbi V8.5 or later installed

• An AnalyticDB for MySQL cluster. See Create a cluster

• The Smartbi server's IP address added to the cluster's IP address whitelist. See Configure a whitelist

• (Optional) A public endpoint, if Smartbi and the cluster are in different zones. See Apply for or release a public endpoint

Choose your connection type

The hostname in your JDBC connection string depends on how Smartbi reaches your cluster:

To find the endpoint and port, go to the Network Information page and check the Cluster Information section.

Connect Smartbi to AnalyticDB for MySQL

1. Start Smartbi.

2. Click the icon in the left-side navigation pane, or click Data connection in the right-side menu.

   

3. On the All tab of the Data connection page, click Aliyun AnalyticDB.

   

4. On the Create Relational datasources page, configure the connection parameters.

   

   Parameter	Description
   Name	A unique name for this data source
   Alias	(Optional) A display name for this data source
   Driver type	Select aliyun AnalyticDB
   Driver storage directory	Select Built-in product
   Driver Class	Default value: com.mysql.jdbc.Driver. Leave this unchanged.
   Connection string	The JDBC connection string for your cluster. See the format below.
   Username	The account used to connect to the cluster
   Password	The password for the account

   Connection string format:

   jdbc:mysql://<hostname>:<port>/<database>?useUnicode=true&characterEncoding=UTF-8&engine=MPP

   Replace the placeholders with your actual values:

   Field	Description	Example
   <hostname>	The VPC or public endpoint of your cluster	am-xxxx.ads.aliyuncs.com
   <port>	The cluster's port number. Default is 3306.	3306
   <database>	The name of the database in your cluster	my_database
   useUnicode=true&characterEncoding=UTF-8	Character encoding settings. Leave unchanged.	—
   engine=MPP	Specifies the Massively Parallel Processing (MPP) query engine. Leave unchanged.	—

5. Click Test connection(T). In the message that appears, click OK(O).

   

6. Click Save(S) in the lower-right corner.

After saving, you can manage your cluster databases from within Smartbi. In the left-side navigation pane, choose Data connection > adb > Database Management(S) to add resources to the database. For details, see Database management.

What's next

With the connection established, use Smartbi to query, analyze, and visualize data from your AnalyticDB for MySQL cluster. For full Smartbi documentation, see Smartbi documentation.