Which component can continuously listen for new rows in database

[Adnan2]

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.

[Anonymous]

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

[Anonymous]

Hi

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

Regards

Shong​

[Adnan2]

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

[Adnan2]

Thanks a lot. This helps!