Salesforce

How Do I Encrypt Data Inside a Table? (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

How Do I Encrypt Data Inside a Table? (Magic xpa 2.x)

Even when you use passwords and restrict access, it is possible, using low-level tools, to view data directly from a disk. For this reason it is necessary to encrypt tables that contain very sensitive information.

Magic xpa makes this very easy. Just follow the steps below.

Encrypting a database table

  1. In the Data repository, go to the table you want to encrypt.

  2. Go to Data Source Properties (Alt+Enter, or Edit->Properties).

  3. For the Access key, enter any string of characters. It is recommended though, that you use a Secret Name (How Do I Hide Database Login Information?).

  4. Set Encrypt table to Yes.

Now, the data in the table will be encrypted. Only someone who has the same key can view the data.

Note: Not all DBMSs support encrypted data. If underlying the DBMS does not support this form of encryption, then the Access Key and Encrypt table fields will be greyed out.

Reference
Attachment 
Attachment