Elixir Universe

Release 4.0.0

Elixir Technology Pte Ltd

All rights reserved.

Java is a trademark or registered trademark of Oracle Corporation in the United States and other countries. Microsoft and Windows are trademarks of Microsoft Corporation.

2015


Table of Contents

1. Introduction
What is a Universe?
2. Universe Types
JDBC Universe
Repository Universe
Stave
3. Creating a Universe
Before You Begin
Creating a JDBC Universe
Creating a Repository Universe
Creating a Stave Universe
4. Universe Designer Walkthrough
Universe Designer
Examining Table Structure
Setting Attributes
Transforming Data
Examining Output Data
Inspecting Column Data
Viewing the Summary of Data
Exporting the Output Data
5. Using the Universe Designer
Repository Universe
Adding a New Table
Importing a Data Source
Settings Tab
Rows
Inspector
Summary
Exporting the Universe
Setting the Universe Access Permissions
JDBC Repository
Configuring a Connection Pool
Adding Tables
Pasting Tables
Viewing SQL
Other Actions
Stave Repository
Enabling Symbolic Links
Saving Data to a Stave Database
Binning
Using the Multi-Stave Feature
Opening a Stave Universe in the Universe Designer
Mapping Stave Columns to Logical Tables
Using Stave

List of Figures

3.1. Menu to Add a Universe
3.2. Adding a JDBC Universe
3.3. Adding a Repository Universe
3.4. Adding a Stave Universe
3.5. Selecting a Stave Table
4.1. Universe Example
4.2. Examining Table Structure
4.3. Setting Attributes
4.4. Adding Transforms
4.5. Examining Output Data
4.6. Inspecting Column Data
4.7. Viewing the Data Summary
5.1. Universe Designer
5.2. Selecting a Data Source - Repository Universe
5.3. Adding a Column
5.4. Adding a Column Value
5.5. Importing a Data Source
5.6. Viewing a Schema
5.7. Setting Table Attributes
5.8. Setting Column Attributes
5.9. Setting Column Security
5.10. Rows Tab
5.11. Inspector Tab
5.12. Summary Tab
5.13. Exporting the Universe
5.14. Mapping the Universe
5.15. Setting the Universe Access Permissions
5.16. Universe Designer for a JDBC Universe
5.17. Configuring the Connection Pool
5.18. Stave Datastore
5.19. Append Records Option - Stave Datastore
5.20. Add a Datasource for Binning
5.21. Add a Datastore for Binning
5.22. Add a Universe
5.23. Select the Universe Type as Stave
5.24. Select the Cars Table
5.25. Binned Column trade_in_vehicle_drive_train_gearbox is Displayed
5.26. Binned Column new_vehicle_drive_train is Displayed
5.27. Selecting Multiple Stave Folders
5.28. Joining Two Columns
5.29. Universe Designer for a Stave Universe
5.30. Table Mapping for a Stave Universe
5.31. Mapped Table for a Stave Universe