M2M AD301 Betriebsanweisung Seite 52
- Seite / 230
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Creating view models
40 Data Integration with Sybase Avaki Studio
Step 6 In the Database Connector field, select a database connector, then click Next.
Step 7 In the Name field, enter a name for the database operation you’re creating.
Step 8 (Optional) In the Description field, enter a description of the database operation.
Step 9 In the SQL Statement field, enter the query that this database operation will execute:
• For getAllDepts, enter select * from dept
• For getEmpGivenName, enter select * from emp where ENAME = ?
Step 10 In the Modifies Database field, leave the No button checked. (Click the Yes button
when you create a database operation that performs an update.)
Step 11 In the Caching field, choose the caching behavior for the results of this database oper-
ation. (It’s ok to keep the default, “Don’t cache.”)
Step 12 (Optional) In the Run as field, specify the user account under which this database
operation will run.
- Integration 1
- Avaki Studio 1
- Table of contents 3
- Creating view models 29 4
- The view model editor 53 4
- Metadata modeling 77 6
- Managing the data catalog 97 6
- Operator reference 107 6
- Glossary 175 8
- Audience 9
- Organization 10
- Related documentation 11
- By telephone 12
- On the web 12
- View models in Avaki Studio 13
- Background: Avaki concepts 14
- What is a view model? 14
- Data flow 16
- Expressions in operators 16
- Performance 17
- Operators 18
- Installing Avaki Studio 21
- Starting Avaki Studio 22
- Filename extension Purpose 23
- The Resource perspective 24
- Creating a project 26
- The Avaki perspective: A tour 29
- The data catalog view 30
- The palette 32
- The view model editor 33
- The metadata model editor 34
- The bottom pane 34
- Setting preferences 35
- Working with Avaki Studio 38
- Creating view models 41
- The exercise 42
- • SAL: The employee’s salary 43
- • dept_db 43
- • emp_db 43
- Creating database connectors 44
- Step 5 Fill in the form: 46
- SQL queries against the data 47
- SQL views. Ad-hoc queries 47
- Creating database operations 50
- Click Next 53
- Using the view model wizard 55
- Configuring input sources 56
- Joining result sets 57
- Step 9 Click OK 58
- Testing the view model 62
- EII Administration Guide 64
- Creating components 66
- XML-to-Result-Set transform 67
- HTTP requests or web ser 67
- Properties dialogs 70
- Working with schemas 72
- Types Precision Scale 74
- Using global parameters 75
- Adding global parameters 76
- Modifying global parameters 77
- Deleting global parameters 77
- Reordering global parameters 77
- Simple expressions 78
- Boolean expressions 78
- Complex expressions 79
- Expressions and JavaScript 79
- Accessing global parameters 80
- Working with variables 81
- Allowed types for variables 82
- The expressions menu 83
- Avaki Functions 85
- Advanced topics 87
- About metadata models 90
- Importing metadata models 91
- Designer 94
- AV M ) editor. It is 97
- Metadata modeling 100
- EMP table 101
- Deploying metadata models 103
- Deriving metadata models 105
- Deleting metadata models 106
- Undeploying metadata models 107
- Managing the data catalog 109
- Modifying ACLs 110
- Managing attributes 113
- Managing categories 116
- Adding objects to categories 117
- Deleting categories 118
- Operator reference 119
- Aggregate 120
- Aggregate properties 121
- Aggregate functions 122
- Connections 123
- Custom properties 124
- Generator 129
- Generator properties 130
- INTEGER 132
- Group By 133
- Performance notes 134
- Group By properties 134
- Input Source 137
- Input Source Properties 138
- On the next page (“Database 140
- • The entire SOAP response 147
- • No transform 148
- • CSV to Result Set 149
- • XML to Result Set 149
- XML document 152
- OK to save your changes 155
- Intersection 160
- Iterator 161
- Iterator properties 162
- Join properties 166
- Algorithm Description 167
- Join Type Description 168
- NULL values 168
- Multiplexer 169
- Multiplexer properties 170
- Order By 171
- Order By properties 172
- Projection 173
- Projection properties 174
- Result properties 176
- Select properties 177
- Splitter 178
- Splitter properties 179
- Union properties 181
- Update properties 183
- Glossary 187
- CIFS share 188
- CALL) that 192
- EII) A software system that 192
- EII) system provides secure 193
- CIFS shares 196
- SQL queries on the 198
- Master Index 199
- Index-2 Master Index 200
- Master Index Index-3 201
- Index-4 Master Index 202
- Master Index Index-5 203
- Index-6 Master Index 204
- Master Index Index-7 205
- Index-8 Master Index 206
- Master Index Index-9 207
- Index-10 Master Index 208
- Master Index Index-11 209
- Index-12 Master Index 210
- Master Index Index-13 211
- Index-14 Master Index 212
- Master Index Index-15 213
- Index-16 Master Index 214
- Master Index Index-17 215
- Index-18 Master Index 216
- Master Index Index-19 217
- Index-20 Master Index 218
- Master Index Index-21 219
- Index-22 Master Index 220
- Master Index Index-23 221
- Index-24 Master Index 222
- Master Index Index-25 223
- Index-26 Master Index 224
- Master Index Index-27 225
- Index-28 Master Index 226
- Master Index Index-29 227
- Index-30 Master Index 228
- Master Index Index-31 229
- Index-32 Master Index 230
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.081 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern