Automatically Generate R Keys for Perturbation

If you want to use the Perturbation feature to confidentialise your data, then you need to have R Keys in your unit records. SuperCHANNEL can generate the R Keys automatically when it creates your SXV4.

In some cases, you are recommended to generate the R Keys yourself in the unit records. See How It Works for more details about the situations where the automatic functionality can be safely used.

To enable this feature:

1. In the Target View, select the very top item (the database):

   

2. In the toolbar, click the Attributes icon to display the Target Attributes pane on the left.

3. Select the Generate Rkey Automatically check box.

   

Now that you have enabled the feature, you need to edit the Rkey Generation settings for each of your fact tables.

For each fact table in your database, do the following:

1. In the Target View, select the fact table.

2. In the Target Attributes pane, enter values for the two new options that are now available: Rkey Seed and Rkey Generator:

   

   • Rkey Seed is the seed value to use when generating the R Keys.
   • Rkey Generator is the module used to generate the R Keys. If you want to use the generator supplied with SuperCHANNEL, set this to str.database.rkey.SecureRandomRkeyGenerator. Alternatively, you can provide your own generator. See Using a Custom R Key Generator for more details on this option.
3. Repeat these steps for any other fact tables in your database.

It is also possible to configure the R Key settings in your registry tables. See FACTS for details.