Skip to main content
Delphix

Defining XML Data in a CLOB (KBA1016)

 

Prerequisites

To define XML Data you either need access to FTP/SFTP or you need to contact Delphix Support to assist in creating the file on the local file system.

To Define XML Data in a CLOB

To define an XML schema in the masking engine: 

  1. Import File Format
    1. Save a sample of the XML to an XML file, i.e. sample.xml, and make sure it is well-formed.
    2. Open the Masking Engine.
    3. Navigate to Settings, select File Format, and click Import Format.
      Fill in details.
    4. Click Browse for the file and import the XML file created.
      The engine knows how the XML structure, you can define the XML schema to your CLOB in the Inventory screen.
  2. Update Inventory to the the imported XML schema
    1. Go to the Inventory screen and select the Rule Set and table with the CLOB.
    2. Click on Edit on the CLOB containing the XML.
    3. In the Edit Properties screen and in the dropdown User Defined Data Type (at the bottom) select XML Content from file format.
    4. Another dropdown opens called XML formats. (select the file you imported in Step 3 above)
    5. Click Save.

You are now ready to define the masking algorithms to your fields in the XML.