Extended Systems OneBridge 4.1 Uživatelská příručka Strana 15
- Strana / 222
- Tabulka s obsahem
- ŘEŠENÍ PROBLÉMŮ
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
User’s Guide 1
CHAPTER 1
Sybase IQ ETL
Sybase IQ ETL architecture
When you install Sybase IQ ETL on Windows, you install Sybase IQ ETL
Development and Sybase ETL Server. You can add multiple ETL Servers
on different operating systems to your installation.
Sybase IQ ETL Development
Sybase IQ ETL Development is divided into two major components:
• Sybase IQ ETL Development desktop — provides the graphical user
interface. Use the desktop to create and design data transformation
projects.
• Sybase IQ ETL Development engine — controls the actual
processing, such as connecting to databases and executing
procedures.
Topic Page
Sybase IQ ETL architecture 1
Projects and jobs 2
Component concepts 2
Running a project 3
Customizing a project 3
Understanding repositories 4
Converting datatypes and data formats 5
SQL 5
Tools 6
Unicode support 6
Expressions 6
Internal database 6
- 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
Související produkty a manuály pro Servery Extended Systems OneBridge 4.1
(88 stránky)© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.049 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce