Integration with CipherTrust Manager

This section helps you with the setup required to create a key and a user in CipherTrust Manager. Ensure that:

• NAE interface has already been setup.

• The user created must have the required access to export the key. This user is also provided as an environment variable for the function.

• CADP_for_JAVA.properties file is updated with the CipherTrust Manager settings such as IP or NAE Port. The file is located in the resource directory in the eclipse project.

These properties can also be overwritten with CADP code as well if your desire is to pass them in as environment variables. Here is an example:

System.setProperty("com.ingrian.security.nae.NAE_IP.1", "10.x.x.x");

The example provided have the key as a hardcoded value, but this can be altered to be provided as an environment variable, obtained from a secrets manager.

When all the above steps are performed, execute a query within a session that has already defined the function.

Here is a sample query running in a databricks notepad cell using one of the UDFs.

select ThalesencryptCharUDF(c_name) as enc_name, c_name from samples.tpch.customer limit 50