We are providing direct database connectivity over a whitelisted secure connection. For this secure connection to work, the SQL Server driver that is being used on the client machine must support Strict encryption mode.
| Note |
|---|
Pre-requisites
|
This is supported by ODBC Driver 18 for SQL Server.
...
The following instructions may differ depending on the version of Excel that you’re using.
...
Use of different tools:
MS Query (currently used in our training materials)
Check the "All command in the Customize Ribbon?
Click File > Option> Customize Ribbon> Select “All commands”
Search for “New Database Query” from the list, select it, and click on the “Add” Button to add under the “Get Data” in the Main Tabs
Power Query (optionally used by clients)
Go to Excel > Data tab > Get Data > From Other Sources > From ODBC
...