-
1. Re: Tableau access to encrypted SQL columns
Sebastian SofariuJun 20, 2018 2:54 AM (in response to Hein Lochner)
1 of 1 people found this helpfulHi Hein,
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.
Regards
-
2. Re: Tableau access to encrypted SQL columns
Hein Lochner Jun 20, 2018 3:25 AM (in response to Sebastian Sofariu)Hi Sebastian
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.
Regards
Hein
-
3. Re: Tableau access to encrypted SQL columns
Yeyner Escobar Dec 24, 2018 1:46 PM (in response to Hein Lochner)Hello good afternoon, I am investigating something similar and I would like to know if we work with the stored procedure?