User guide

Creating view models
38 Data Integration with Sybase Avaki Studio
Step 8 Click Finish to save the settings you’ve entered. Avaki Studio creates the database
connector, tests it, and displays the results.
You can find the new database connector in the data catalog under
Categories/ViewLibrary/DatabaseServices/<dbconn>/<domain>.<dbconn>.
Later, if you want to modify the database connector, find it in the data catalog view,
right-click it, and select Edit from the context menu. Studio displays the database con-
nector wizard, which lets you edit all the properties described in the steps above.
Creating database operations
An Avaki data service—and the view model on which it is based—can use Avaki data-
base operations as input sources. Each database operation relies on an Avaki database
connector to connect to a relational database, from which the database operation
extracts data; the data is returned in result set format.
Before you try to configure a database operation, make sure that a database connector
has been created for the appropriate database. Instructions for configuring a database
connector can be found in the previous section, “Creating database connectors” on
page 32.
Follow these steps to create a database operation in Avaki Studio.
Step 1 To connect Studio to a grid server, pull down the Avaki menu and select Connect to
Server. Enter any requested information about the grid server.
Step 2 Pull down the Window menu and select Show View > Data Catalog. The data catalog
view appears in the left pane.