After you pull data from a computing source, the data is imported into an analysis source. Data is then fetched directly from this analysis source for insight analysis.
Quick Audience currently supports Hologres or AnalyticDB for MySQL (ADB) 3.0 as an analysis source. You can connect to only one analysis source.
Hologres is recommended because it is more cost-effective.
Add Hologres
Quick Audience supports only Hologres V1.1.49 or later. If your version is earlier than 1.1.49, submit a ticket to request an upgrade.
Procedure to add Hologres:
Go to Workspace > Configuration Management > Data Access Management > Data Source > Analysis Source.
Click New Analysis Source in the upper-right corner.
In the dialog box that appears, select Hologres.
Configure the parameters as described in the following table.
Parameter
Description
Display name
Enter a display name for the analysis source.
Database Address
Enter the public endpoint of the analysis source. For more information, see Endpoint.
Port
Enter the public port number.
Database
Enter the name of the database to connect to.
Schema
Enter the schema of the database. The default value is public.
Username
Enter the AccessKey ID of the Hologres user.
NoteThe user can be an Alibaba Cloud account or a RAM user. For an Alibaba Cloud account, obtain the AccessKey ID and AccessKey secret from the Resource Access Management (RAM) console. If you use a RAM user, record the AccessKey when you create the user.
A Resource Access Management (RAM) user must be authorized. You can grant the Developer permission using the simple permission model, or grant permissions equivalent to the Developer permission using the expert permission model. For more information, see Grant a RAM user developer permissions for an instance.
Password
Enter the AccessKey secret that corresponds to the AccessKey ID.
Log on to the Hologres console and add the Quick Audience IP address, which is displayed on the page, to the whitelist. This allows Quick Audience to access the analysis source cluster. For more information, see IP Whitelist.
In the Hologres instance, grant the user permission to export data to OSS. To obtain the required authorization statement, click simple permission model or standard PostgreSQL authorization model in the figure above, depending on which Hologres permission model you use. For more information about authorization, see Export data to OSS.
Click Test Connection to verify the connection to the analysis source.
If the test fails, a message is displayed. Modify the configuration accordingly.
If the connection test is successful, click Add to complete the configuration.
Add ADB 3.0
Quick Audience supports only AnalyticDB for MySQL 3.0 V3.1.4.12 or later. To check the version of your AnalyticDB for MySQL 3.0 instance, see How to view the kernel version of an AnalyticDB for MySQL cluster. If your version is earlier than 3.1.4.12, submit a ticket to request an upgrade.
AnalyticDB for MySQL 3.0 instances in the China (Qingdao) region are not supported. The AnalyticDB for MySQL 3.0 instance and your MaxCompute project must be in the same region. If you use OSS for features such as creating audiences by calling an API, the OSS bucket and the AnalyticDB for MySQL 3.0 instance must also be in the same region.
Enterprise Edition and Basic Edition are supported. Data Lakehouse Edition and Data Warehouse Edition are not supported.
Procedure to add ADB 3.0:
Go to Workspace > Configuration Management > Data Access Management > Data Source > Analysis Source.
Click New Analysis Source in the upper-right corner.
In the dialog box that appears, select AnalyticDB for MySQL 3.0.
Configure the parameters as described in the following table.
Parameter
Description
Display name
Enter a display name for the analysis source, for example, XX_purpose_ADB3.0.
Region
Select the region where the analysis source is located.
Database Address
Enter the public endpoint of the analysis source. For more information, see Request and release a public endpoint.
Port
Enter the public port number.
Database
Enter the name of the database to connect to.
Account
Enter the database user account.
NoteThis account can be a privileged account or a standard account. A standard account must be granted all permissions on the database. For more information, see Quick Start for Data Warehouse Edition.
Password
Enter the password for the account.
Log on to the AnalyticDB for MySQL console and add the Quick Audience IP address, which is displayed on the page, to the whitelist. This allows Quick Audience to access the analysis source cluster. For more information, see Whitelist.
Click Test Connection to verify the connection to the analysis source.
If the test fails, a message is displayed. Modify the configuration accordingly.
If the connection test is successful, click Add to complete the configuration.
Manage analysis sources
After you add an analysis source, you can search for it by name in the search box.
You can also edit or remove an analysis source, or view the column information of its data tables:
Click the
icon to edit the analysis source. You can modify only the display name, username, and password.Click the
icon and confirm the deletion to remove the analysis source.Click the
icon for a table to view its column information.
icon to edit the analysis source. You can modify only the display name, username, and password.
icon and confirm the deletion to remove the analysis source.
icon for a table to view its column information.