Talend Open Studio for Data Integration
iv Talend Open Studio for Data Integration User Guide
4.4.2. How to centralize contexts and
variables .................................. 97
4.4.3. How to use the SQL
Templates ............................... 107
4.5. Handling Jobs: advanced subjects ....... 107
4.5.1. How to map data flows .......... 107
4.5.2. How to create queries using
the SQLBuilder ......................... 108
4.5.3. How to download/upload
Talend Community components ........ 111
4.5.4. How to install external
modules ................................. 118
4.5.5. How to launch a Job
periodically (feature deprecated) ....... 120
4.5.6. How to use the tPrejob and
tPostjob components .................... 122
4.5.7. How to use the Use Output
Stream feature .......................... 123
4.6. Handling Jobs: miscellaneous
subjects ......................................... 124
4.6.1. How to share a database
connection .............................. 124
4.6.2. How to define the Start
component .............................. 125
4.6.3. How to handle error icons on
components or Jobs ..................... 126
4.6.4. How to add notes to a Job
design ................................... 128
4.6.5. How to display the code or the
outline of your Job ..................... 129
4.6.6. How to manage the subjob
display .................................. 130
4.6.7. How to define options on the
Job view ................................ 132
4.6.8. How to find components in
Jobs ..................................... 133
4.6.9. How to set default values in
the schema of an component ........... 135
Chapter 5. Managing data integration
Jobs .................................................. 137
5.1. Activating/Deactivating a Job or a
sub-job ......................................... 138
5.1.1. How to disable a Start
component .............................. 138
5.1.2. How to disable a non-Start
component .............................. 138
5.2. Importing/exporting items or Jobs ....... 139
5.2.1. How to import items ............. 139
5.2.2. How to export Jobs .............. 141
5.2.3. How to export items ............. 152
5.2.4. How to change context
parameters in Jobs ...................... 154
5.3. Managing repository items ............... 155
5.3.1. How to handle updates in
repository items ......................... 155
5.4. Searching a Job in the repository ........ 157
5.5. Managing Job versions ................... 159
5.6. Documenting a Job ....................... 160
5.6.1. How to generate HTML
documentation .......................... 160
5.6.2. How to update the
documentation on the spot .............. 161
5.7. Handling Job execution .................. 161
5.7.1. How to deploy a Job on
SpagoBI server ......................... 161
Chapter 6. Mapping data flows ............ 165
6.1. tMap and tXMLMap interfaces ......... 166
6.2. tMap operation ........................... 167
6.2.1. Setting the input flow in the
Map Editor ............................. 168
6.2.2. Mapping variables ............... 175
6.2.3. Using the expression editor ...... 176
6.2.4. Mapping the Output setting ...... 180
6.2.5. Setting schemas in the Map
Editor ................................... 185
6.2.6. Solving memory limitation
issues in tMap use ...................... 188
6.2.7. Handling Lookups ............... 190
6.3. tXMLMap operation ..................... 191
6.3.1. Using the document type to
create the XML tree .................... 192
6.3.2. Defining the output mode ........ 202
6.3.3. Editing the XML tree schema .... 207
Chapter 7. Managing Metadata ............ 209
7.1. Objectives ................................. 210
7.2. Setting up a DB connection .............. 211
7.2.1. Step 1: General properties ........ 211
7.2.2. Step 2: Connection ............... 212
7.2.3. Step 3: Table upload ............. 213
7.2.4. Step 4: Schema definition ........ 216
7.3. Setting up a Hive connection ............. 217
7.3.1. Prerequisites ..................... 217
7.3.2. Step 1: General properties ........ 217
7.3.3. Step 2: Connection ............... 217
7.4. Setting up a JDBC schema ............... 219
7.4.1. Step 1: General properties ........ 219
7.4.2. Step 2: Connection ............... 219
7.4.3. Step 3: Table upload ............. 221
7.4.4. Step 4: Schema definition ........ 222
7.5. Setting up a SAS connection ............. 222
7.5.1. Prerequisites ..................... 222
7.5.2. Step 1: General properties ........ 222
7.5.3. Step 2: Connection ............... 222
7.6. Setting up a File Delimited schema ...... 224
7.6.1. Step 1: General properties ........ 224
7.6.2. Step 2: File upload ............... 225
7.6.3. Step 3: Schema definition ........ 225
7.6.4. Step 4: Final schema ............. 227
7.7. Setting up a File Positional schema ...... 228
7.7.1. Step 1: General properties ........ 229
7.7.2. Step 2: Connection and file
upload ................................... 229
7.7.3. Step 3: Schema refining .......... 230
7.7.4. Step 4: Finalizing the end
schema .................................. 230
7.8. Setting up a File Regex schema .......... 231
7.8.1. Step 1: General properties ........ 231
7.8.2. Step 2: File upload ............... 231
7.8.3. Step 3: Schema definition ........ 232
7.8.4. Step 4: Finalizing the end
schema .................................. 232
7.9. Setting up an XML file schema .......... 232
7.9.1. Setting up an XML schema for
an input file ............................. 233
7.9.2. Setting up an XML schema for
an output file ........................... 240
7.10. Setting up a File Excel schema ......... 249
7.10.1. Step 1: General properties ...... 250
7.10.2. Step 2: File upload .............. 250
7.10.3. Step 3: Schema refining ........ 251
7.10.4. Step 4: Finalizing the end
schema .................................. 252
7.11. Setting up a File LDIF schema ......... 253
7.11.1. Step 1: General properties ...... 253
7.11.2. Step 2: File upload .............. 253
7.11.3. Step 3: Schema definition ....... 254
7.11.4. Step 4: Finalizing the end
schema .................................. 255
7.12. Setting up an LDAP schema ............ 255
7.12.1. Step 1: General properties ...... 256
7.12.2. Step 2: Server connection ....... 256
7.12.3. Step 3: Authentication and
DN fetching ............................ 256
我的内容管理
收起
我的收益 登录查看自己的收益
我的积分
登录查看自己的积分
我的C币
登录后查看C币余额
我的收藏 
我的下载 
下载帮助 
评论2