Elixir Data Designer User Manual

Release 7.2

Elixir Technology Pte Ltd

All rights reserved.

Solaris, Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. Microsoft and Windows are trademarks of Microsoft Corporation.

2008


Table of Contents

1. About Elixir Data Designer
Introduction
Features of Elixir Data Designer
Datasource Security
2. The Elixir Data Designer Workspace
Overview
Case Study
3. JDBC DataSource
JDBC Drivers
ODBC Connectivity
JDBC DataSource Wizard
JDBC DataSource Details
SQL
Infer Schema
Connection Pools
Working with a JDBC DataSource
Using the JDBC/ODBC bridge driver
Using a Callable Statement
Using JNDI Connectivity
4. Composite DataSources
Overview
Adding a Composite DataSource
Standard Diagram Operations
Moving the processors
Flow Connection Nodes
Data Processors
DataSource Processor
Flow
Join Processor
Working with Joins
Sort Processor
Group On Options
Working With Sort processors
Derivative Processor
Working with the Derivative processor
Filter Processor
Combining Filters
Working with Filters
Concat Processor
Working with Concat Processor
Parameter Processor
Working with Parameter processor
SubFlow Processor
Processor
Cleansing
General
DataDrop Processor
Note
Cube Processor
Working with Cube Processor
DataStore Processor
CSV File
Excel File
JDBC File
None
Text File
XML File
Custom Java DataStore
Composite JavaScript
Case Study
5. Text DataSource
Overview
Text DataSource Wizard
Working with Text DataSource
Using Separator Characters
Defining a URL with a Dynamic Parameter
Using Fixed Width Columns
Using Regular Expressions
Using Start and Stop Expressions
6. XML DataSource
Overview
XML DataSource Wizard
Use of Merge
Subtree Optimization
HTML
Working with XML DataSources
7. Properties DataSource
Overview
Properties DataSource Wizard
Working with Properties DataSources
Testing the Data Flow
Passing Parameters to the Flow
8. Reference DataSource
Overview
Reference DataSource Wizard
Working with Reference DataSource
Wrapping an Excel DataSource
Wrapping a Composite DataSource
9. Object DataSource
Overview
The Classpath
Object DataSource Wizard
Guided JavaScript Builder
Manual Creation
Object DataSource API
PushContext
DataListener
DataGroup
DataRecord
Working with Object DataSources
10. LDAP DataSource
Overview
LDAP DataSource Wizard
Working with LDAP DataSource
11. Filesystem DataSource
Overview
Filesystem DataSource Wizard
Filesystem Schema
12. Tabular DataSource
Overview
Tabular DataSource Wizard
13. Random DataSource
Overview
Random DataSource Wizard
Expression
Literal
Script
14. ARFF DataSource
Overview
ARFF DataSource Wizard
15. Cache Datasource
Overview
Cache Datasource Wizard
A. Dynamic Parameters
Dynamic Parameters
Dynamic Parameter Elements
Dynamic Parameter Names
Dynamic Parameter Types
Ordering Dynamic Parameters
Dynamic Parameters with a Nested DataSource
Example Declaration of Dynamic Parameters.
B. Samples
Availability

List of Figures

1.1. Set Security Options
2.1. Basic Data Workspace
2.2. Composite Data Workspace
2.3. New DataSource
2.4. Define Text DataSource - Page One
2.5. Define Text DataSource - Page Two
3.1. Create New Data Source
3.2. Select Database
3.3. JDBC DataSource Wizard
3.4. Define JDBC DataSource
3.5. Elixir Query Builder
3.6. Callable Tab
3.7. Define DataSource Schema
3.8. Connection Pool Wizard
3.9. Right-click on Connection Pool
3.10. Datasource Wizard
3.11. JNDI Values
4.1. Composite DataSource
4.2. Result Wizard
4.3. DataSource Wizard
4.4. Sample Flow
4.5. Join Wizard
4.6. Sample Join Flow
4.7. Join Wizard
4.8. Inner Join Result
4.9. Outer Join Result
4.10. Cross Join Result
4.11. Sort Wizard
4.12. Add Sort Item
4.13. Extract Options
4.14. Sample Sort Flow
4.15. Sort Dialog
4.16. Group on - Each Result
4.17. Group on - All Result
4.18. Group on - Range Result
4.19. Group on - Range by Country Result
4.20. Completed Sort Dialog
4.21. Derivative Wizard
4.22. Add Column Dialog
4.23. Sample Derivative Flow
4.24. Completed Add Column Dialog
4.25. Derived Result
4.26. Completed Add Column Screen
4.27. Date Manipulations Result
4.28. Filter Wizard
4.29. Sample Filter Flow
4.30. Filter Result
4.31. Concat Wizard
4.32. Sample Concat Flow
4.33. Parameter Wizard
4.34. Completed Properties DataSource
4.35. Sample Parameter Flow
4.36. Parameter Result
4.37. SubFlow Sample
4.38. Input Wizard
4.39. Remove Duplicates Processor
4.40. Invert Data Processor
4.41. Javascript Processor
4.42. SQL Processor Wizard
4.43. Sample DataDrop Flow
4.44. Sample DataDrop Sub Flow
4.45. Cube Wizard
4.46. Add Hierarchy
4.47. Cube Axes Screen
4.48. Cube Measures Screen
4.49. Add Measure Dialog
4.50. Sample Cube Flow
4.51. Infer Schema Screen
4.52. Cube Result
4.53. Sample Datastore Flow
4.54. CVS Output
4.55. Excel Output
4.56. XML Output
4.57. Custom Java Option Screen
4.58. Case Study Composite Diagram
4.59. View Cube Output
5.1. Define Text DataSource
5.2. Separator Type Properties
5.3. Fixed Width Type Properties
5.4. Regular Expression Type Properties
5.5. Regular Expression Designer
5.6. Sample Text DataSource
5.7. Dynamic Parameters
5.8. Fixed Width Sample
5.9. Log file
5.10. Regular Expression Designer
6.1. An XML Tree
6.2. Define XML DataSource
6.3. Choosing the XPath Builder
6.4. Merge Space
6.5. Merge Group
6.6. XPath Builder
6.7. XPaths Completed
6.8. XML DataSource Schema
6.9. DataSource Results
7.1. Properties DataSource Wizard
7.2. Add Column
7.3. Text DataSource Parameters
7.4. Properties DataSource
7.5. Derivative Wizard
7.6. Test Output
7.7. Full Output
7.8. Prop_Emp1
7.9. Filter Wizard
7.10. Output
8.1. Reference DataSource Wizard
8.2. Empdata.xls
8.3. Define Name
8.4. Excel DataSource Sample
8.5. Reference a DataSource
8.6. Sample Output
8.7. Filter Condition
8.8. Sample Reference
9.1. Object DataSource Wizard
9.2. Guided JavaScript Builder
9.3. JavaScript Editor
9.4. Sample Data Iterator
9.5. Sample Data Class
10.1. LDAP DataSource Wizard
10.2. Security Parameters
10.3. LDAP DataSource Schema
10.4. LDAP Datasource Wizard
10.5. Completed Datasource Wizard
10.6. Organization Result
11.1. Filesystem DataSource Wizard
12.1. Tabular DataSource Wizard
12.2. Tabular DataSource Wizard Page Two
13.1. Random DataSource Wizard
13.2. Edit Column
14.1. ARFF DataSource Wizard
14.2. Define ARFF Schema
15.1. Cache DataSource Wizard
15.2. Cache DataSource Parameters

List of Tables

4.1. Filter Criteria