Comment on page
Example
An example Data Stream that demonstrates how to use this Listener to return new city records being inserted into a MySQL database table
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.

File | Link | Security Key |
---|---|---|
Data Stream | MySQL Listener Example.xuc | C0mp|ex123 |
Last modified 1yr ago