Home
CloverDX Designer
CloverDX 5.0.3
List of Figures
1.1.
CloverDX Designer
1.2.
CloverDX Server
1.3.
CloverDX Cluster
7.1.
CloverDX Designer Splash Screen
7.2.
Workspace Selection Dialog
7.3.
CloverDX Designer Introductory Screen
7.4.
CloverDX Help
8.1.
Choose licensing
8.2.
Dialog for specifying license
8.3.
License agreement
8.4.
Select Activate online radio button, enter your license number and password and click Next.
8.5.
Confirm you accept the license agreement and click Finish button.
9.1.
License Manager showing installed licenses.
9.2.
CloverDX License dialog
12.1.
SmartScreen warning
12.2.
User Account Control Preventing the Intallation
13.1.
CloverDX Server Integration
13.2.
Show component icon: enabled
13.3.
Show component icon: disabled
13.4.
Show component background: enabled
13.5.
Show component background: disabled
13.6.
Show component description: enabled
13.7.
Show component description: disabled
13.8.
Show rich tooltips: enbled
13.9.
Show rich tooltips: disabled
13.10.
Open context menu for newly created edge: enabled
14.1.
CloverDX Runtime
14.2.
Accessing CloverDX Runtime menu
14.3.
Restarting CloverDX Runtime
14.4.
Adding library to classpath using VM parameters
14.5.
CloverDX Runtime - Logging
14.6.
Setting the Master password
14.7.
CloverDX Runtime - User Classpath
14.8.
User Classpath - Advanced Options
15.1.
CloverDX Server Integration
15.2.
CloverDX Server Integration
16.1.
Execution Monitoring
17.1.
Preferences Wizard
17.2.
Installed JREs Wizard
19.1.
Refresh Operation
20.1.
CloverDX Perspective
20.2.
Removing Components from the Palette
20.3.
Six New Buttons in the Tool Bar Appear Highlighted (Align Middle is shown)
20.4.
Navigator Pane
20.5.
Outline Pane
20.6.
Outline Pane - Subgraphs
20.7.
Outline Pane with Minimap
20.8.
Show Element ID Enabled
20.9.
Graph Cleanup
20.10.
Locking an Element - Message dialog
20.11.
Accessing a locked graph element - you can add any text you like to describe the lock.
20.12.
Properties Tab
20.13.
Console Tab
20.14.
Problems Tab
20.15.
CloverDX - Regex Tester Tab
20.16.
Execution tab of a graph running on CloverDX Designer
21.1.
Placeholder File
21.2.
Naming a CloverDX Project
21.3.
CloverDX Project subdirectories
21.4.
CloverDX Server Project Wizard - Server Connection
21.5.
CloverDX Server Project Wizard - Sandbox Selection
21.6.
Naming a New CloverDX Server Project
21.7.
CloverDX Examples Project Wizard
21.8.
Convert local project to CloverDX Server project wizard
21.9.
Convert local project to CloverDX Server project wizard II
21.10.
Project Folder Structure inside Navigator Pane
21.11.
Workspace.prm File
21.12.
Connection failed
21.13.
Connection failed
21.14.
Connection reestablished
21.15.
CloverDX Connection
21.16.
CloverDX Connection
22.1.
Graph Editor with a New Graph and the Palette of Components
22.2.
Components Selected from the Palette
22.3.
Components are Connected by Edges
22.4.
Creating an Input File
22.5.
Creating the Contents of the Input File
22.6.
Metadata Editor with Default Names of the Fields
22.7.
Metadata Editor with New Names of the Fields
22.8.
Edge Has Been Assigned Metadata
22.9.
Opening the Attribute Row
22.10.
Selecting the Input File
22.11.
Input File URL Attribute Has Been Set
22.12.
Output File URL without a File
22.13.
Output File URL with a File
22.14.
Defining a Sort Key
22.15.
Sort Key Has Been Defined
22.16.
Result of Successful Run of the Graph
22.17.
Contents of the Output File
23.1.
Console Tab with an Overview of the Graph Execution
23.2.
Counting Parsed Data
23.3.
Run Configuration - Main Tab
23.4.
Run Configuration - Parameters Tab
23.5.
Run Configuration - Refresh tab
23.6.
Connect to Job dialog
24.1.
URL File Dialog - Local files
24.2.
URL File Dialog - Workspace view
24.3.
URL File Dialog - CloverDX Server
24.4.
URL File Dialog - Hadoop HDFS
24.5.
Example of Generated OpenSSH Private Key
24.6.
URL File Dialog - Remote files
24.7.
URL File Dialog - Input Port
24.8.
URL File Dialog - Output Port
24.9.
URL File Dialog - Dictionary
24.10.
Edit Value Dialog
24.11.
Find Wizard
24.12.
Go to Line Wizard
24.13.
Open Type Dialog
25.1.
Import Options
25.2.
Import Projects
25.3.
Import from CloverDX Server Sandbox Wizard (Connect to CloverDX Server)
25.4.
Import from CloverDX Server Sandbox Wizard (List of Files)
25.5.
Import Graphs
25.6.
Import Metadata from XSD
25.7.
Import Metadata from XSD - Review
25.8.
Import Metadata from DDL
26.1.
Export Options
26.2.
Converting Graph to Jobflow
26.3.
Converting Jobflow to Graph
26.4.
Converting Subgraph to Graph
26.5.
Export Graphs to HTML
26.6.
Export to CloverDX Server Sandbox
26.7.
Export Image
27.1.
Edge tracking example
27.2.
An example of a medium level of tracking information
27.3.
An example of a high level tracking information
28.1.
CloverDX Search Tab
28.2.
Search Results
29.1.
Network connections window
30.1.
Add Components dialog - finding a sorter.
30.2.
Find Components dialog - the searched text is highlighted both in component names and description.
30.3.
Edit Component Dialog (Properties Tab)
30.4.
Graph with Disabled Component
30.5.
With Default PassThrough
30.6.
With PassThrough to second Output Port
30.7.
Simple Renaming Components
30.8.
Setting the Phases for More Components
30.9.
Allocation cardinality decorator
30.10.
Defining Group Key
30.11.
Defining Sort Key and Sort Order
30.12.
Creating Metadata from a Template
31.1.
Metadata in the Tooltip
31.2.
Debugging options
31.3.
Filter Editor
31.4.
Debug Properties Dialog
31.5.
Choosing Inspect Data from Context Menu
31.6.
Data Inspector
31.7.
Search Data
31.8.
Search Options
31.9.
Export Debug Data to CSV
31.10.
Data Inspector Preferences
31.11.
Debug mode in the Properties tab
32.1.
Metadata propagation: metadata is propagated from the first edge on the left side to all connected edges.
32.2.
Changing auto-propagated metadata to user-defined.
32.3.
Changing user-defined metadata to auto-propagated.
32.4.
Different priorities of metadata propagation
32.5.
Metadata propagated from the component
32.6.
Metadata propagated from the component II.
32.7.
Metadata propagated from the component, metadata template is defined within the component.
32.8.
Metadata propagated from the another edge
32.9.
Metadata propagated from a distant edge
32.10.
Advanced metadata propagation - DataIntersection
32.11.
Overview of directions of metadata propagation
32.12.
Metadata propagated from an unconnected distant edge
32.13.
Metadata propagated from the another edge
32.14.
Extracting Metadata from Delimited Flat File
32.15.
Extracting Metadata from Fixed Length Flat File
32.16.
Setting Up Delimited Metadata
32.17.
Setting Up Fixed Length Metadata
32.18.
Extract Metadata from Excel Spreadsheet Wizard
32.19.
Format Extracted from Spreadsheet Cell
32.20.
Extracting Internal Metadata from a Database
32.21.
Database Connection Properties Dialog
32.22.
Selecting Columns for Metadata
32.23.
Generating a Query
32.24.
DBF Metadata Editor
32.25.
Extract metadata from Salesforce - specify connection
32.26.
Extract metadata from Salesforce - enter SOQL query
32.27.
Extract metadata from Salesforce - edit created metadata
32.28.
Specifying Lotus Notes connection for metadata extraction
32.29.
Lotus Notes metadata extraction wizard, page 2
32.30.
Merging two metadata - conflicts can be resolved in one of the three ways (notice the radio buttons at the bottom).
32.31.
Creating Database Table from Metadata and Database Connection
32.32.
Metadata Editor for a Delimited File
32.33.
Trackable Fields Selection in Metadata Editor
33.1.
Database Connection Properties Dialog
33.2.
Advanced tab of the Database connection dialog
33.3.
JNDI resource - Basic tab
33.4.
JNDI resource - Basic tab
33.5.
Using password from secure graph parameter
33.6.
Connecting to MS SQL with Windows authentication.
33.7.
Adding path to the native
dll
to VM parameters.
33.8.
Edit JMS Connection Wizard
33.9.
QuickBase Connection Dialog
33.10.
Lotus Notes Connection Dialog
33.11.
Hadoop Connection Dialog
33.12.
MongoDB Connection Dialog
33.13.
MongoDB Connection Dialog - Advanced Tab
33.14.
Salesforce Connection Dialog
33.15.
Salesforce Connection Dialog II
33.16.
Salesforce Connection Dialog III
34.1.
Lookup Table Internalization Wizard
34.2.
Simple Lookup Table Wizard
34.3.
Edit Key Wizard
34.4.
Simple Lookup Table Wizard with File URL
34.5.
Simple Lookup Table Wizard with Data
34.6.
Changing Data
34.7.
Database Lookup Table Wizard
34.8.
Appropriate Data for Range Lookup Table
34.9.
Range Lookup Table Wizard
34.10.
Persistent Lookup Table Wizard
34.11.
Aspell Lookup Table Wizard
35.1.
Creating a Sequence
35.2.
Editing a Sequence
35.3.
A New Run of the Graph with the Previous Start Value of the Sequence
36.1.
Externalizing Internal Parameters
36.2.
Internalizing External (Shared) Parameter
36.3.
Graph parameters editor
36.4.
Graph Parameters Type Editor
36.5.
Select Editor Type Dialog
36.6.
Edit Parameter Value
36.7.
Edit Parameter Value
36.8.
Multiline string parameter - configuration
36.9.
File URL Dialog - Configuration
36.10.
Select Types Dialog - Choosing file extension(s)
36.11.
Properties - Usage
36.12.
Single Field - Configuration
36.13.
Single Field - Choosing the Field
36.14.
Multiple Fields - Configuration
36.15.
Multiple Fields - Choosing the Field
36.16.
Field Mapping - Configuration
36.17.
Field Mapping - Choosing the Field
36.18.
Join Key - Configuration
36.19.
Join Key - Configuration
36.20.
Enumeration - Configuration
36.21.
Character set
36.22.
Time Zone - Configuration
36.23.
Time Zone - Usage
36.24.
Field Type
36.25.
Locale
36.26.
Filter Component Configured by Graph Parameter
38.1.
Dictionary Dialog with Defined Entries
39.1.
Enlarging the Note
39.2.
Toolbar for Format Editing
39.3.
Note with formatted text and markup
39.4.
A Folded Note
39.5.
Properties of a Note
40.1.
Define Error Actions Dialog
40.2.
Transformations Tab of the Transform Editor
40.3.
Mapping of Inputs to Outputs (Connecting Lines)
40.4.
Editor with Fields and Functions
40.5.
Input Record Mapped to Output Record Using Wildcards
40.6.
Transformation Definition in CTL (Source Tab)
40.7.
Java Transform Wizard Dialog
40.8.
Info after Java Transform Wizard Dialog
40.9.
Confirmation Message
40.10.
Transformation Definition in CTL (Transform Tab of the Graph Editor)
40.11.
Content Assist (Record and Field Names)
40.12.
Content Assist (List of CTL Functions)
40.13.
Transformation Definition in Java
41.1.
Illustration of Parallel Run
41.2.
Parallel Run
41.3.
Parallel Run with Cluster Components
41.4.
Component Allocation
41.5.
Component Allocation
42.1.
Component allocations example
42.2.
Graph decomposition based on component allocations
42.3.
Component allocation dialog
42.4.
Dialog form for creating a new shared sandbox
42.5.
Dialog form for creating a new local sandbox
42.6.
Dialog form for creating a new partitioned sandbox
42.7.
Cluster Scalability
42.8.
Speedup factor
42.9.
Remote Edge Implementation
43.1.
Subgraph Layout
43.2.
Example of subgraph with multiple output ports
44.1.
Subgraph Component
44.2.
Example of User-defined Component
45.1.
Original graph without subgraphs
45.2.
Wrapping components into a subgraph
45.3.
Wrapping Subgraph Wizard
45.4.
CloverDX Graph with the Subgraph Component
45.5.
A new Subgraph
45.6.
Export as subgraph parameter button
45.7.
Public parameter appeared as a subgraph component attribute
45.8.
Use parameter as value button
45.9.
Setting up an Optional Port
45.10.
Setting up an Optional Port in Graph Editor
45.11.
Dialog for Filling Required Parameters
45.12.
Subgraph providing metadata
45.13.
Metadata propagated from Subgraph component
45.14.
Subgraph explicitly defines input metadata for customers
45.15.
Using subgraph with matching metadata
45.16.
Generic subgraph not defining explicit metadata in its body
45.17.
Metadata propagate through the Subgraph component
46.1.
Subgraph - Reader
46.2.
Subgraph - Writer
46.3.
Subgraph - Transformer
46.4.
Subgraph - Executor
51.1.
Main .rjob editor
51.2.
Run Configuration of Data Services
51.3.
Data Service test result in console
52.1.
Reading body content from the port of Input component
52.2.
Convert Graph to Data Service
52.3.
Export to Data Service REST job - I.
52.4.
Export to Data Service REST job - II.
52.5.
Export to Data Service REST job - III.
52.6.
Publishing multiple Data Services at once
52.7.
Unpublishing multiple Data Services at once
55.1.
XML Features Dialog
55.2.
Configuring prefix selector in ComplexDataReader. Rules are defined in the Selector properties pane. Notice the two extra attributes for regular expressions.
55.3.
Sequences Dialog
55.4.
A Sequence Assigned
55.5.
Edit Key Dialog
55.6.
Generated Query with Question Marks
55.7.
Generated Query with Output Fields
55.8.
Reading records from database
55.9.
Reading query from input port
55.10.
Incremental reading - first read
55.11.
Incremental reading - second read
55.12.
Mapping to Clover fields in EmailReader
55.13.
Incremental reading - first read
55.14.
Incremental reading - second read
55.15.
JSONExtract - mapping the list
55.16.
Example mapping of nested arrays - the result.
55.17.
SpreadsheetDataReader Mapping Editor
55.18.
Basic Mapping – notice leading cells and dashed borders marking the area data will be taken from
55.19.
The difference between global data offsets set to 1 (default) and 3. In the right hand figure, reading would start at row 4 (ignoring data in rows 2 and 3).
55.20.
Global data offset is set to 1 to all columns. In the third column, it is locally changed to 3.
55.21.
Rows per record is set to 4. This makes
SpreadsheetDataReader
take 4 Excel rows and create one record out of their cells. Cells actually becoming fields of a record are marked by a dashed border; therefore, the record is not populated by all data. Which cells populate a record is also determined by the data offsets setting, see the following bullet point.
55.22.
Rows per record is set to 3. The first and third columns contribute to the record by their first row (because of the global data offset being 1). The second and fourth columns have (local) data offsets 2 and 4, respectively. Thus the first record will be formed by 'zig-zagged' cells (the yellow ones – follow them to make sure you understand this concept clearly).
55.23.
Retrieving format from a date field. Format Field was set to the "Special" field as target.
55.24.
Reading mixed data using two leading cells per column. Rows per record is 2, Data offset needed to be raised to 2 – looking at the first leading cell which has to start reading on the third row.
55.25.
The Mapping Dialog for XMLExtract
55.26.
Parent Elements
55.27.
Editing Namespace Bindings in XMLExtract
55.28.
Selecting subtype in XMLExtract
56.1.
Generated Query with Question Marks
56.2.
Generated Query with Input Fields
56.3.
Generated Query with Returned Fields
56.4.
EmailSender Message Wizard
56.5.
Edit Attachments Wizard
56.6.
Attachment Wizard
56.7.
Defining the Bean structure - click the Select combo box to start.
56.8.
Mapping editor in JavaBeanWriter after first open.
56.9.
Example mapping in JavaBeanWriter
56.10.
Mapping editor in JavaMapWriter after first open.
56.11.
Example mapping in JavaMapWriter
56.12.
Mapping arrays in JavaMapWriter - notice the array contains a dummy element 'State' which you bind the input field to.
56.13.
Mapping editor in JSONWriter after first open. Metadata on the input edge(s) are displayed on the left hand side. The right hand pane is where you design the desired JSON tree. Mapping is then performed by dragging metadata from left to right (and performing additional tasks described below).
56.14.
Example mapping in JSONWriter - employees are joined with projects they work on. Fields in bold (their content) will be printed to the output file - see below.
56.15.
JSONWriter mapping
56.16.
Spreadsheet Mapping Editor
56.17.
Explicit mapping of the whole record
56.18.
The difference between global data offsets set to 1 (default) and 3. In the right hand figure, writing would start at row 4 with no data written to rows 2 and 3.
56.19.
Global data offsets is set to 1. In the last column, it is locally changed to 4. In the output file, the initial rows of this column would be blank, data would start at D5.
56.20.
With
Rows per record
set to 2 in leading cells Name and Address, the component always writes one data row, skips one and then writes again. This way, various data does not get mixed (overwritten by the other one). For a successful output, make sure Data offsets is set to 2.
56.21.
Rows per record is set to 3. Data in the first and third column will start in their first row (because of their data offsets being 1). The second and fourth columns have data offsets 2 and 4, respectively. The output will, thus, be formed by 'zig-zagged' cells (the dashed ones – follow them to make sure you understand this concept clearly).
56.22.
Writing into a template. Its original content will not be affected, your data will be written into Name, Surname and Age fields.
56.23.
Partitioning by one data field
56.24.
Mapping summary
56.25.
Create Mask Dialog
56.26.
Tableau Table Structure
56.27.
Mapping Editor
56.28.
Adding Child to Root Element
56.29.
Wildcard attribute and its properties
56.30.
Attribute and its properties
56.31.
Element and its properties
56.32.
Mapping editor toolbar
56.33.
Binding of Port and Element
56.34.
Generating XML from XSD root element
56.35.
Source tab in Mapping editor
56.36.
Content Assist inside element
56.37.
Content Assist for ports and fields
56.38.
Writing non-standard xml
57.1.
Denormalizer code workflow
57.2.
Merge
57.3.
Normalizer code workflow
57.4.
Rollup code workflow
57.5.
SimpleGather
57.6.
XSLT Mapping
58.1.
Source Tab of the Transform Editor in Joiners
58.2.
Hash Join Key Dialog
58.3.
Join Key Wizard (Master Key Tab)
58.4.
Join Key Wizard (Slave Key Tab)
58.5.
LookupJoin - how it works
58.6.
Edit Key Wizard
58.7.
LookupJoin with Range Lookup Table
58.8.
An Example of the Join Key Attribute in the RelationalJoin Component
58.9.
Join Key Wizard (Master Key Tab)
58.10.
Join Key Wizard (Slave Key Tab)
59.1.
Example of typical usage of Barrier component
59.2.
Example of mapping for the Fail component
59.3.
Example of Loop component usage
61.1.
Usage example of ParallelRepartition component
61.2.
Example of actual working of ParallelRepartition component in runtime
62.1.
DataBase Configuration
62.2.
AddressDoctor Parameters
62.3.
Input mapping wizard
62.4.
Input mapping wizard
62.5.
Output mapping
62.6.
Transform Editor in ProfilerProbe
62.7.
Import/Externalize metrics buttons
62.8.
Validator rules editor
62.9.
Validator - Active rules
62.10.
Validator - Error output mapping
62.11.
Validator - If - then - else without else branch
63.1.
Foreign Key Definition Wizard (Foreign Key Tab)
63.2.
Foreign Key Definition Wizard (Primary Key Tab)
63.3.
Foreign Key Definition Wizard (Foreign and Primary Keys Assigned)
63.4.
Transform Editor in HTTPConnector
63.5.
Multipart entities in input mapping
63.6.
Transform Editor in HTTPConnector
63.7.
Choosing WS operation name in WebServiceClient.
64.1.
Join Key Wizard (Master Key Tab)
64.2.
Join Key Wizard (Slave Key Tab)
64.3.
An Example of the Join Key Attribute in ApproximativeJoin Component
64.4.
Matching Key Wizard (Master Key Tab)
64.5.
Matching Key Wizard (Slave Key Tab)
67.1.
Inspect Action Pop-up Dialog
67.2.
Expressions View