How to poll a database continously using talend

One Star

How to poll a database continously using talend

Hi,
We have a requirement for a real time data integration where we need to poll the database continoulsy instead of scheduling it as a batch job.
I checked for various parameters in the tOracleInput node, but there weren't any parameter for polling.
Is there any other how it could be acheived ?
One Star

Re: How to poll a database continously using talend

Hi,
Are we talking about Change Data Capture (CDC)?
-
Sangi
One Star

Re: How to poll a database continously using talend

Yes, The DB will be updated with new records on real time and whenever the record is inserted, we need to read all these records immediately and process them.
One Star

Re: How to poll a database continously using talend

Hi,
If you have commercial version, create CDC under DB Connections>Connection>CDC Foundation.
You can create the events on the table like 'inserts,deletes and updates'.
Have a look at this link
-
Sangi
One Star

Re: How to poll a database continously using talend