Set encryption parameters for multiple columns

To encrypt columns in a database table, the column-level encryption properties is set for each column individually. CDP provides a setColProps utility that allows you to set encryption parameters for multiple columns of a database table in one go. The setColProps utility is provided in the tools\SetColumnUtility folder of the CDP installer directory.

The utility contains the following files:

• setColProps.properties: The properties file to set the encryption parameters for the columns.

• setColProps_run.bat: The batch file to execute the utility.

• setColProps.jar: The jar file maintaining the logic to set the properties defined in setColPros.properties.

Prerequisite

Java version 1.8.0_101 or higher must be installed on your system.

Steps

1. Set the column-level encryption parameters in the setColProps.properties file. To know more about how to modify the properties file, refer to Sample for setting encryption parameters for multiple columns.

2. Perform either of the step to execute encryption:

   a. Run the setColProps_run.bat file.

   b. Use the java -jar setColProps.jar command.