Encryption is the scrambling of data so only the intended users can read and understand the encrypted information. Encrypting the SQL connection to data on the Enterprise Data Warehouse is very important. Without encryption the data sent between the server and the client is readable by anyone that can intercept your network packet. If you access confidential data, it is considered a basic security practice to encrypt the communications between you and the server.
How to Enable Encryption:
Enabling Encryption For SSMS (SQL Server Mgmt Studio) Connections
The first two screens show how to find the encrypt connection setting when you simply open a new connection in SSMS. The third screen shows where it is if you use “registered servers” in SSMS.
Enabling Encryption for ODBC (Microsoft Access) Connections
This screen shows the box to check when setting up one’s ODBC connection. You can find complete instructions on creating an ODBC connection here.
From within BIDS, double-click on a Shared Data Source object.
The outcome is the addition of ;Encrypt=True at the end of the connection string. You could also hand-type that without having to click through the screens.