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.
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