1 of 1 people found this helpful
There is no official support for Microsoft SQL Server 2016 encryption with Tableau Desktop.
You can add your vote to the following Community Idea: https://community.tableau.com/ideas/7616
The more votes you got the better chances you have to see it implemented.
Tableau Desktop allow SSL communication encryption but Tableau Desktop driver will not be able to communicate with the Sql Server where the 'always encrypted" is set.
Thank you for the response.
I think we found a way to encrypt the data and be able to decrypt the data in Tableau. We are going to:
- Encrypt the columns with encryption and decryption keys and a password.
- Create a stored procedure that will extract the data and request the password.
- Execute the stored procedure in Tableau. This will hopefully request the password from the user.
The table is quite small so having a live link will not slow the report down. We still need to test the full solution but we are hopeful.