Below are the steps for creating a simple procedure, and publishing it as a REST web service protected by an Authentication scheme. You can use the same steps for any other procedure.
1. Create a procedure
PROCEDURE p_add(a int, b int, out result int)
BEGIN
set result = a + b;
END 2. Publish the procedure by right-clicking on it, then selecting
Publish from the menu that appears. For the purposes of illustration, let us assume that we are publishing the procedure under a web service named
examples, as shown below.
3. Open the web service i.e.
/services/webservices/examples, and click on the
REST tab. Choose the authentication scheme that you want to use, by setting one of the following options to
true:
- Enable HTTP Basic
- Enable HTTP NTLM
- Enable HTTP Negotiate
4. Access the web services url from your client. For instance, using a browser, you would enter:
http://localhost:9400/examples/p_add?a=2&b=3
as shown below.