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.
...
Give your data source a name and for the Server, paste in the URL that you’ve been given. Note the comma before the port number. Click Next.
Select 'With SQL Server authentication…' and enter the Login ID and Password that you have been provided. Click Next.
...
Change Connection Encryption to Strict. Leave all other settings as their default value. Click Finish.
The following confirmation dialog will appear. Click on Test Data Source…
If the connection was successful, you will be presented with the following:
Click on OK and then OK again to save the new data source. Your data source should now appear in the list of User Data Sources:
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
...