Tip

It is possible to customize run-time monitoring.

Screenshots

ScreenshotScreenshot of CloverETL Designer window and an example transformation graph in the main pane. There are other panes as navigator, outline, properties and palette are at the side of the main pane.

Panes

ScreenshotScreenshotScreenshotScreen fragments presenting Navigator and Outline panes.
Navigator is the pane where projects, folders, files, graphs, external metadata or external connections can be managed.
Outline pane contains graph elements, both internal and external (linked, shared by more graphs), - metadata, connections, sequences, parameters, lookup tables. You can see on the pictures how to manage graph metadata or database connections.
ScreenshotPalette with edit tools and components as Readers, Writers, Transformers, Joiners and Other components.

Component wizards and property editors

ScreenshotScreenshotScreen fragments showing panes with properties of files, graphs or graph elements. Component and metadata properties are displayed here.
ScreenshotFilter editor is a dialog of Filter component where filter expressions are defined. Possible functions and available metadata fields are listed in the left and right box. Content assist comes in handy when typing a filter expression.
ScreenshotTransform editor - Transformations tab of Transformer component simplifies mapping of input and output fields by drag'n'drop manner and defining of transformation functions.
ScreenshotTransform editor - Source tab of Transformer component shows the source code of the transformation. This tab offers syntax highlighting and content assist as well.
ScreenshotMetadata wizard is used when you create metadata from a flat file. You can check parsing of the flat file on the Preview tab and see if defined parsing rules are correct.
ScreenshotMetadata editor is used when you extract metadata from a flat file or edit the prepared. You can view metadata structure including field and record delimiters, etc., you can change other properties and you can also view attached file from which metadata have been extracted and the path to the file as well.
ScreenshotEdit component wizard is used when you are setting attributes (properties) of individual components. Setting the Data policy attribute is shown here. Some attributes can be defined by selecting from a list of possible values, the others can be defined using corresponding wizard.

Database dialogs

ScreenshotDatabase connection wizard allows to enter database connection attributes, chose a database driver and validate the defined connection. It also allows to use existing DB connection to create a new one.
ScreenshotOnce a database connection is established, you can browse database structure, generate SQL query by selecting database tables and their columns or by typing the query directly. You can also validate the query by clicking the button.
ScreenshotAfter that, you can view the selected data by clicking another button. The data is displayed in a table.

Logging and tracking

ScreenshotDetailed log after running a graph. Each component logs information about processed data, its status etc..
ScreenshotWhen you are tracking a running graph, information about number of processed records is displayed next to each edge and icons on components display their status (white triangles in green circles in this screenshot signalize that components are running). Further information on components' status is displayed on the Clover - Graph tracking tab.
ScreenshotAfter successful run of the graph, you can see the information about numbers of parsed records and bytes and CPU load. It is displayed on the Clover - Graph tracking tab. Click the tab to expand it.