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 human resources coordinators who answer employees’ questions about compensation, benefits, promotions, 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 data service (center) calls the database operations to extract employee data from the two 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 sample data service with its inputs and output
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.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com