User guide

Data Integration with Sybase Avaki Studio 179
data service
An operation that transforms data obtained from sources in the data catalog. Input data can come
from any number of sources, including:
• other data services
• data catalog files (which can be generated views)
• Avaki database operations (which in turn extract the data from relational databases)
• HTTP requests
• Web service invocations
You can generate the code that manipulates the data by creating a view model in Avaki Studio, or by
writing a custom data service plug-in using Java, JavaScript, or XSLT. Data service output can be in
rowset or XML format. Data services are run by the execution services on grid servers, they can be
scheduled, and their results can be cached.
data service plug-in
The logic for a data service, written in Java, JavaScript, or XSLT. Data service plug-ins are modular—
you can use the same plug-in for multiple data services. Avaki Studio creates data services and
plug-ins simultaneously, so if you use Avaki Studio to create data services, you don’t have to worry
about plug-ins. You can also use the Avaki Plug-in Wizard to create data service plug-ins.
database connector
A mechanism that enables one or more database operations, SQL views, or ad-hoc queries to connect
to a relational database.
database operation
(DBOP) A mechanism that can
• extract data from a relational database and deliver it on demand to a view generator or a data
service, or
• modify data in a relational database.
A database operation can be a SQL statement or a stored procedure call.
dependency
A relationship in which an Avaki object requires input from other Avaki objects. A data service might
require input from one or more database operations or from other data services. A view generator
might depend on a database operation for input. A database operation can serve as an input source for
one or more data services or view generators. Generated SQL views depend on database operations,
virtual database operations, or data services. You can use Avaki Studio, the web UI, or the CLI to list
input and output dependencies for any data service, database operation, or view.