User guide

Data Integration with Sybase Avaki Studio 185
share server
An Avaki server whose only task is to manage Avaki shares—local directories that are exported
(shared) into the data catalog. (Grid servers can also manage shares.)
shared directory
See Avaki share.
soft link
A pointer to a particular location (name) in the Avaki data catalog. If the object at that location is
moved, deleted, or renamed, the soft link leads nowhere. Soft links can be created only in the CLI.
Contrast with hard link.
SQL view
A virtual table—a data catalog entry that represents a table in a relational database, a database oper-
ation, or a data service. SQL views can be created in three ways:
• Provisioned directly from a table in an underlying database
• Generated from a database operation or data service
• Mapped from a database table, a database operation, or a data service, using the Avaki Studio
metadata model editor
Every SQL view is part of the Avaki virtual database. SQL views are treated as relational tables by the
Avaki query engine. SQL view data can be accessed using standard SQL statements by connecting to
Avaki with ODBC or JDBC, or via an Avaki virtual database operation.
update notification
A message issued when a generated view is updated. A view that receives data from another view can
be configured to regenerate itself (using the new data) upon receipt of an update notification.
view generator
A mechanism that does one of the following: extracts data from a file or an HTTP source, obtains data
from an Avaki data service, or uses an Avaki database operation to extract data from a relational
database. The view generator can display the data, perform an XSLT transform, save the data as a gen-
erated view file, and/or update a database. Contrast with data service.
view model
The graphical representation of a data flow that you can build in Avaki Studio. A view model typically
includes one or more input sources (such as database operations or data services), one or more oper-
ations to combine or transform the data, and an output target. When you deploy a view model, it
becomes an Avaki data service.