M2M AD301 User's Guide

Sybase, Inc.One Sybase DriveDublin, CA 94568www.sybase.com®DRAFTData Integration with Sybase Avaki StudioRelease 7.0 • August 24, 2006

Prefaceviii Data Integration with Sybase Avaki Studioall, while others require partial to full working knowledge. In Avaki Studio, you can employ Java

Metadata modeling88 Data Integration with Sybase Avaki StudioStep 11 Continue to click Add and enter data until your table contains all the columns yo

Data Integration with Sybase Avaki Studio 89Mapping metadata models to Avaki objectsStep 2In the data catalog view, click GetEmpGivenName. Drag and dr

Metadata modeling90 Data Integration with Sybase Avaki StudioIf the schemas do not match—for example, if you drop the GetEmpGivenName data-base operat

Data Integration with Sybase Avaki Studio 91Deploying metadata modelsStep 5Point your application at either the database or Avaki; no further changes

Metadata modeling92 Data Integration with Sybase Avaki StudioThe metadata model is successfully deployed and added to the data catalog’s Metadata dire

Data Integration with Sybase Avaki Studio 93Deriving metadata modelsDeriving metadata modelsDeriving a view model from a metadata model is a way to cr

Metadata modeling94 Data Integration with Sybase Avaki StudioStep 4 Create a data service where you connect input to output. Step 5 In the editor pane

Data Integration with Sybase Avaki Studio 95Undeploying metadata modelsUndeploying metadata modelsUndeploying a metadata model reverses the results of

Metadata modeling96 Data Integration with Sybase Avaki Studio

Data Integration with Sybase Avaki Studio 97Chapter 6Managing the data catalogThis chapter describes tasks you can perform in Avaki Studio’s data cata

Data Integration with Sybase Avaki Studio ixRelated documentationRelated documentationThese manuals make up the Avaki documentation set:• Sybase Avaki

Managing the data catalog98 Data Integration with Sybase Avaki StudioModifying ACLsThis section explains how to display and modify access control list

Data Integration with Sybase Avaki Studio 99Modifying ACLsStep 4To change the object’s owner, click the Change Owner... button. The User/Group Browser

Managing the data catalog100 Data Integration with Sybase Avaki Studiomissions dialog to show the new line in the ACL. In this example, we’ve added a

Data Integration with Sybase Avaki Studio 101Managing attributesManaging attributesRead this section for instructions on displaying, creating, modifyi

Managing the data catalog102 Data Integration with Sybase Avaki StudioStep 3 To add a new attribute to the object, click the Add button. Studio adds a

Data Integration with Sybase Avaki Studio 103Managing attributesStep 5To remove an attribute, click its pencil icon to select it and click the Delete

Managing the data catalog104 Data Integration with Sybase Avaki StudioManaging categoriesThis section provides instructions on displaying, creating, a

Data Integration with Sybase Avaki Studio 105Managing categoriesStep 3Right-click on the parent category and select Add Category from the menu. The Ad

Managing the data catalog106 Data Integration with Sybase Avaki StudioStep 3 Select one or more categories.Step 4 Click OK to add the object. Studio r

Data Integration with Sybase Avaki Studio 107Chapter 7Operator referenceConsult this chapter for detailed information on the workings of the elements

Prefacex Data Integration with Sybase Avaki StudioHow to contact Avaki support at Sybase, Inc.For general information about Sybase technical support,

Operator reference108 Data Integration with Sybase Avaki Studio• “Select” on page 165• “Splitter” on page 166• “Union” on page 168• “Update” on page 1

Data Integration with Sybase Avaki Studio 109AggregateAggregate propertiesDouble-click an Aggregate operator to display the Aggregate Properties dialo

Operator reference110 Data Integration with Sybase Avaki Studio Function: Click the Function field and use the pull down list to choose the func-tion

Data Integration with Sybase Avaki Studio 111CustomCustomA Custom operator can perform any operation that you define, using arbitrary Java-Script code

Operator reference112 Data Integration with Sybase Avaki StudioCustom propertiesDouble-click a Custom operator to display the Custom Properties dialog

Data Integration with Sybase Avaki Studio 113Custom• To delete one or more columns, select them and click Delete.• To reorder the columns, select one

Operator reference114 Data Integration with Sybase Avaki StudioNote The Custom operator is an exception to the guidelines regarding Java-Script expres

Data Integration with Sybase Avaki Studio 115Customalgorithm with the second input result set as the inner table. This would produce a result set cons

Operator reference116 Data Integration with Sybase Avaki Studio lookupTable.initialized = true; // So we don't try and do this again}This

Data Integration with Sybase Avaki Studio 117GeneratorGeneratorA Generator operator produces a result set without input. Like an Iterator, a Gener-ato

Data Integration with Sybase Avaki Studio 1Chapter 1View models in Avaki StudioAvaki Studio is a graphical, metadata-driven modeling tool for data int

Operator reference118 Data Integration with Sybase Avaki StudioGenerator propertiesDouble-click a Generator operator to display the Generator Properti

Data Integration with Sybase Avaki Studio 119Generatorthat would be valid inside a function body. See “Using expressions within Avaki Stu-dio” on page

Operator reference120 Data Integration with Sybase Avaki Studio• To reorder the columns, select one or more of them and click the Move Up or Move Down

Data Integration with Sybase Avaki Studio 121Group ByGroup By The Group By operator is very similar to the Aggregate operator. Its output includes col

Operator reference122 Data Integration with Sybase Avaki StudioPerformance notesBecause Studio needs to sort the result set in order to perform a grou

Data Integration with Sybase Avaki Studio 123Group By• You can edit the properties of each column: Name: Click in the Name field and choose a column

Operator reference124 Data Integration with Sybase Avaki Studio• You can edit the properties of each column. (See “Working with schemas” on page 60 fo

Data Integration with Sybase Avaki Studio 125Input SourceInput Source An Input Source element represents input from a source external to your model. W

Operator reference126 Data Integration with Sybase Avaki StudioInput Source PropertiesDouble-click an Input Source element to display the Input Source

Data Integration with Sybase Avaki Studio 127Input SourceYou specify the source for your Input Source element using the Input Source tab. The tab prov

View models in Avaki Studio2 Data Integration with Sybase Avaki StudioBackground: Avaki conceptsBefore tackling the task of creating a view model, you

Operator reference128 Data Integration with Sybase Avaki StudioConfiguring database operation input sources. On the next page (“Database Operation Inp

Data Integration with Sybase Avaki Studio 129Input SourceConfiguring data service input sources. On the next page (“Data Service Input Source”), you c

Operator reference130 Data Integration with Sybase Avaki StudioConfiguring file input sources. On the next page (“File Input Source”), you choose a gr

Data Integration with Sybase Avaki Studio 131Input SourceConfiguring HTTP input sources. On the next page (“HTTP Operation Input Source”), you specify

Operator reference132 Data Integration with Sybase Avaki StudioWhen you are done with this page, click Next to proceed to the “HTTP Operation Paramete

Data Integration with Sybase Avaki Studio 133Input SourceConfiguring web service input sources. On the next page (“Web Service Input Source”), you spe

Operator reference134 Data Integration with Sybase Avaki StudioClick the Next button to continue to the “Web Service Operation” page where you will ch

Data Integration with Sybase Avaki Studio 135Input SourceClick Next to continue to the “Web Service Response” page, where the wizard asks you to indic

Operator reference136 Data Integration with Sybase Avaki StudioConfiguring the transformIf the source you configured on the Input Source tab doesn’t a

Data Integration with Sybase Avaki Studio 137Input Source• CSV to Result SetWhen your data is in CSV or a similar format.• XML to Result SetIf your da

Data Integration with Sybase Avaki Studio 3What is a view model?Thus, a view model consists of• Zero or more input sources• Zero or more operators to

Operator reference138 Data Integration with Sybase Avaki StudioConfiguring CSV transforms. If you choose to define a CSV transform, the next page will

Data Integration with Sybase Avaki Studio 139Input SourceClick Next to display the “Column Definitions” page. If you selected “Use first row of data a

Operator reference140 Data Integration with Sybase Avaki Studio Scale: Specify the scale for the column, if applicable for the column’s type. First

Data Integration with Sybase Avaki Studio 141Input SourceWhen you’re done, click Next to continue to the “Column Definitions” page. • Click the Add bu

Operator reference142 Data Integration with Sybase Avaki Studioyou choose (for example, if the document has the value “foo” and you choose INTEGER for

Data Integration with Sybase Avaki Studio 143Input SourceConfiguring error handling You can choose how data services deployed from this view model wil

Operator reference144 Data Integration with Sybase Avaki StudioMapping input parameters If the input source has parameters, you must map them to globa

Data Integration with Sybase Avaki Studio 145Input SourceTo edit the expressions, click in the Value column to make it editable. Type your map-ping ex

Operator reference146 Data Integration with Sybase Avaki StudioWeb service parameters. Parameters defined by web services are arbitrarily com-plex str

Data Integration with Sybase Avaki Studio 147Input SourceThe Map Unmapped shortcut. Studio provides a shortcut for mapping parameters to the global pa

View models in Avaki Studio4 Data Integration with Sybase Avaki StudioData flowDiscussions of view model operators and especially of variables rely on

Operator reference148 Data Integration with Sybase Avaki StudioIntersection The Intersection operation generates a result set consisting of only those

Data Integration with Sybase Avaki Studio 149IteratorIterator The Iterator operator provides a looping construct for view models. Based on criteria yo

Operator reference150 Data Integration with Sybase Avaki StudioConnectionsThe Iterator operator takes either one or two input result sets. If there is

Data Integration with Sybase Avaki Studio 151Iteratortain your own iteration control variables (such as a counter that you increment). When you config

Operator reference152 Data Integration with Sybase Avaki StudioExample: Iterating over the elements of an array parameter The problemSuppose you want

Data Integration with Sybase Avaki Studio 153Iterator• Condition: Enter the following code:// Check to see if we’re at the end of the arrayvariables.A

Operator reference154 Data Integration with Sybase Avaki StudioJoin The Join operator performs a relational join operation on its two input result set

Data Integration with Sybase Avaki Studio 155JoinInner and outer tablesThe algorithm and join type choices refer to inner and outer tables. Studio doe

Operator reference156 Data Integration with Sybase Avaki StudioJoin types Avaki Studio supports inner, outer-left, outer-right, and outer-full join ty

Data Integration with Sybase Avaki Studio 157Multiplexer Outer Column: Click in field and use the pull-down list to choose the corre-sponding column

Data Integration with Sybase Avaki Studio 5What is a view model?Everywhere you can enter JavaScript expressions, you have access to an object called v

Operator reference158 Data Integration with Sybase Avaki StudioMultiplexer propertiesDouble-click a Multiplexer operator to display the Multiplexer Pr

Data Integration with Sybase Avaki Studio 159Order ByOrder By The Order By operator sorts its input based on the criteria you specify. Order By does n

Operator reference160 Data Integration with Sybase Avaki StudioOrder By propertiesDouble-click an Order By operator to display the Order By Properties

Data Integration with Sybase Avaki Studio 161ProjectionProjection The Projection operator lets you modify a schema. You can pass certain columns throu

Operator reference162 Data Integration with Sybase Avaki StudioProjection propertiesDouble-click a Projection operator to display the Projection Prope

Data Integration with Sybase Avaki Studio 163Projection Expression: Click in the column’s Expression field to edit it. This can be any JavaScript exp

Operator reference164 Data Integration with Sybase Avaki StudioResult A view model’s Result element is created automatically when you create the view

Data Integration with Sybase Avaki Studio 165SelectSelect Use a Select operator to filter rows from an input result set. You provide a Boolean express

Operator reference166 Data Integration with Sybase Avaki StudioANNUAL_SALARY column in the input result set) is $100,000 or less, you could use the ex

Data Integration with Sybase Avaki Studio 167SplitterSplitter propertiesDouble-click a Splitter operator to display the Splitter Properties dialog. Yo

View models in Avaki Studio6 Data Integration with Sybase Avaki StudioOperatorsAvaki Studio provides a selection of elements and operators you can use

Operator reference168 Data Integration with Sybase Avaki Studiodefines a variable that’s mapped to a parameter in an Input Source element upstream of

Data Integration with Sybase Avaki Studio 169UpdateUnion propertiesDouble-click a Union operator to display the Union Properties dialog. You can edit

Operator reference170 Data Integration with Sybase Avaki Studio• The data types of the result set columns (by ordinal position) and the parameters of

Data Integration with Sybase Avaki Studio 171UpdateUpdate propertiesDouble-click an Update operator to display the Update Properties dialog. You can e

Operator reference172 Data Integration with Sybase Avaki StudioChoosing a database operationThe Update operator executes a database operation defined

Data Integration with Sybase Avaki Studio 173UpdateTo bring up the Parameter Properties dialog, click the Edit Values… button. To map a parameter, cli

Operator reference174 Data Integration with Sybase Avaki Studio

Data Integration with Sybase Avaki Studio 175GlossaryTerms printed in italics are defined in the glossary.access control list(ACL) A list, for a given

Glossary176 Data Integration with Sybase Avaki StudioAvaki directoryAvaki software creates a single, unified namespace that is accessible (subject to

Data Integration with Sybase Avaki Studio 177Avaki StudioA graphical, metadata-based data integration tool that lets you • Build data flows by draggin

Data Integration with Sybase Avaki Studio 7Operators• JoinGiven two input result sets that share a common column, Join combines rows and produces a ne

Glossary178 Data Integration with Sybase Avaki StudioCIFS shareA directory or file that has been exported (shared) from the Avaki data catalog. A CIFS

Data Integration with Sybase Avaki Studio 179data serviceAn operation that transforms data obtained from sources in the data catalog. Input data can c

Glossary180 Data Integration with Sybase Avaki StudioDGASSee data grid access server.distributed transactionA set of related operations (typically SQL

Data Integration with Sybase Avaki Studio 181failoverThe transition of control from a failing or unreachable primary grid domain controller to a secon

Glossary182 Data Integration with Sybase Avaki Studiogrid serverAn Avaki server that maintains a portion of the Avaki domain’s namespace, runs Avaki s

Data Integration with Sybase Avaki Studio 183metadata modelA construct in Avaki Studio that expresses a schema by defining a set of tables. A table in

Glossary184 Data Integration with Sybase Avaki StudioqueriesSee ad-hoc query.query engineAn Avaki service that executes SQL queries against the SQL vi

Data Integration with Sybase Avaki Studio 185share serverAn Avaki server whose only task is to manage Avaki shares—local directories that are exported

Glossary186 Data Integration with Sybase Avaki Studiovirtual databaseThe set of all SQL views in an Avaki domain, including those provisioned from ext

Master Index Index-1Master IndexKeyAD: Administration GuideAPI: API GuideC: Command ReferenceO: OvertureP: Provisioning & Advanced Data Integ

DOCUMENT ID: DC00574-01-0700-01LAST REVISED: August 2006Copyright © 2002 – 2006 Sybase, Inc. All rights reserved.This publication pertains to Sybase s

View models in Avaki Studio8 Data Integration with Sybase Avaki Studio

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-2 Master Indexad-hoc queries (continued)code samples API:74d

Master Index Index-3P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studioauthentication services (continued)

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-4 Master Indexavaki dgas --show-admission-policies C:114avak

Master Index Index-5P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studioavaki security --default-group C:21

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-6 Master Indexavaki upgrade C:249avaki upgrade --info C:250a

Master Index Index-7P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiocaches (continued)bad port, propert

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-8 Master Indexchange time file attribute C:290charactersin c

Master Index Index-9P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiocom.avaki.scheduleExclusionCacheSiz

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-10 Master Indexdata catalog SOAP operations (continued)remov

Master Index Index-11P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiodata services (continued)input str

Data Integration with Sybase Avaki Studio 9Chapter 2Getting started with Avaki StudioRead this chapter for instructions on starting Avaki Studio for t

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-12 Master Indexdatabase operation SOAP operations API:40data

Master Index Index-13P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiodataservice --info command C:57dat

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-14 Master IndexDGAS (continued)restarting AD:84saving a copy

Master Index Index-15P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiodistributed transactionsabout O:25

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-16 Master IndexFfailoverdefined AD:354, API:88, C:312, O:66,

Master Index Index-17P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiofunctionsin expressions S:73used w

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-18 Master Indexgroups (continued)defined S:176deleting AD:19

Master Index Index-19P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki StudioisList element P:266Iterator opera

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-20 Master Indexldap --delete command C:153ldap --delete-sche

Master Index Index-21P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiomonitor --add command C:167monitor

Getting started with Avaki Studio10 Data Integration with Sybase Avaki StudioStarting Avaki StudioYou can launch Avaki Studio using the Avaki program

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-22 Master Indexoperators (continued)logical, in expressions

Master Index Index-23P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studioprivacy and HTTPS API:8Projection

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-24 Master Indexrefresh schedulesfor Avaki shares AD:266, C:2

Master Index Index-25P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studioscheduleexclusion --list command C

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-26 Master Indexserver --dgas --destroy command C:224server -

Master Index Index-27P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki StudioSOAP complex types (continued)Data

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-28 Master IndexSQL views (continued)managing P:20modifying P

Master Index Index-29P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki StudioUnset permission in ACL AD:242, O:

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-30 Master Indexview --create --file command C:267view --dele

Master Index Index-31P: Provisioning & Advanced Data Integration Guide S: Data Integration with Avaki Studiovirtualdatabase --show-tables comm

Data Integration with Sybase Avaki Studio 11Starting Avaki StudioIn the workspace directory, Studio creates a subdirectory for each project. Files of

AD: Administration Guide API: API Guide C: Command Reference O: OvertureIndex-32 Master IndexWSDLsabout API:2as SOAP contracts API:3AvakiA

Getting started with Avaki Studio12 Data Integration with Sybase Avaki StudioThe Resource perspectiveAfter you specify a workspace directory, a window

Data Integration with Sybase Avaki Studio 13Starting Avaki StudioWe strongly recommend that you look at the Eclipse documentation, which is avail-able

Getting started with Avaki Studio14 Data Integration with Sybase Avaki StudioCreating a projectTo use the tools provided by Avaki Studio, you must ope

Data Integration with Sybase Avaki Studio 15Creating a projectNew Avaki Studio Project wizard appears. Step 3 In the Project name field, enter a name

Getting started with Avaki Studio16 Data Integration with Sybase Avaki StudioStep 6 Click Finish to create the project. The project includes a starter

Data Integration with Sybase Avaki Studio 17The Avaki perspective: A tourThe Avaki perspective: A tourThis section explains the purposes of the panes

Data Integration with Sybase Avaki Studio iTable of contents Preface viiAudience viiOrganization viiiRelated documentation ixHow to contact Avaki sup

Getting started with Avaki Studio18 Data Integration with Sybase Avaki StudioTo open a saved view model, expand the view model’s project folder in the

Data Integration with Sybase Avaki Studio 19The Avaki perspective: A tourgood places to start are the /GeneratedViews, /Shares, and /WSDLs folders. (F

Getting started with Avaki Studio20 Data Integration with Sybase Avaki StudioManaging the data catalogYou can use the Data Catalog view to manage the

Data Integration with Sybase Avaki Studio 21The Avaki perspective: A tourThe view model editorThe view model editing pane lets you create, display, an

Getting started with Avaki Studio22 Data Integration with Sybase Avaki StudioThe metadata model editorThe metadata model editing pane lets you create,

Data Integration with Sybase Avaki Studio 23Setting preferencesView Model Parameters viewThe View Model Parameters tab lets you create and manipulate

Getting started with Avaki Studio24 Data Integration with Sybase Avaki StudioNote Be sure to click Apply on each page of the Preferences dialog when y

Data Integration with Sybase Avaki Studio 25Setting preferencesStep 9Click Model Editor in the browser pane. Studio displays the Model preferences. St

Getting started with Avaki Studio26 Data Integration with Sybase Avaki StudioWorking with Avaki StudioThis section provides an overview of one kind of

Data Integration with Sybase Avaki Studio 27Working with Avaki StudioProjection to combine columns” on page 47. For additional information about oper-

ii Data Integration with Sybase Avaki StudioThe palette 20The view model editor 21Adding and removing objects 21View model tabs 21The metadata model e

Getting started with Avaki Studio28 Data Integration with Sybase Avaki Studio

Data Integration with Sybase Avaki Studio 29Chapter 3Creating view modelsThis chapter is a tutorial that walks you through the process of creating a v

Creating view models30 Data Integration with Sybase Avaki StudioThe exerciseIn this tutorial, we’ll create a data service for the human resources depa

Data Integration with Sybase Avaki Studio 31The exercise• HIREDATE: The date the employee was hired• SAL: The employee’s salary• COMM: The employee’s

Creating view models32 Data Integration with Sybase Avaki StudioCreating database connectorsTo extract data from a relational database, your view mode

Data Integration with Sybase Avaki Studio 33Creating database connectorsStep 3Fill in the form:• Connector Name: Enter a name for this database connec

Creating view models34 Data Integration with Sybase Avaki StudioStep 4 Click Next. The second page of the form appears: Step 5 Fill in the form:• Name

Data Integration with Sybase Avaki Studio 35Creating database connectorsStep 6Click Next to display the next page of the new database connector form.

Creating view models36 Data Integration with Sybase Avaki Studiothought of as single-use database operations. You can run an ad-hoc query using either

Data Integration with Sybase Avaki Studio 37Creating database connectorsfor the database vendor’s JDBC driver. (For purposes of the tutorial, leave th

Data Integration with Sybase Avaki Studio iiiRed borders: Errors in your view model 60Working with schemas 60Showing and hiding elements’ schemas 60

Creating view models38 Data Integration with Sybase Avaki StudioStep 8 Click Finish to save the settings you’ve entered. Avaki Studio creates the data

Data Integration with Sybase Avaki Studio 39Creating database operationsStep 3(Optional) To locate your database connectors in the data catalog view,

Creating view models40 Data Integration with Sybase Avaki StudioStep 6 In the Database Connector field, select a database connector, then click Next.

Data Integration with Sybase Avaki Studio 41Creating database operationsStep 13Click Next. (Do not check the “Calls a stored procedure” or “Supports b

Creating view models42 Data Integration with Sybase Avaki StudioStep 16 For the EMP database operation, which has a parameter, enter a value that Stud

Data Integration with Sybase Avaki Studio 43Using the view model wizardUsing the view model wizardIf you haven’t created a Studio project yet, see “Cr

Creating view models44 Data Integration with Sybase Avaki StudioConfiguring input sourcesIn our view model, Input Source elements represent the databa

Data Integration with Sybase Avaki Studio 45Joining result setsJoining result setsTo create a Join operator to combine the result sets from the two in

Creating view models46 Data Integration with Sybase Avaki StudioStep 6 Double-click the Join operator to open the Join Properties dialog. Step 7 Selec

Data Integration with Sybase Avaki Studio 47Using Projection to combine columnsUsing Projection to combine columnsTo create a Projection operator, fol

iv Data Integration with Sybase Avaki StudioChapter 5 Metadata modeling 77About metadata models 78Importing metadata models 79Creating and editing me

Creating view models48 Data Integration with Sybase Avaki StudioStep 6 Double-click the Projection operator to open the Projection Properties dialog.

Data Integration with Sybase Avaki Studio 49Using Projection to combine columnsStep 14Use the Move Up button to move the NameNumberJob column the four

Creating view models50 Data Integration with Sybase Avaki StudioTesting the view modelWhen your view model is complete, you can test it by selecting E

Data Integration with Sybase Avaki Studio 51Deploying the view model as a data serviceDeploying the view model as a data serviceFollow these steps to

Creating view models52 Data Integration with Sybase Avaki StudioThinking ahead: load sharing for data service executionBy default, a data service runs

Data Integration with Sybase Avaki Studio 53Chapter 4The view model editorConsult this chapter for general information on using Avaki Studio’s view mo

The view model editor54 Data Integration with Sybase Avaki StudioCommon features of view model componentsThis section discusses features common to the

Data Integration with Sybase Avaki Studio 55Common features of view model componentsFor example, to add an Order By operator to your model using the p

The view model editor56 Data Integration with Sybase Avaki StudioStep 3 Navigate in the data catalog view to the object you want to use as in input so

Data Integration with Sybase Avaki Studio 57Common features of view model componentsmodel. You might want to move elements around in order to make roo

Data Integration with Sybase Avaki Studio vGenerator properties 118Entering iteration control code 118Defining the output columns 119Group By 121Conn

The view model editor58 Data Integration with Sybase Avaki StudioStep 5 Click on the object the arrow should go to. If this object has more than one i

Data Integration with Sybase Avaki Studio 59Common features of view model componentsTo edit an element’s name:Step 1 Open the element’s properties dia

The view model editor60 Data Integration with Sybase Avaki StudioRed borders: Errors in your view model Your view model may have errors in it. Some of

Data Integration with Sybase Avaki Studio 61Common features of view model componentscharacters (including spaces, punctuation, accented characters, an

The view model editor62 Data Integration with Sybase Avaki StudioPrecision and scale. The meaning of the precision and scale fields for a column depen

Data Integration with Sybase Avaki Studio 63Using global parametersUsing global parametersSome view models obtain all necessary input from database op

The view model editor64 Data Integration with Sybase Avaki StudioAdding global parameters To add a parameter to your model, click the Add Parameter bu

Data Integration with Sybase Avaki Studio 65Using global parametersvariables.global.State.length == 2If you leave the Validation Expression field blan

The view model editor66 Data Integration with Sybase Avaki StudioUsing expressions within Avaki Studio Most of the operators in Avaki Studio allow you

Data Integration with Sybase Avaki Studio 67Using expressions within Avaki Studio• CurrentUser.isMemberOf("myDomain", "DefaultAuthServi

vi Data Integration with Sybase Avaki StudioOrder By properties 160Specifying the sort criteria 160Projection 161Connections 161Performance notes 161

The view model editor68 Data Integration with Sybase Avaki StudioJavaScript references:• http://www.devguru.com/Technologies/ecmascript/quickref/javas

Data Integration with Sybase Avaki Studio 69Using expressions within Avaki StudioWorking with variables Often you will need to create variables when c

The view model editor70 Data Integration with Sybase Avaki StudioAllowed types for variables All values in the variables structure must be of one of t

Data Integration with Sybase Avaki Studio 71The expressions menuThe expressions menu You don’t need to know any JavaScript to write simple expressions

The view model editor72 Data Integration with Sybase Avaki StudioOperators The Operators submenu lists JavaScript operators that you can use to modify

Data Integration with Sybase Avaki Studio 73The expressions menuAvaki Functions The Avaki Functions submenu provides utility functions that you can us

The view model editor74 Data Integration with Sybase Avaki Studio• column: the column whose data you want. You can specify the column either using a 1

Data Integration with Sybase Avaki Studio 75Advanced topicsPropagating name changes through the view modelIf an operator name or a parameter name chan

The view model editor76 Data Integration with Sybase Avaki StudioPerformance of sort-based operators Several operators must sort their inputs. These i

Data Integration with Sybase Avaki Studio 77Chapter 5Metadata modelingThis chapter describes how to create metadata models, import them into Avaki Stu

Data Integration with Sybase Avaki Studio viiPrefaceThis guide, Data Integration with Sybase Avaki Studio, explains how to use Avaki Stu-dio software.

Metadata modeling78 Data Integration with Sybase Avaki StudioAbout metadata modelsIn Avaki Studio, a metadata model expresses a schema. Metadata model

Data Integration with Sybase Avaki Studio 79Importing metadata modelsYou can ensure that Avaki data services you create conform to a particular schema

Metadata modeling80 Data Integration with Sybase Avaki StudioFollow these steps to import a metadata model into Avaki Studio:Step 1 Select File > I

Data Integration with Sybase Avaki Studio 81Importing metadata modelsStep 3Click Browse to list the project folders into which you can import the mode

Metadata modeling82 Data Integration with Sybase Avaki StudioStep 5 Click Next. The Import Type window appears. Step 6 Click the data model type to im

Data Integration with Sybase Avaki Studio 83Importing metadata modelsStep 7Click Browse to navigate to the location of your metadata model, select the

Metadata modeling84 Data Integration with Sybase Avaki StudioStep 10 Select any table or tables you want to import from the displayed list and click F

Data Integration with Sybase Avaki Studio 85Creating and editing metadata modelsCreating and editing metadata modelsIt’s generally easier to import me

Metadata modeling86 Data Integration with Sybase Avaki StudioStep 3 Click Browse to navigate to the container where you want your new model to reside,

Data Integration with Sybase Avaki Studio 87Creating and editing metadata modelsStep 7To edit the table, double click it and the Schema Editor window