ODATA Error Could not create SSL\TLS secure channel using Microsoft Excel

Products

• Clarity PPM SaaS

Issue/Introduction

While connecting to ODATA end points getting error "Could not create SSL\TLS secure channel" using Microsoft Excel

 

Steps to Reproduce:

1. Login to Clarity and Navigate to Administration
2. Under Administration -->General Settings --> Gather the Data Warehouse ODATA Service
   • 
3. Open the Microsoft Excel and check the version using Account ( In this case I was testing with Microsoft Excel 2016)
   • 
4. Open the Microsoft Excel --> Data --> From Other Source --> From Odata Data Feed
   • 
5. Fill in the connection which can be found from Step 2
   • 
6. Below error is shown
   • 

 

Expected Result: The user should be successfully able to connect via ODATA end point

Actual Result: The user is unable to connect via ODATA end point

Cause

Clarity SaaS GCP, only allow TLS 1.2  and above and Microsoft Excel is using has lower TLS

Environment

Release : All Clarity Supported Version 

Component : CA PPM SAAS OPERATIONS ODATA

Resolution

The work around found at this point to use New Query in Microsoft Excel and below are the steps 

 

1. Open Microsoft Excel 
2. Navigate to Data --> New Query --> From Other Data Sources --> From ODATA Feed and you should be able to use it