topic Re: How to poll a database continously using talend in Talend Studio

How to poll a database continously using talend

Anonymous — Tue, 23 Oct 2012 15:17:57 GMT

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 ?

Re: How to poll a database continously using talend

_AnonymousUser — Tue, 23 Oct 2012 15:27:38 GMT

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

Re: How to poll a database continously using talend

Anonymous — Tue, 23 Oct 2012 15:44:38 GMT

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.

Re: How to poll a database continously using talend

_AnonymousUser — Tue, 23 Oct 2012 16:43:18 GMT

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

Re: How to poll a database continously using talend

_AnonymousUser — Tue, 23 Oct 2012 16:45:07 GMT

Tutorial Link
http://www.talendforge.org/tutorials/tutorial.php?idTuto=42#s10