Topic
  • 1 reply
  • Latest Post - ‏2012-06-21T14:29:14Z by MarkCarda
siksha
siksha
1 Post

Pinned topic usage of cdc products -urgent!

‏2012-06-21T12:15:32Z |
I want to use change data capture for infosphere datastage 8.1 with oracle as a source database and ms-sql server as the target database and vice-versa is applicable.could you please help me which ibm change data capture product will be fruitful for the above operation.
i have attached a set of products please let me know which product is highly suitable for windows platform.
Updated on 2012-06-21T14:29:14Z at 2012-06-21T14:29:14Z by MarkCarda
  • MarkCarda
    MarkCarda
    1 Post

    Re: usage of cdc products -urgent!

    ‏2012-06-21T14:29:14Z  
    In the scenario you describe, you would need to have the CDC for Oracle Agent running on the Oracle source (or remote log reading can be setup) and CDC for DataStage would need to be running on the DataStage Server. If you also need to capture changes from SQL Server you would also need the CDC for SQL Server running on the SQL Server box to capture changes and send them to DataStage.

    In this scenario, if DataStage is going to be the only target, IBM offers a package called Change Data Delivery for DataStage that includes unlimited sources and is licensed based on the size of the DataStage server. With this license though, DataStage can be the only target from CDC, but obviously can deliver data to both Oracle and SQL Server.

    If you need any further information please feel free to email me at mscarda@us.ibm.com.

    Thank you,
    Mark