Adapter for Microsoft SQL Server ODBC: SQL Server 2017/2016 Always Encrypted Support

The Windows ODBC version of the Adapter for SQL Server supports the SQL Server 2017/2016 Always Encrypted native feature under the following conditions:

• The columns have to be encrypted using SQL Server Management Studio prior to creating any synonyms.
• The adapter connection is configured with the connection string keyword ColumnEncryption=Enabled.

When a synonym is created, the Access File will contain the attribute ENCRYPT_TYPE={DETERMINISTIC|RANDOMIZED} for the encrypted columns.

Certain operations on encrypted columns cannot be performed in SQL. The adapter logic will account for that, and those operations will be performed by the WebFOCUS Reporting Server.