User guide

Getting started with Avaki Studio
20 Data Integration with Sybase Avaki Studio
Managing the data catalog
You can use the Data Catalog view to manage the data catalog. Select an item of inter-
est in the catalog and right-click for a context menu. You can:
• Display information about items in the catalog, including their type (such as data
service or database operation), qualified name, SQL statement (for a database oper-
ation), parameters, data expiration for caching, and run-as user.
• Add and delete categories in the data catalog.
• Assign objects in the data catalog to categories.
• Refresh the contents of the data catalog to pick up changes such as new categories,
data services, or database operations.
The palette
The palette, a column of buttons between the navigator and the view model pane, is a
set of tools for working on view models:
Select. If the Operators are open, you’ll notice that there are two Select buttons: one at
the top, and one among the Operators. Click the top Select button when you want to
select something in the view model.
Connection. To draw arrows that show how data will flow from one element in the
view model to another, click Connection. Next, click on the input source or operator
that data will flow from. Then click on the operator or result that data will flow to.
Input Sources. Input Sources is a collapsible list—click it to open it (which exposes
the Input Source button) or collapse it. To create an input source, click the Input
Source button, then click the place in the view model pane where you want the new
input source to appear. (You can also create Input Source elements by dragging and
dropping items that provide input data from the data catalog pane into the editor.) For
details on Input Sources, see “Input Source” on page 125.
Operators and Advanced Operators. Like Input Sources, Operators and Advanced
are collapsible lists—click one to open or collapse it. To add an operator or an
advanced operator to the view model, click the operator’s button, then click the point
in the view model pane where you want the operator to appear. For details on all the
operators, see Chapter 7‚ “Operator reference”.