Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I need to do a SOAP request but server requires a X.509 certificate with a password (pfx file).

I've done it using Soap UI by pointing the certificate file and password in SSL settings.

I also know that to define simple certificate without a password when creating a SQL Anywhere SOAP client procedure I need to use parameter certificate, however I can't find any information regarding certificates that require a password.

Sample code taken from SA 12 documentation:

create or replace function httpAddItemFunction("soapPayload" xml )
returns XML
url 'http://localhost/store'
    type 'HTTP:POST:text/xml'
    header 'SOAPAction: "http://localhost/addItems"'
    certificate 'cert=...';

Any suggestions?

asked 27 Apr '16, 08:43

Valdas's gravatar image

accept rate: 83%


Are you attempting to use Mutual authentication or two-way authentication here?

If so that is not supported in versions 12 and 16 (nor even 17 currently). Even if all you are doing is client identification here, we only support server identification; only having support for identiy_password on the server side (as a https protocol option) and only expecting that model for external content servers.

If you absolutely require Mutual/two-way/client authentication you may have to move this into an external CLR environment implementation.

(27 Apr '16, 10:42) Nick Elson S...

Note, v17.0.4 has introduced support for client certificate supports, cf. the docs.

However, in my humble understanding, this does apply to SQL Anywhere web servers and regular database clients, not to web-client functions/procedures...

(22 Sep '16, 04:21) Volker Barth

Not supported in SQL Anywhere, created a custom C# library instead.

permanent link

answered 22 Sep '16, 03:35

Valdas's gravatar image

accept rate: 83%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 Apr '16, 08:43

question was seen: 2,399 times

last updated: 22 Sep '16, 04:26