Attunity Oracle-CDC for SSIS was designed to achieve minimal impact on the source system and does not require any additional software to be installed on the Oracle host system. It uses log-based CDC so no additional triggers or tables are added to the database system, and lastly, the agent that reads the logs works remotely so itís processing requirements are not added to the Oracle server. It also moves changes off of the Oracle system and does not maintain any host-resident trail-files or staging areas.

Note that while log-based CDC has the lowest impact on the Oracle source system, it does have some impact due to the need to turn on logging for the captured tables (something you may be doing anyway already). When reading the changes, the Attunity solution uses native Oracle LogMiner functions to capture the changes, so there may be some minor impact on the Oracle database when performing those tasks.