Download Elixir Data Designer User Manual

Elixir Data Designer User Manual
Text File ..................................................................................................... 67
XML File ................................................................................................... 67
Custom Java DataStore .................................................................................. 68
Composite JavaScript ............................................................................................ 69
Case Study .......................................................................................................... 71
5. Text DataSource ....................................................................................................... 76
Overview ............................................................................................................ 76
Text DataSource Wizard ........................................................................................ 76
Working with Text DataSource ................................................................................ 80
Using Separator Characters ............................................................................ 80
Defining a URL with a Dynamic Parameter ....................................................... 81
Using Fixed Width Columns ........................................................................... 82
Using Regular Expressions ............................................................................. 83
Using Start and Stop Expressions .................................................................... 85
6. XML DataSource ...................................................................................................... 86
Overview ............................................................................................................ 86
XML DataSource Wizard ....................................................................................... 87
Use of Merge ....................................................................................................... 89
Subtree Optimization ............................................................................................ 90
HTML ............................................................................................................... 90
Working with XML DataSources ............................................................................. 90
7. Properties DataSource ................................................................................................ 94
Overview ............................................................................................................ 94
Properties DataSource Wizard ................................................................................. 94
Working with Properties DataSources ....................................................................... 95
Testing the Data Flow .................................................................................... 95
Passing Parameters to the Flow ....................................................................... 99
8. Reference DataSource .............................................................................................. 102
Overview .......................................................................................................... 102
Reference DataSource Wizard ....................................................................... 102
Working with Reference DataSource ...................................................................... 103
Wrapping an Excel DataSource ..................................................................... 103
Wrapping a Composite DataSource ................................................................ 106
9. Object DataSource ................................................................................................... 108
Overview .......................................................................................................... 108
The Classpath .................................................................................................... 108
Object DataSource Wizard .................................................................................... 108
Guided JavaScript Builder ............................................................................ 109
Manual Creation ......................................................................................... 110
Object DataSource API ........................................................................................ 112
PushContext .............................................................................................. 112
DataListener .............................................................................................. 112
DataGroup ................................................................................................ 113
DataRecord ............................................................................................... 113
Working with Object DataSources .......................................................................... 113
10. LDAP DataSource ................................................................................................. 116
Overview .......................................................................................................... 116
LDAP DataSource Wizard .................................................................................... 116
Working with LDAP DataSource ........................................................................... 119
11. Filesystem DataSource ........................................................................................... 122
Overview .......................................................................................................... 122
Filesystem DataSource Wizard .............................................................................. 122
Filesystem Schema ............................................................................................. 123
12. Tabular DataSource ................................................................................................ 124
Overview .......................................................................................................... 124
Tabular DataSource Wizard .................................................................................. 124
13. Random DataSource ............................................................................................... 126
Overview .......................................................................................................... 126
iv