Delphix Products

Expand all | Collapse all

What does "Enable Change Data Capture (CDC)" in Provision SQL vDB screen do?

Jump to Best Answer
  • 1.  What does "Enable Change Data Capture (CDC)" in Provision SQL vDB screen do?

    Posted 5 days ago
    Hi everyone,

    Recently I have noticed that a new capability is avaliable in Provision SQL vDB screens.

    I have checked the documentation but no explanation there except a link to Microsoft web site.

    Can any of you used this in SQL vDB provision? What does it do? Does it provide a CDC capability between dSource and vDB?



    Provisioning a SQL Server VDB
    Delphix remove preview
    Provisioning a SQL Server VDB
    This topic describes how to provision a virtual database (VDB) from a SQL Server dSource. You must have already linked a dSource from a source database, as described in Linking a SQL Server dSource or have already created a VDB from which you want to provision another VDB.
    View this on Delphix >




    ------------------------------
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    ------------------------------


  • 2.  RE: What does "Enable Change Data Capture (CDC)" in Provision SQL vDB screen do?
    Best Answer

    Posted 5 days ago
    Hi Rahim,

    CDC allows the capture and record changes made to a SQL database. It records DML operations performed on a source table and then publishes this information to a target table.

    You can get more information on some use cases and  how it works here https://social.technet.microsoft.com/wiki/contents/articles/7726.sql-server-change-data-capture-cdc.aspx

    I think delphix added this feature to extend SQL's VDBs capabilities

    Regards,

    Mouhssine


    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 3.  RE: What does "Enable Change Data Capture (CDC)" in Provision SQL vDB screen do?

    Posted 4 days ago
    Hi @Rahim Cetinel,

    Thanks for pointing this new feature out. @Moushssine Saidi is correct​ in that, as of 6.0.1, we have introduced the ability to pass CDC data from your source to downstream VDBs.

    You can find more detail on this with our release notes. ​

    ------------------------------
    Ross Millenacker
    Senior Product Manager
    Delphix
    ------------------------------