Hi Thorsten,

We not longer use ASE, we've switched to Microsoft.  We consume REST APIs from MS SQL Server by using a CLR function written in C# to do the REST call and it integrates with SQL Server the same as any other sql function.

You can't write CLR functions for ASE, but depending on which version of ASE you use, you may be able to do the same thing with Java. If you have Java integration with your ASE license, you should be able to write all the API calls in Java and then call the Java classes directly from ASE.  It may be something to look into.

Hi Thorsten;

   I believe that with ASE, you have to call an external process (ie .Bat or EXE) using ASE's command interface to perform Web Service calls.

   However, you can do this directly in SQL Server for example: https://www.mssqltips.com/sqlservertip/6803/build-secure-sql-server-rest-api-minutes

Regards ... Chris