User guide

Getting started with Avaki Studio
18 Data Integration with Sybase Avaki Studio
To open a saved view model, expand the view model’s project folder in the navigator
and double-click on the .avm file (myviewmodel.avm, for example). The view model
opens in a new tab in the view model pane; to close it, click the X on the tab. To save
the view model, select Save or Save As... from the File menu, or enter Ctrl–s.
The data catalog view
The data catalog view shares the left-hand pane with the Navigator. To display it, pull
down the Window menu and select Show View > Data Catalog. Click Ye s when Stu-
dio asks whether to connect to the Avaki server, and provide any requested Avaki login
information.
Browsing for input sources
When Studio is connected to an Avaki domain, you can use the data catalog view to
browse the domain’s Avaki directories for relational and nonrelational input sources.
Relational input sources. Of interest in most domains is the Categories folder, where
you can browse for relational input sources such as database operations, data services,
and SQL views:
Nonrelational input sources. The location of nonrelational input sources such as
XML files, CSV files, and WSDL files can vary from one Avaki domain to another;
Categories/ViewLibrary/... Contents
DatabaseServices/<dbconn>/ Database operations stored in folders
named for their database connectors
DatabaseServices/<dbconn>/ProvisionedSQL-
Views
SQL views provisioned from tables in
external databases
DatabaseServices/<dbconn>/VirtualSQLViews SQL views generated from database
operations
DataServices Data services
DataServices/VirtualSQLViews SQL views generated from data services
VirtualDatabaseServices/Operations Virtual database operations
VirtualDatabaseServices/Services Reserved for system use
VirtualDatabaseServices/VirtualSQLViews SQL views generated from virtual data-
base operations