Get Data Moving 1
Results 1 to 4 of 4

Thread: Where does Oracle-CDC for SSIS read data from?

  1. #1
    Azaz.Rasool is offline Junior Member
    Join Date
    Jun 2009
    Location
    India
    Posts
    4
    Rep Power
    0

    Where does Oracle-CDC for SSIS read data from?

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

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

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    Azaz.Rasool is offline Junior Member
    Join Date
    Jun 2009
    Location
    India
    Posts
    4
    Rep Power
    0
    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

  4. #4
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Azaz,

    See the following link:

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


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •