Navigation: Scan2x Administrator's Guide > Scan Job Configuration > Output Settings Options > Scan To Database >

Configuring a database & Scan2x to encrypt columns





Configuring a database & Scan2x to encrypt columns


1. Configuring the database to encrypt columns


Install a certificate in the “User Certificates” area. (Optional, SQL Management Studio has the option to automatically generate a certificate if you do not have one).


Go to the “Security” > “Always Encrypted Keys” tab inside the database, using the SQL Management Studio.




In this step, you can use a previously installed certificate or generate a new one.

Create a new “Column Master Keys”.



Create a new “Column Encryption Keys” using the Master Key previously created.



Select the table in which a column will be encrypted, right-click on the selected table, and choose the option “Encrypt Columns”




Select the column, type and key.




2. Configuring Scan2x to encrypt columns


Create a Job and go to the “Output settings” tab.


Select the “Database” output option.



Configure your database connection settings.




After configuring the database settings, the table properties will be displayed in the right panel.


Configure the last column with the desired properties and select the checkbox under the 'Encrypted' column to encrypt the database table column.






Copyright © 2023 Avantech Software