Skip to Content

Accessing Hana Express OData from Excel

Mar 29, 2017 at 11:11 PM


avatar image


I've got a test OData source working and I'd like to try it with Excel. I get an error;

OData: Request failed: The underlying connection was closed: Could not establish trust relationshipo for SSL/TLS secure channel.

I think the problem is that I don't have a signed certificate authority key. This is a test machine that's behind a firewall so I don't need or want a public key. Anyway, to get a public key you need to show that you're in charge of the domain. There isn't a domain. This is just a server on the local network.

Does anyone know how to go about getting Excel to work with a Hana Express OData service?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers