Situation:
- We have a SQL Server 2008 R2 database sitting in a data centre
- We would like to allow analysts to connect to the database and query the data using desktop based tools (e.g. Tableau) via ODBC. The desktop based tools do not necessarily support encryption.
- We need the data and queries to be securely encrypted while in transit over the network
Is there a good / reliable way to achieve this - e.g. some kind of local ODBC proxy that can then communicate with the server over an encrypted connection?