Data Connection to AnalyticDB

Version

Function Description

This document introduces how to connect to the Alibaba Cloud AnalyticDB data source.

Version/Driver

The data connection URL is in the jdbc:mysql://Host name:Port number/Database format.

Preparation

Before connecting the database, you need to collect the following information:

• IP address and port number of the database server

• Username and password of the database

• Schema of the database to be connected

1. Choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

2. Find the Alibaba Cloud AnalyticDB icon, as shown in the following figure.

3. Enter the connection information collected in section "Connection Information Collection." 

Note:

You can optionally modify other advanced settings on the page. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

1. The SQL statement select * from () limit x is not supported.

If the data volume limit exceeds 10,000, the overlimit error will be reported. The maximum data volume limit for the database is 10,000 by default. You can change the limit value by modifying the configuration on the AnalyticDB for SQL (ADS) database server.

2. If the real-time data is enabled, the distinct count statement is not supported because distinct count cannot be used with group by at the same time.

3. The top N statement is not supported.