User guide

Getting started with Avaki Studio
26 Data Integration with Sybase Avaki Studio
Working with Avaki Studio
This section provides an overview of one kind of workflow in Avaki Studio. The pro-
cess of building and deploying a view model is as follows:
1. Create a new view model. The view model is where you specify how your data service
combines and transforms data. For instructions on creating view models, see “Using
the view model wizard” on page 43.
2. Create a database connector. To extract data from a relational database, your view
model needs a pair of Avaki services: a database operation to select the data, and a
database connector to access the database. For instructions on creating database con-
nectors, see “Creating database connectors” on page 32.
3. Specify input sources for the view model. An Avaki data service—and the view model
on which it is based—can use Avaki database operations, data services, and other
objects as input sources. The process for specifying an input source is as follows:
• Create database operations or data services. For instructions about creating data-
base operations, see “Creating database operations” on page 38. For instructions
about creating data services, see Chapter 3‚ “Creating view models”.
• Check dependencies. The Dependencies view displays information about data ser-
vices and database operations that provide input to or receive output from another
data service or database operation. For more information, see “Dependencies view”
on page 22.
• Create an input source and specify its schema. See “Configuring input sources” on
page 44 and “Input Source” on page 125.
4. Specify parameters. You often will want to provide parameters to your model that
affect the way it functions. Parameters to the view model are called global parameters
because they are available to all of the operators and other elements within the model.
For information about specifying, viewing, and editing global parameters, see “Using
global parameters” on page 63.
5. If your input source has parameters, you must map them to global view model param-
eters. For more information, see “Mapping input parameters” on page 144.
6. Specify operators. Avaki Studio provides elements and operators you can use to
manipulate data in a view model. The process for specifying an operator is as follows:
• Create operators. A Join operator combines the result sets from two input sources.
For more information, see “Joining result sets” on page 45. A Projection operator
lets you modify a schema—you can remove columns, add computed columns, or
apply formulas to alter existing column values. For more information, see “Using