Securing Data with DGSecure

Using DgSecure to discover and secure sensitive data is fairly straightforward. Using the combined Hortonworks – Dataguise Sandbox and installation steps below, users can discover the following Dataguise security features and functionality:

  • Defining Policy
  • Data Discovery
  • Data Protection (Masking & Encryption for Unstructured/Structured Data)
  • Bulk Decryption


Sandbox System Requirements

  1. 32-bit and 64-bit OS (Linux, Windows XP, Windows 7, Windows 8).
  2. Minimum 6GB memory available for VM, and minimum 10GB disc space
  3. Virtualization enabled on BIOS. VMware Player (Win) or VMware Fusion (Mac) ( OR
  4. Browser: Chrome 25+, IE 9+ recommended. (Dataguise supports IE 10, however it is not supported in the Hortonworks Sandbox environment)

please note – currently the Dataguise Sandbox is combined with the Hortonworks Sandbox for a single download

Step 1: Download the Dataguise / Hortonworks Sandbox & License Key

  1. To access and download the combined Sandbox, please visit
  2. As you will see, there are two parts to the download. First, download the Sandbox. Next, request the license key.
  3. Once you have downloaded the combined sandbox and you have received the license key file, unzip the file ''.
  4. Next, please start the VM (*Hortonworks_Sandbox_2.1*). Click inside the VM and follow the steps on the screen to start it up.

  5. Then, continue on with the below steps.

Step 2: Apply DgSecure License & Sign In

  1. Go to this URL via your browser:
    (Make sure
    your host file from where you are connecting to the DgSecure
    application, is updated with the IP address of the sandbox,
  • Enter username: user1

  • Enter password: Admin123


  1. Click Sign In

  2. Click the license link on the left

  3. Click the browse button on the right in the install license section, and
    point to your downloaded license key and click OK, then click the install button.

    DgSecure is now ready to use for 30 days

    If you experience any issues with the license please email


Step 3. Create Policies, Set up Sensitive Data Discovery Tasks, Run Masking & Encryption Jobs

  1. First, Go to this URL via your browser: Now you are ready to use Dataguise to define a custom policy, discover and protect sensitive data in Hadoop.


  • (To access Hue, go to
    You will use this later when creating structures. Download the two files: payrollSeqStructure.jar and payrollSchema.avsc to your local computer.
    Create Structure for Sequence: Select File: payrollSeqStructure.jar (saved locally). Create Structure for Avro: Select File: payrollSchema.avsc (saved locally)


Vijay kumar tiwari Tiwari
November 17, 2014 at 11:27 pm

how we can do data encryption in dgsecure?

Leave a Reply

Your email address will not be published. Required fields are marked *

If you have specific technical questions, please post them in the Forums

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Try this tutorial with :

These tutorials are designed to work with Sandbox, a simple and easy to get started with Hadoop. Sandbox offers a full HDP environment that runs in a virtual machine.