Sample Data Service Workflow

The sample data service described here is used by the human resources department of a large organization to retrieve and combine employee information from two databases.

The HR coordinators who answer employees’ questions about compensation, benefits, and transfers need quick access to information about each person they talk to, but the information is stored in two different relational databases. Sybase Data Federation can solve this problem using a pair of database operations to obtain employee data and a simple data service to combine the data. The illustration below shows how the database operations extract employee data from the HR databases and deliver it to the data service. The data service then combines and processes the data (as specified in the view model). An HR application accepts results from the data service and displays them.

To create this data service, you might use WorkSpace Data Federation to set up database connectors and database operations, construct and test a view model, and deploy the view model as a data service.

Figure 1. A data service (center) calls database operations to pull information from two databases, then combines the information and passes it to an HR application.
Shows the flow of data from two databases (via database connectors and database operations) into a data service. The data service combines and processes the data. The data service output is passed to an HR application, which displays the result for the HR user.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.