Talend route content enrich

[Anonymous]

Hi,

Can anyone please tell me how to enrich the incoming message from a data-store (Oracle database) using Talend ESB mediation route?

Scenario:

1. Consuming messages from ActiveMQ

2. Enrich the message from Xref database table (oracle database tables)

Thanks,

Samuel

[Anonymous · Accepted solution]

Hi Samuel,

There maybe 2 options.

1) Using cMessagingEndpoint with provided a "jdbc:dataSourceName[?options]" as URI. for more details configuration please reference https://camel.apache.org/jdbc.html

2) Using cTalendJob which invoking a Job you created with tDBConnection/tDBInput connecting to Oracle DB

HTH

Xilai