I need some explanations about ESB patterns design. I have followed all the Talend Academy training paths related to API Services but it’s still not clear for me.
As a training, I have rapidly created a REST Web Service to interface a local MariaDB database (see attached Job screenshot). To pass the answer to a route (see attached Route screenshot), the REST answer is written to a XML file. In the route, XML file creation/modification is detected by using cMessengingEndpoint and the body is passed to a Message Broker in the order to be share potentially with other systems.
Is it the right way to detect change perform on the source (here the database)? In general, how events are detected and caught in systems like ERP or CRM? Directly with triggers configured in the different systems? In our case, is it possible to use cMessengingEndpoint (or another component) to catch directly REST events without using XML file?
