Talend ESB Route and Context Variables or Property Placeholders

Anonymous — Sat, 16 Nov 2024 02:04:55 GMT

Hi,

I am using Talend ESB, and have been using context variables (with implicit context load from file) in data integration jobs. Now I have created a route to read from RabbitMQ. However, implicit load of context variables does not work.

In the route, I am trying to set the RabbitMQ connection string dynamically, so that I will be able to pass the host, vhost, port, user, password loaded from a file (in the same way I pass connection parameters to MS SQL Server in the data integration jobs).

I am trying to construct the connection string as follows:

"rabbitmq://" + context.RabbitMQ_Host + ":" + context.RabbitMQ_Port + "/DataExchange?vhost=" + context.RabbitMQ_VHost +"&exchangeType=topic&autoDelete=false&queue=Submitted_Record&username="+context.RabbitMQ_User + "&password=" + context.RabbitMQ_Password

The issue is that implicit load of context variables does not work in routes for some reason. (Note that when I set the value of these context parameters hardcoded in Talend, it works).

After searching it seems that I have two options:

1) using a route_name.cfg file in the MyDrive:\TOS_ESB-20200219_1130-V7.3.1\Runtime_ESBSE\container\etc folder - I tried this but the parameters are not being picked up when I run the job for some reason

2) using property placeholders and modifying the Spring XML to load values from a file and use them at runtime

I have also found links to what others said was a very useful post (https://edwardost.github.io/cloud/platform/soa/2015/05/14/Working-with-Property-Placeholders-in-Talend-ESB/) but this seems to have been removed unfortunately.

I would really appreciate if someone can help me out please as I am stuck on this. Unfortunately I do not have much Java and Spring experience and I couldn't manage to figure this out.

Any help and pointers would be greatly appreciated.

Many thanks,

David

topic Talend ESB Route and Context Variables or Property Placeholders in Talend Studio

Talend ESB Route and Context Variables or Property Placeholders