Connect AskTable to AnalyticDB for MySQL-AnalyticDB(AnalyticDB)-阿里云帮助中心

AskTable is a data analysis tool powered by artificial intelligence (AI) and natural language processing (NLP). It lets you use natural language to generate queries and retrieve results. AskTable supports multiple data sources, such as MySQL and PostgreSQL, to help you explore and visualize your data. This topic describes how to connect AskTable to AnalyticDB for MySQL.

Prerequisites

You have created an AskTable account and obtained an API key.
The IP address of the server where AskTable is running has been added to the AnalyticDB for MySQL cluster's IP address whitelist.
- For a SaaS deployment, the server IP address is 47.100.25.242. For the latest IP address, see the official AskTable website.
- For a local deployment, use the IP address of your local server, such as the IP address of an Alibaba Cloud ECS instance.

Usage notes

AskTable has a built-in database connection feature. You do not need to manually download or configure a driver.

Procedure

Log in to AskTable.

Click the AskTable Cloud Console link to log in. For a local deployment, use the IP address of the server where AskTable is running (http://<IP_address>:<port_number>) to log in.
In your project space, click Data to open the data management page.
In the navigation pane on the left, click Add Data. In the database section, select AnalyticDB for MySQL.

On the Add Data page, configure the following parameters and then click Add Now.

Parameter	Description
Data name	A custom name for the data source.
Host	AnalyticDB for MySQL AnalyticDB for MySQL cluster. If you use a local deployment of AskTable on an Alibaba Cloud ECS instance, and the instance is in the same VPC as the AnalyticDB for MySQL cluster, use the VPC endpoint. For a SaaS deployment or a local deployment on an on-premises server, use the public endpoint.
Port	The port number. Must be 3306.
Username	AnalyticDB for MySQL AnalyticDB for MySQL cluster.
Password	AnalyticDB for MySQL database account.
Database	AnalyticDB for MySQL AnalyticDB for MySQL cluster.

Analyze data.

After you configure the data source, you can start analyzing data. For example, you can use the intelligent chatbot or create chart visualizations. For more information, see the official AskTable documentation.