When you pull data from a computing source, the data integrated by the computing source is imported to the analysis source. When you use the data for insight analysis, the data is directly obtained from the analysis source.
Quick Audience allows you to connect to Hologres or AnalyticDB for MySQL 3.0.
Hologres is preferred for recommend and costs are lower.
Add ADB 3.0
Quick Audience only supports access to ADB 3.0 versions 3.1.4.12 and above. You can refer to How do I query the minor version of an AnalyticDB for MySQL cluster to check the version of ADB 3.0 instance. If the version is lower than 3.1.4.12, please Submit A Ticket to initiate the upgrade.
You cannot connect to ADB3.0 in the China (Qingdao) region. We recommend that you connect to ADB3.0 and MaxCompute in the same region. If you use OSS when you call the API operation to create a crowd, OSS and Analyze B3.0 must be in the same region.
The Enterprise Edition and Basic Edition are supported. The Lake Warehouse Edition and the data warehouse edition are not supported.
To add ADB3.0, perform the following steps:
Choose Workspace> Configuration Management > Data Import Management > Data Sources > Analysis Sources. The Analysis Sources page appears.
In the upper-right corner, click Create Analysis Source.
In the pop-up window, select the AnalyticDB for MySQL 3.0.
Configure the parameters, as shown in the following table.
Item
Example value
Name
Enter the display name of the analysis source, for example: XX Usage_ADB3.0.
Regions
Select the region where the analysis source resides.
Database Address
Enter the public endpoint of the analysis source. See Apply for or release a public endpoint.
Port
Enter the public port number.
Databases
The name of the ApsaraDB RDS database to be accessed by Realtime Compute.
Username
Enter the account of the database user.
NoteThe account can be a privileged account or a standard account. The standard account must be granted all permissions on the database. For more information, see Getting started with Data Warehouse Edition.
Password
Enter the password that is paired with the account.
Log on to the AnalyticDB Console and add the CIDR blocks of Quick Audience to the whitelist to allow Quick Audience to access the source cluster. For more information, see IP address whitelists.
Click Test Connectivity to test the connectivity of the analysis source.
If the test fails, you will be prompted that the test failed. Modify the configuration.
After the connectivity test is passed, click Add.
Add a Hologres data source
Quick Audience supports only Hologres versions later than 1.1.49. If the Hologres version is earlier than 1.1.49, Submit A Ticket.
To add a Hologres file, perform the following steps:
Choose Workspace> Configuration Management > Data Ingestion Management > Data Sources > Analysis Sources. The Analysis Sources page appears.
In the upper-right corner, click Create Analysis Source.
In the pop-up window, select the Hologres.
Configure the parameters, as shown in the following table.
Parameter
Guide
Name
Enter the display name of the analysis source.
Database Address
For more public endpoint, see Endpoints for connecting to Hologres.
Port
Enter the public port number.
Databases
The name of the ApsaraDB RDS database to be accessed by Realtime Compute.
Schema
The schema of the database. Default value: public.
The username.
Enter the AccessKey ID of the Hologres user.
NoteThe user can be an Alibaba Cloud account or a RAM user. You can obtain the AccessKey ID and AccessKey secret of your Alibaba Cloud account from the RAM Console. If you are using a RAM user, you must remember the AccessKey pair when you create the RAM user.
RAM users need to be authorized. You can use the simple permission model to grant the Developer permission to a RAM user, or use the expert permission model to grant the Developer permission to a RAM user. For more information, see Grant Development Permission of Example to RAM user.
Password
Enter the AccessKey Secret that is paired with the AccessKey ID.
Log on to the Hologres Console and add the CIDR blocks of Quick Audience to the whitelist. This way, Quick Audience can access the source Hologres cluster. For more information, see Configure an IP address whitelist.
In the Hologres instance, authorize the user to export data to OSS. You can click Simple permission model or Expert permission model in the Hologres permission models to obtain the authorization statement. For more information, see Export data to OSS.
Click Test Connectivity to test the connectivity of the analysis source.
If the test fails, you will be prompted that the test failed. Modify the configuration.
After the connectivity test is passed, click Add.
Manage analysis source
After you add an analysis source, you can search for an analysis source by name in the search box.
You can edit or remove an analysis source and view the fields of a data table in the analysis source. 
Click the
icon to edit the analysis source. Only the display name, username /account, and password can be modified. Click the
icon to remove the analysis source. Click the
icon corresponding to the table to view the field information of the table.