3 Replies Latest reply on Dec 24, 2018 1:46 PM by Yeyner Escobar

Tableau access to encrypted SQL columns

Hein Lochner Jun 20, 2018 12:11 AM

I have sensitive data that is stored in a SQL 2016 table. The sensitive columns are encrypted and a certificate generated which allows a limited number of people to access the decrypted data. These columns are needed in a Tableau workbook to create a report that will be published to Tableau server with limited access. The report will be published with a live link and not an extract.

I have all the relevant encryption keys and algorithms. My problem is to get Tableau to read the decrypted data. I searched for solutions but found very little on the subject.

Has someone solved this problem? Any assistance will be appreciated.

Hein

1. Re: Tableau access to encrypted SQL columns

Sebastian Sofariu Jun 20, 2018 2:54 AM (in response to Hein Lochner)

Hi 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
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
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
Like Show 2 Likes(2)

Actions
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?
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Tableau access to encrypted SQL columns

1. Re: Tableau access to encrypted SQL columns

2. Re: Tableau access to encrypted SQL columns

3. Re: Tableau access to encrypted SQL columns

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account