Where does Oracle-CDC for SSIS read data from?

[Azaz.Rasool]

Where does 'Oracle-CDC for SSIS' read data from?

Is it from primary DB, Redo log/Archive log?

[Gadi.Farhat]

Hi Azaz,

The Attunity Oracle-CDC for SSIS provides both Bilk and CDC capabilities. The Bulk part is done by accessing the primary Database. As for the CDC part, the Oracle-CDC for SSIS reads the changes both from Archived and online redo logs. While reading from Archived redo logs is done to ensure that changes do not get lost because of the cyclic redo logs switching mechanism, reading from the online redo logs ensures that the CDC process works in online mode and that the changes can be applied to the target immediately after they applied to the backend.


Regards,

Gadi

[Azaz.Rasool]

Gadi,
Thanks for the quick reply ...

What will be the performance impact on Oracle OLTP if we use Attunity Oracle-CDC with SSIS?

we just want to be sure of 2 things:
1. Minimum changes in the current OLTP system
2. Least or no performance impact on the current OLTP system due to CDC

[Gadi.Farhat]

Hi Azaz,

See the following link:

http://www.attunity.com/forums/knowl...host-1340.html


Regards,

Gadi