Data Connection to AnalyticDB

Version

Function Description

This document introduces how to connect to the Alibaba Cloud AnalyticDB database.

Database Version and Driver

Data connection URL format: jdbc:mysql://Host name:Port number/Database

Preparation

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

• IP address and port number of the server where the database is located

• Username and password of the database

• Schema of the database to be connected

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

2. Select the Alibaba Cloud AnalyticDB database, as shown in the following figure.

3. Enter the connection information collected in the "Preparation" section, as shown in the following figure.

Note:

You can modify other advanced settings on the page as needed. For details, see the "Advanced Settings" section 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 value in the limit clause in an SQL statement exceeds 10,000, the overlimit error will be reported. The maximum records of data for the database is 10,000 by default. You can change the value by modifying the configuration on the AnalyticDB for SQL (ADS) database server.

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

3. SQL statements containing TOP N are not supported.