We have an application storing sensitive data that will have encryption at rest with TDE. Is is possible to connect to this from a third party stats package like STATA, R-Studio via ODBC and query the database in a non-encrypted format? If so, is someone able to share how.
Answer by KenJ ·
You connect to the encrypted database in exactly the same way you would if the database were not encrypted at all. You see this in action every time you query the database using SSMS. It's not doing something proprietary under the covers, TDE is quite literally "transparent" to the downstream client.