topic Re: Which component can continuously listen for new rows in database in Talend Studio

Which component can continuously listen for new rows in database

Adnan2 — Sat, 16 Nov 2024 01:51:30 GMT

I need a mechanism where every time a row is inserted into database (let say SQL database) it is immediately picked up for further processing. Also the status of a column in the row is changed from 0 to 1 signifying that the row has been processed and should not be picked up again. Any help will be appreciated.

Re: Which component can continuously listen for new rows in database

Anonymous — Tue, 21 Jul 2020 07:02:41 GMT

Hello,

Please refer to talend Change Data Capture (CDC). It captures only the changed source data and moves it from a source to a target system(s) in real time.

This feature is available in talend subscription solution.

Best regards

Sabrina

Re: Which component can continuously listen for new rows in database

Anonymous — Tue, 21 Jul 2020 07:11:15 GMT

Take a look at tWaitforSQLData component and let me know if it meets your need.

Regards

Shong

Re: Which component can continuously listen for new rows in database

Adnan2 — Tue, 21 Jul 2020 10:36:57 GMT

Thanks. This may help but requires subscription. Hence not an option for me currently.

Re: Which component can continuously listen for new rows in database

Adnan2 — Tue, 21 Jul 2020 10:37:20 GMT

Thanks a lot. This helps!