topic Re: Streaming queue into database / Job connect with Route ? in Talend Studio

Streaming queue into database / Job connect with Route ?

Anonymous — Sat, 16 Nov 2024 09:45:05 GMT

Trying a PoC to get data from a RabbitMQ and write into database. I can get messages out of a Queue via Route into a file and a job insert data from file into DB. Is it possible to to connect them together? Or is there a way to implement this in either job or route alone?

Thanks!

Re: Streaming queue into database / Job connect with Route ?

TRF — Mon, 22 May 2017 15:25:21 GMT

Maybe https://community.talend.com/t5/Design-and-Development/Talend-and-RabbitMQ/td-p/65083 could help you (thank's to @vapukov for the original answer)

Re: Streaming queue into database / Job connect with Route ?

Anonymous — Mon, 22 May 2017 15:25:23 GMT

Hi,

From CmessagingEndpoint1, you can trigger a onSubjob ok to the InputFile.

Is this what you meant?

You can use tHashOutput and tHashInput components Instead of files.

Cheers!

Re: Streaming queue into database / Job connect with Route ?

Anonymous — Mon, 22 May 2017 16:12:39 GMT

I was on that page when trying to get rabbitMQ to work, forgot about the thread has connection to DB as well.

Added a cTalendJob to take care of db insert and it's now working. Thanks!