Send one message per database record to EMS queue

[Gerardo Lopez]

I have a database starting with 20 records and I need to read the database and send on separate message to the queue for each record, so after executing I need to have 20 messages in the queue each containing one of the records in the database.

I am quite new with Tibco and I am not sure on how to approach this, any input will be helpful! Thanks!

[BWCS Team]

You can use JDBC query and map it to a Iterate group with variable list as the output record list from JDBC Query. Inside the group, you can have the Queue Sender and map the current iteration element from the group to the body of the message.