Developing a Database Service

To perform a database operation as a standalone service or within a business process or other composite service, you must develop a database service. You can expose actions that you can perform on a particular database through the use of existing stored procedures, SQL statements created during development of the database service, and query files. The result of this process is a service file you can deploy to provide access to your operation(s) at runtime.

The following workflow guides you through the process using the Service Development perspective. For assistance in performing these tasks, open the Developing a Database Service cheat sheet.

Complete the setup.
Create a database service.
The database service editor opens.
Build the service.
- Add a stored procedure operation
- Add SQL statement operations:
- Add result sets:
- View Database Service Operation Parameters and Result Sets
Add an endpoint.
Review the service Summary.
Test the service.

Next: Develop a Services Package Profile