Part V. Graph Elements, Structures and Tools

Table of Contents

17. Components
18. Edges
What Are the Edges?
Connecting Components by the Edges
Types of Edges
Assigning Metadata to the Edges
Propagating Metadata through the Edges
Colors of the Edges
Debugging the Edges
Enabling Debug
Selecting Debug Data
Viewing Debug Data
Turning Off Debug
19. Metadata
Data Types and Record Types
Data Types in Metadata
Record Types
Internal Metadata
Creating Internal Metadata
Externalizing Internal Metadata
Exporting Internal Metadata
External (Shared) Metadata
Creating External (Shared) Metadata
Linking External (Shared) Metadata
Internalizing External (Shared) Metadata
Creating Metadata
Extracting Metadata from a Flat File
Extracting Metadata from an XLS(X) File
Extracting Metadata from a Database
Extracting Metadata from a DBase File
Creating Metadata by User
Dynamic Metadata
Reading Metadata from Special Sources
Assigning Metadata to an Edge
Creating Database Table from Metadata and Database Connection
Metadata Editor
Basics of Metadata Editor
Record Pane
Details Pane
Changing and Defining Delimiters
Changing Record Delimiter
Changing Default Delimiter
Defining Non-Default Delimiter for a Field
Editing Metadata in the Source Code
20. Database Connections
Internal Database Connections
Creating Internal Database Connections
Externalizing Internal Database Connections
Exporting Internal Database Connections
External (Shared) Database Connections
Creating External (Shared) Database Connections
Linking External (Shared) Database Connections
Internalizing External (Shared) Database Connections
Database Connection Wizard
Encrypting the Access Password
Browsing Database and Extracting Metadata from Database Tables
21. JMS Connections
Internal JMS Connections
Creating Internal JMS Connections
Externalizing Internal JMS Connections
Exporting Internal JMS Connections
External (Shared) JMS Connections
Creating External (Shared) JMS Connections
Linking External (Shared) JMS Connection
Internalizing External (Shared) JMS Connections
Edit JMS Connection Wizard
Encrypting the Authentication Password
22. QuickBase Connections
23. Lookup Tables
Internal Lookup Tables
Creating Internal Lookup Tables
Externalizing Internal Lookup Tables
Exporting Internal Lookup Tables
External (Shared) Lookup Tables
Creating External (Shared) Lookup Tables
Linking External (Shared) Lookup Tables
Internalizing External (Shared) Lookup Tables
Types of Lookup Tables
Simple Lookup Table
Database Lookup Table
Range Lookup Table
Persistent Lookup Table
Aspell Lookup Table
24. Sequences
Internal Sequences
Creating Internal Sequences
Externalizing Internal Sequences
Exporting Internal Sequences
External (Shared) Sequences
Creating External (Shared) Sequences
Linking External (Shared) Sequences
Internalizing External (Shared) Sequences
Editing a Sequence
25. Parameters
Internal Parameters
Creating Internal Parameters
Externalizing Internal Parameters
Exporting Internal Parameters
External (Shared) Parameters
Creating External (Shared) Parameters
Linking External (Shared) Parameters
Internalizing External (Shared) Parameters
Parameters Wizard
Parameters with CTL Expressions
Environment Variables
Canonizing File Paths
Using Parameters
26. Internal/External Graph Elements
Internal Graph Elements
External (Shared) Graph Elements
Working with Graph Elements
Advantages of External (Shared) Graph Elements
Advantages of Internal Graph Elements
Changes of the Form of Graph Elements
27. Dictionary
Creating a Dictionary
Using the Dictionary in a Graph
28. Notes in the Graphs
29. Search Functionality
30. Transformations
31. Fact table loader
Launching Fact Table Loader Wizard
Wizard with project parameters file enabled
Wizard with the project parameter file disabled
Working with Fact Table Loader Wizard
Created graph