Cloud Pak for Data

 View Only

  • 1.  Best way to create and push data into a DW - DB2 to SQL Server

    Posted Mon July 13, 2020 10:48 AM
    Hi,

    I need to create a DW getting data from a DB2 database and inserting it in a SQL Server database. It need to be almost realtime.
    One database maybe will be in a cloud and the other one in another cloud.

    Can you guys suggest me what's the best way to do it? What kind of security and best configuration do I have to do to do it?

    Tks!

    Be safe!

    ------------------------------
    Diogo Cezari
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: Best way to create and push data into a DW - DB2 to SQL Server

    Posted Tue July 14, 2020 08:26 AM
    One option:

    IBM InfoSphere Data Replication, specifically Change Data Capture CDC.
    https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/com.ibm.cdcdoc.mcadminguide.doc/concepts/overview_of_cdc.html

    --Sunit

    ------------------------------
    Sunit
    ------------------------------

    Original Message