Skip to main content
Version: 10.3

Encrypt data in Data Stores

To update the database connections for the CT vault, do as follows:

  1. Change the ds.datasource.url property by appending the following: columnEncryptionSetting=Enabled;keyVaultProviderClientId=ClientID;keyVaultProviderClientKey=SecretKey. Use the Client ID and secret key value generated at the step where you created a service principal.

    Example:

    #old value
    ds.datasource.url=jdbc:sqlserver://YOUR_DATABASE_HOST:1433;databaseName=workfusion;schema=ds
         
    #new value
    ds.datasource.url=jdbc:sqlserver://YOUR_DATABASE_HOST:1433;databaseName=workfusion;schema=ds;columnEncryptionSetting=Enabled;keyVaultProviderClientId=YOUR_AZURE_CLIENT_ID;keyVaultProviderClientKey=YOUR_AZURE_SECRET_KEY

  2. Restart CT and the RPA and CT Workers to apply the changes.

tip

For more details on sensitive data encryption, see Encrypt sensitive data and Encrypt Manual Task answers.