Delphix Products

  • 1.  Can Delphix provides the facility to clone only Schema Structure without the data

    Posted 03-20-2017 01:51:00 PM
    As Production data is very confidential, can Delphix gives the facility to get only schema structure. is it possible to do without having initial backup. if yes, please provide the steps to do this.
    #DemoEnvironment


  • 2.  RE: Can Delphix provides the facility to clone only Schema Structure without the data
    Best Answer

    Posted 03-20-2017 04:40:00 PM
    Yes and No.

    Delphix clones databases at the block level.  It is not like an Oracle Export or other dump utilities which create the schema and then slowly populate it with insert statements.  Rather, it virtually copies all the database blocks.

    But we have a Masking product which takes the value out of the production data, allowing you to focus your security dollars on protecting production.  We change the sensitive data into realistic but fake data.

    Our solution to the problem, used successfully by many Fortune 500 customers, is to create a full virtual copy of production in your safe production zone, mask it one time, and distribute it many times to downstream customers in less secure areas (including offshore).  This is much faster and more efficient than "dump and load" or subsetting techniques, and ultimately a lot more useful for developers and testers.  In addition, your production zone Delphix engine can assist with more use cases:  Production break/fix, Business Intelligence/Operational Reporting, and Compliance/Archiving.


  • 3.  RE: Can Delphix provides the facility to clone only Schema Structure without the data

    Posted 03-22-2017 12:43:00 PM
    Hi Ranzo,

    Is there a way Delphix provides to clone few tables from Source Database ?

    Regards,
    Jitendra


  • 4.  RE: Can Delphix provides the facility to clone only Schema Structure without the data
    Best Answer

    Posted 03-22-2017 01:48:00 PM
    Jitender,

    Delphix will capture the entire source database, and it will initially provision the entire database as a VDB, as described by Ranzo above.

    But it is certainly possible to automate the drop of objects and schemas -- except the ones you wish to retain -- in the newly-provisioned VDB as a seamless integrated post-provisioning step, using custom-built programmatic callouts known as "hooks".

    Hope this helps!

    -Tim