Category / Section
How to decrypt encrypted data in SQL server using Bold BI
Published:
Bold BI provides a feature to decrypt encrypted data in SQL Server by adding additional connection parameters. This article will guide you through the process of decrypting data in Bold BI.
Prerequisites
Before proceeding with the decryption process, ensure that you have db_datareader permissions for the database.
Steps to Decrypt Data in Bold BI
Follow the steps below to decrypt data in Bold BI:
- Open the SQL Server connectivity page in Bold BI.
- Enter your SQL Server credentials.
3. Add the “Column Encryption Setting=enabled;” property in the Additional connection parameters text box.
4. Click on ‘Connect’. This will open the query designer page.
5. Drag and drop the table containing the encrypted data and update the preview grid.
6. The encrypted data will now be displayed as decrypted.
Please note that if you add the “Column Encryption Setting=disabled;” property or if the enable property is not added in the Additional connection parameters text box, the data will not be decrypted.
References
SM
