HTTPS:\\ webserive call without passing certificate string

[Former Member]

We are using HTTPS:\\ web service call from our one of the procedure.

When I did research, I found that, we can't call HTTPS:\\ web service without passing certificate.

My question is, how should I take care for situation where certificate got expired and need to replace certification.

I need some alternate way, where there is no need to pass certificate or no need to pass file path as well...

[jeff_albion]

Hello,

There was a similar question asked in our alternate forum, see: Access https URLs - SQLA Forum. Currently, certificates are specified manually. We have made an enhancement request for SQL Anywhere web clients to potentially use the OS Certificate store instead, in future versions.

So in summary, currently you will need to either replace the certificate, or provide an alternate certificate by specifying the certificate string in the stored procedure definition directly:

CREATE OR REPLACE PROCEDURE ...
CERTIFICATE '-----BEGIN CERTIFICATE----- ... -----END CERTIFICATE-----'

Notably, MobiLink clients can currently use the (Windows or Android) operating system store for certificates if trusted_certificates is not specified at all.

Regards,

Jeff Albion

SAP Active Global Support