AnsweredAssumed Answered

How to send a JMS Message for every row in a stream

Question asked by Jonathan Fisher on Oct 2, 2018
Latest reply on Oct 4, 2018 by Joao Figueiredo

Hey guys! First time user! We're rapidly getting spun up on spoon and already have a transformation job running on a carte server. Props to the great documentation and user interface design!

 

Our transformation is: bulk query salesforce, then insert/update into mysql. We'd like to take the rows that are new inserts or updates and pass the salesforce ID to a JMS Queue. We have the connection to the JMS broker figured out, but it seems that it's getting passed the whole set of rows at once as one giant message. Instead, for each row, we'd like to dispatch a separate message with the salesforce ID as the message body.

 

Can anyone steer us in the right direction? Thank you!

Outcomes