User guide

ii Data Integration with Sybase Avaki Studio
The palette 20
The view model editor 21
Adding and removing objects 21
View model tabs 21
The metadata model editor 22
The bottom pane 22
Table schema view 22
Dependencies view 22
Console view 22
View Model Parameters view 23
Setting preferences 23
Working with Avaki Studio 26
Chapter 3 Creating view models 29
The exercise 30
The HR data service 30
The database connectors 31
Tasks in this tutorial: the to-do list 31
Creating database connectors 32
Creating database operations 38
Using the view model wizard 43
Configuring input sources 44
Joining result sets 45
Using Projection to combine columns 47
Testing the view model 50
Deploying the view model as a data service 51
Thinking ahead: load sharing for data service execution 52
Chapter 4 The view model editor 53
Common features of view model components 54
Creating components 54
Creating elements using the palette 54
Creating Input Source elements using drag and drop 55
Selecting and moving elements 56
Creating connections between elements 57
Properties dialogs 58
Element names 58
Element descriptions 59