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 ?
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.
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
