OData, Microsoft Excel, & TLS 1.0 Deprecation
As Convercent continues to ensure up-to-date and advanced security policies and measures are in place to secure your data, we are making a change to the version of TLS we support. On July 12, 2019, we will be deprecating support for TLS 1.0, which may impact your ability to use Excel 2013 and some 2016 versions, to run OData reports/pulls. This is because our oData connections only allow TLS 1.1 and 1.2 at this time.
In order to connect to OData, your computer/machine must use TLS 1.1 or 1.2, which in some cases will require updating your operating system, as well as the registry key information, to default to TLS 1.2 when connecting to data.
**We strongly recommend updating your Microsoft Office suite to the latest version as well as your Operating System to prevent the need for the workaround solution provided below.
Editing the registry can be dangerous if you are not familiar with the edits you are making or are unsure if you are in the right location. The script detailed in the link below helps to minimize the risk, however, we also recommend some extra safety measures of backing up your registry using the steps in the Microsoft article here.
We also recommend reviewing Microsoft's article on how to enable TLS 1.2 as default, which will require administrative assistance from your organization's IT/Helpdesk. Please be advised that updating registry keys is at your organization's risk.
We have diligently been working to find solid resolutions to this change to have as minimal of an impact to you as possible, however, this update is required from Microsoft in order to connect to our OData feeds. There is a small change to your system that is needed, which is detailed in the article above. Below are steps on running the file on your machine to update registry keys to allow TLS 1.2.
- Copy the registry keys and create a TLS.reg file with the keys detailed at https://docs.microsoft.com/en-us/officeonlineserver/enable-tls-1-1-and-tls-1-2-support-in-office-online-server.
- Double-click the file to open and execute the script to modify the registry key entry for your system.
- On the User Account Control prompt that appears, click YES to continue.
- You will then be prompted with a Registry Editor information alert, which you will need to click YES to continue forward with this fix.
- On the second Registry Editor window, you should see a notice that it was successfully added to the registry, click OK to close the window.