Grid

A regular grid without additional features consists of the following functions:

1. Hide/Show columns. Some columns are hidden by default to get all possible columns click here.
2. Filters based on tree selection. Can be changed to e.g. compare objects of the same class
3. Add a new row. Hotkey Ctrl+N
4. Delete selected row. Hotkey ?
5. Duplicate selected row. Hotkey Ctrl+D
6. Open raw editor to change JSONs for this object type. Is only available on highest level. Offers search and replace function.
7. Clicking here will open a browser to the help section on the CLOE website corresponding to this specific object type.

Copy / Move

Copy/Move can be used to move a child object between different parent objects of the same type. Like moving a lookup from one DataFlow to another.

It is only available in the following sections:

• Repository > Databases > Schemas
• Repository > Databases > Schemas > Tables
• Modeler > DataFlow > Lookups
• Orchestration > Batchsteps

Auto Mapping

Auto mapping is a feature specifically for ColumnMappings of DataFlows. It uses existing metadata from the repository to automatically match columns of source tables and sink table. Matching is fuzzy but names must not be too different.

DDL Generation

Some overviews support the generation of data definition language DDL. There are two options to chose from: 1. Preview the generated DDL 1. Save the generated DLL

For example: By clicking on the DDL button in the Repository Databases section all related DDLs are generated and shown in a popup.

DDL generation is either done for all objects or just the one selected. In addition, it always generates DDLs for all child objects (databases > schemas > tables).

Query Preview

For all DataFlows / CustomDataFlows the GUI can generated a preview of the resulting query. It will either generate a preview with all DataFlows / CustomDataFlows or just the selected one.