Extended Systems OneBridge 4.1 Guía de usuario Pagina 31
- Pagina / 222
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
CHAPTER 2 Sybase IQ ETL Development Desktop
User’s Guide 17
• Drag and drop the component to an empty spot or to an existing
connection in the Design section.
• Right-click a component and select Add.
• Double click a component.
• Right-click a component to connect with a new component, select
Add Right Component or Add Left Component, and select a
component to add it to.
Customizing preferences
Use the Preferences window to customize the following groups of settings in
the Sybase IQ ETL Development environment:
• Workbench
•Engine
• GRID Engine
• Performance Log
❖ To customize preferences
1 Select File | Preferences. The Preferences window appears.
2 From the Workbench list, select Appearance and set the following options:
• Locale to be used for the user interface — select the locale language
for your environment. You can select
_de (German), _en_US (US
English), or
_en_GB (UK English). The default is _en_US.
• Show assistant for creating projects — specify whether to show the
The Assistant, which contains information regarding the current state
of the open project. The Assistant helps guide you through the process
of completing a project. This option is selected by default.
• Font for displaying source data — select the font that you want to use
for displaying source data. This setting is useful when you work with
non-western character sets, such as UNICODE character sets. The
default font is Tahoma.
- Sybase IQ ETL 1
- DC00608-01-0410-01 2
- October 2006 2
- Contents 3
- User’s Guide vii 7
- User’s Guide ix 9
- Sybase IQ ETL 4.1 10
- About This Book 11
- Sybase IQ ETL 4.1 12
- About This Book 13
- If you need help 14
- Projects and jobs 16
- Component concepts 16
- Running a project 17
- Customizing a project 17
- Understanding repositories 18
- CHAPTER 1 Sybase IQ ETL 19
- Unicode support 20
- Expressions 20
- Internal database 20
- 8 Sybase IQ ETL 4.1 22
- Sybase IQ ETL Development 23
- Using the Navigator 24
- Administering the repository 25
- Administering user accounts 27
- Using the Properties section 28
- Using the Design section 29
- Adding components 30
- Customizing preferences 31
- User’s Guide 19 33
- 20 Sybase IQ ETL 4.1 34
- Getting Started 35
- Creating your first project 36
- Adding a data sink 37
- Adding a data calculator 38
- Simulating the project 39
- 26 Sybase IQ ETL 4.1 40
- Projects and Jobs 41
- Managing projects 42
- User’s Guide 29 43
- ❖ To simulate a project 43
- Viewing current mappings 45
- Managing port attributes 46
- Viewing a simulation flow 46
- User’s Guide 33 47
- User’s Guide 35 49
- Managing jobs 50
- Executing a job 51
- Cancelling job execution 52
- Creating Jobs 52
- Building a migration template 54
- User’s Guide 41 55
- Managing a migration template 57
- 44 Sybase IQ ETL 4.1 58
- Advanced Concepts and Tools 59
- Opening Content Explorer 60
- Using the Design area 60
- Creating queries 61
- Content Explorer 62
- User’s Guide 49 63
- Evaluate property is 65
- Including variables 66
- Using functions 67
- Using Square Bracket Notation 68
- Entering SQL statements 68
- Entering queries 69
- Validating queries 69
- Query designer 69
- SELECT * FROM 70
- PRODUCT [uTracelevel(5)] 70
- User’s Guide 57 71
- Features 71
- Edit and Debug mode 72
- User’s Guide 59 73
- ❖ To step through the code 73
- ❖ To step to a Breakpoint 73
- Special JavaScript features 74
- Analyzing performance data 77
- Example reports 79
- Project execution history 80
- User’s Guide 67 81
- 68 Sybase IQ ETL 4.1 82
- Components 83
- Setting required properties 84
- Setting up a component 85
- Overview 86
- Creating a SQLite table 89
- Evaluating SBN expressions 91
- Encrypting properties 91
- Modifying components 92
- Data blocks and visualization 92
- Managing port structures 93
- DB Data Provider Index Load 97
- Text Data Provider 99
- Properties 100
- CHAPTER 6 Components 101
- XML via SQL Data Provider 102
- Optional properties 103
- Source components 104
- Transformation components 107
- Character Mapper 113
- Using Lookup components 115
- Required properties 116
- DB Lookup Dynamic component 118
- Staging components 121
- Processing components 123
- Destination components 124
- DB Data Sink Update component 127
- DB Data Sink Delete component 129
- Text Data Sink 130
- Job components 135
- Synchronizer component 136
- Multi-Project component 137
- Finish component 138
- Error component 138
- Function Reference 139
- Aggregation functions 140
- Bit functions 141
- Boolean functions 142
- Sybase IQ ETL 4.1 144
- 1 if the parameter is null 145
- Conversion functions 146
- Date and time functions 151
- now modifier 154
- Errorhandling functions 163
- File functions 166
- Formatting functions 168
- Fuzzy search functions 170
- Lookup functions 171
- IF construct: 172
- Miscellaneous functions 174
- 166 Sybase IQ ETL 4.1 180
- 168 Sybase IQ ETL 4.1 182
- 170 Sybase IQ ETL 4.1 184
- Network functions 185
- Numeric functions 186
- Script functions 191
- String functions 191
- Operator functions 200
- Trigonometric functions 202
- Sybase ETL Server 205
- Communication 206
- Using the server 206
- GRID Engine Server 206
- Stop a server 207
- Install as a System Service 207
- Troubleshooting 208
- Command line parameters 209
- INI file settings 210
- Default.ini 211
- GridNode.ini 211
- 198 Sybase IQ ETL 4.1 212
- Queuing and Executing 213
- Process Calls 213
- Configuring ProcessQ calls 214
- 202 Sybase IQ ETL 4.1 216
- 204 Sybase IQ ETL 4.1 218
- 206 Sybase IQ ETL 4.1 220
- 208 Sybase IQ ETL 4.1 222
Relacionado con productos y manuales para Servidores Extended Systems OneBridge 4.1
(88 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.039 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales