Release Notes
Product Description
CipherTrust Database Protection for MSSQL (formerly known as ProtectDB for MSSQL) delivers powerful protection for the sensitive corporate and customer information stored in databases. With CDP, you have the flexibility to encrypt data at the column-level within databases, at the application layer, and during batch-driven data transformation and transaction processes.
This document may at times abbreviate CipherTrust Database Protection for MSSQL to CDP and CipherTrust Manager to Key Manager.
Release Description
This release includes enhancements.
Enhancements
Upgraded OpenSSL version to 3.0.
Support of MSSQL SERVER 2022.
Resolved Issue
No resolved issue in this release.
Known Issues
The following issues are known to exist in the product at the time of release.
| Reference | Synopsis |
|---|---|
| KY-109133 | When setting or updating column encryption properties, the IV column name is validated even if the IV type is set to column level. Workaround: 1&mbull; Take the backup of metadata table ING_ENCRYPTED_COLUMN. 2&mbull;Run the following query from the metadata database: UPDATE [metadata_database].[schema].[ING_ENCRYPTED_COLUMN]SET ENCRPT_IV_CLMN_NM = NULLWHERE ENCRPT_IV_TYPE_CD = 'C'; |
| CADP-11212 | If float data type is selected in the column property, the unsupported data format error is returned.Workaround : Use the pdbctl utility to set the column-level encryption properties for float datatypes. |
| CADP-27294 | The setColProps.jar included with CDP for MSSQL version 8.12.2 is corrupted.Workaround: 1. Ensure JDK 8 is installed in the user's machine where CDP is installed. 2. Extract CDP_for_MSSQLServer\tools\SetColumnUtility\setColProps.jar to CDP_for_MSSQLServer\tools\SetColumnUtility\setColProps folder.3. Navigate to CDP_for_MSSQLServer\tools\SetColumnUtility directory and take backup of setColProps.jar file.4. Modify the content of setColProps\META-INF\MANIFEST.MF as shown below:Manifest-Version: 1.0Rsrc-Class-Path: ./ mssql-jdbc-12.4.2.jre8.jarClass-Path: .Rsrc-Main-Class: setColPropsMain-Class: org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader5. Open the current location in the command prompt and run the following command: jar cfm setColProps.jar setColProps\META-INF\MANIFEST.MF -C setColPropsThis will recreate a new setColProps.jar that can be used further. |
Compatibility Information
This release is tested with CipherTrust Manager 2.14.0 and higher versions.
When using CDP 8.12.2 or higher with CipherTrust Manager 2.15 or lower, if a user mapping is added or updated, you must execute the pdbctl utility command migrateusermap. This makes the added/updated user mapping compatible with the CipherTrust Manager. Refer to Migrate user mappings for details.
Upgrade Path
CDP can be upgraded from:
| Upgrade Path | Upgrade Path |
|---|---|
| 8.9.0 | 8.10.0 |
| 8.10.1 | 8.10.2 |
| 8.11.0 | 8.12.0 |
| 8.12.1 |
Note
If you are upgrading from any versions prior to 8.9.0, first upgrade to PDB 8.9.0 and then upgrade to CDP 8.12.2.
When upgrading to CDP 8.12.2 or higher, it is recommended to use the CipherTrust Manager 2.16 or higher.
Supported Platforms
CDP for MSSQL supports all the versions of Windows operating systems that are supported by the database.
Supported SQL Server Versions
CDP supports the following SQL Server versions:
| Supported Version | Supported Versions |
|---|---|
| SQL Server 2014 | SQL Server 2016 |
| SQL Server 2017 | SQL Server 2019 |
| SQL Server 2022 |
