Example

An example Data Stream that demonstrates how to use this Listener to return new city records being inserted into a MySQL database table

This example uses the MySQL world sample database.

Refer to configuration to understand all configuration options of this Agent.

Drag the MySQL Listener Agent onto the canvas, link up the Output Endpoint to the Event Printer, then Save the Data Stream.

Select the Agent and click Configure.

Enter the Server details and Credentials details of the MySQL Server.

Select a Schema, Table and Timestamp Column. Click Apply and Save the Data Stream.

Click Publish

Click Live View to view the output of the Agent.

Insert new rows into the select table in MySQL, an example of SQL Insert statement as below.

INSERT INTO world.city (Name, CountryCode, District, Population) VALUES ('Sydney','AUS','New South Wales', 5312000);
INSERT INTO world.city (Name, CountryCode, District, Population) VALUES ('Melbourne','AUS','Victoria', 5078000);

Observe the output from MySQL Listener Agent.

Files

File	Link	Security Key
Data Stream	MySQL Listener Example.xuc	C0mp|ex123

See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.