MySQL
Home
Contact Support
Search…
MySQL
LIstener
Example
Configuration
Release Notes
Context Provider
Example
Configuration
Release Notes
Action Agent
Example
Configuration
Release Notes
Powered By
GitBook
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.
Previous
MySQL
Next - LIstener
Configuration
Last modified
3mo ago
Copy link