User guide

Data Integration with Sybase Avaki Studio 125

Input Source

An Input Source element represents input from a source external to your model.

While some input sources take their input from nonrelational data, all of them have a

single output in which their data is formatted as a result set, as if it had come from a

relational database query. To configure an Input Source element, you must specify the

original source of the data, set up a transformation if the data isn’t already in result set

format, and specify values for any parameters the input requires.

To create input sources that are based on elements in your Avaki domain, you can drag

and drop items directly from the Data Catalog View in Studio into your view model.

These include database operations, virtual database operations, other data services,

and files. Studio attempts to do as much of the configuration as possible. (For exam-

ple, if you drag a data service that takes no parameters into your model, the resulting

Input Source element will be fully configured. If you drag an XML file into your view

model, you must still configure the transformation to construct a result set from the

XML data.)

Note If you need to create input rows that don’t come from an external input

source, use the Generator operator—see “Generator” on page 117.

Connections

The Input Source element takes zero input result sets. It produces exactly one output

result set whose schema is defined either by the source itself (for relational inputs) or

by the transform you define (for non-relational inputs).

Required Connection