ApsaraMQ for Kafka:Create AnalyticDB sink connectors

Step 1: Create AnalyticDB resources

Create AnalyticDB for MySQL or AnalyticDB for PostgreSQL resources.

• If you want to export data to an AnalyticDB for MySQL table, you must create a cluster, a database account, and a database, and connect to the cluster in the AnalyticDB for MySQL console. For more information, see Create a cluster, Create a database account, Connect to an AnalyticDB for MySQL cluster, and Create a database.

• If you want to export data to an AnalyticDB for PostgreSQL table, you must create an instance and a database account, and connect to the database in the AnalyticDB for PostgreSQL console. For more information, see Create an instance, Create a database account, and Client connection.

In this topic, an AnalyticDB for PostgreSQL database named abd_sink_database and a data table named abd_sink_table are created.

Step 2: Create and start an AnalyticDB sink connector

1. Log on to the ApsaraMQ for Kafka console. In the Resource Distribution section of the Overview page, select the region where the ApsaraMQ for Kafka instance that you want to manage resides.

2. In the left-side navigation pane, choose Connector Ecosystem Integration > Tasks.

3. On the Tasks page, click Create Task.

   • Task Creation

     1. In the Source step, set the Data Provider parameter to ApsaraMQ for Kafka and follow the on-screen instructions to configure other parameters. Then, click Next Step. The following table describes the parameters.

        Parameter	Description	Example
        Region	The region where the ApsaraMQ for Kafka instance resides.	China (Beijing)
        ApsaraMQ for Kafka Instance	The ApsaraMQ for Kafka instance in which the messages that you want to route are produced.	alikafka_post-cn-jte3****
        Topic	The topic on the ApsaraMQ for Kafka instance in which the messages that you want to route are produced.	topic
        Group ID	The ID of the group on the ApsaraMQ for Kafka instance in which the messages that you want to route are produced. Quickly Create: Create a new group. Use Existing Group: Select a created group.	GID_http_1
        Consumer Offset	The offset from which messages are consumed.	Latest Offset
        Network Configuration	The type of the network over which you want to route messages.	Basic Network
        VPC	The ID of the virtual private cloud (VPC) in which the ApsaraMQ for Kafka instance is deployed. This parameter is required only if you set the Network Configuration parameter to Self-managed Internet.	vpc-bp17fapfdj0dwzjkd****
        vSwitch	The ID of the vSwitch with which the ApsaraMQ for Kafka instance is associated. This parameter is required only if you set the Network Configuration parameter to Self-managed Internet.	vsw-bp1gbjhj53hdjdkg****
        Security Group	The security group to which the ApsaraMQ for Kafka instance belongs. This parameter is required only if you set the Network Configuration parameter to Self-managed Internet.	alikafka_pre-cn-7mz2****
        Messages	The maximum number of messages that can be sent in each function invocation. Requests are sent only when the number of messages in the backlog reaches the specified value. Valid values: 1 to 10000.	100
        Interval (Unit: Seconds)	The time interval at which the function is invoked. The system sends the aggregated messages to Function Compute at the specified time interval. Valid values: 0 to 15. Unit: seconds. The value 0 specifies that messages are sent immediately after aggregation.	3

     2. In the Filtering step, define a data pattern in the Pattern Content code editor to filter requests. For more information, see Event patterns.

     3. In the Transformation step, specify a data cleansing method to implement data processing capabilities such as splitting, mapping, enrichment, and dynamic routing. For more information, see Data cleansing.

     4. In the Sink step, set the Service Type parameter to AnalyticDB and follow the on-screen instructions to configure other parameters. Then, click Save. The following table describes the parameters.

        Parameter	Description	Example
        Instance Type	The type of the instance that you created. In this example, AnalyticDB for PostgreSQL is selected. Valid values: AnalyticDB for MySQL AnalyticDB for PostgreSQL	ApsaraDB RDS for PostgreSQL
        AnalyticDB for MySQL Instance ID	The ID of the AnalyticDB for PostgreSQL instance that you created.	gp-bp10uo5n536wd****
        Database Name	The database that you created.	abd_sink_database
        Table Name	The table that you created.	abd_sink_table
        Database Username	The username that is used to access the database account.	user
        Database Password	The password that is used to access the database account.	******
        Network Settings	VPC: Messages in ApsaraMQ for Kafka are delivered to AnalyticDB in a virtual private cloud (VPC). Internet: Messages in ApsaraMQ for Kafka are delivered to AnalyticDB over the Internet.	Internet
        VPC	The VPC ID. This parameter is required only if you set the Network Settings parameter to VPC.	vpc-bp17fapfdj0dwzjkd****
        vSwitch	The vSwitch. This parameter is required only if you set the Network Settings parameter to VPC.	vsw-bp1gbjhj53hdjdkg****
        Security Group	The security group. This parameter is required only if you set the Network Settings parameter to VPC.	test_group

4. Go back to the Tasks page, find the OSS sink connector that you created, and then click Enable in the Actions column.

5. In the Note message, click OK.

   The connector requires 30 to 60 seconds to be enabled. You can view the progress in the Status column on the Tasks page.

Step 3: Test the AnalyticDB sink connector

1. On the Tasks page, find the AnalyticDB sink connector that you created and click the name of the source topic in the Event Source column.

2. On the Topic Details page, click Send Message.

3. In the Start to Send and Consume Message panel, configure the parameters based on the following figure and click OK.

   Note

   In this example, the message content is a JSON string that contains all columns of the created data table. The system writes the values of the fields that have the same names as the columns in the data table to the corresponding columns.

   

4. On the Tasks page, find the AnalyticDB sink connector that you created and click the name of the destination instance in the Event Target column.

5. In the upper-right corner of the Basic Information page, click Log on to Database.

6. In the Data Management (DMS) console, execute the following statement to query all data in the table:

   SELECT * FROM  abd_sink_table;

   The following figure shows the query result.