In this lesson you will
- Learn about CloverDX Designer’s environment
- Create your first transformation graph
- Read a CSV file
Prerequisites
- Download CloverDX Designer
- Install using on-screen instructions
Creating projects 0:26
CloverDX organizes your assets (transformations, data files, metadata, etc.) into projects stored in workspaces (your “root” displayed in Navigator)
Importing files into projects 1:05
We recommend putting your input data files into “data-in” folder. However, your files can live anywhere you want.
You can drag and drop files from anywhere too!
Creating transformation graphs 1:43
The most common object in a CloverDX project is a ‘graph’. A CloverDX graph contains a collection of components configured to read, transform and write data.
Use Shift + Space keyboard shortcut to open a search dialog for components.
Configuring components 3:04
A double-click on a component will display the property editor where you can configure the component’s parameters.
Metadata and edges 3:56
Metadata describes data fields, data types, date formats, etc. You need to assign metadata to edges to describe the data flow.
The Metadata Editor allows you to change data types, rename fields, etc.
Metadata is assigned to edges to tell CloverETL what comes through the edge.
Edges can have different visual styles
Dashed red edges need to have metadata assigned
Solid grey edges have meta data explicitly assigned
Dashed grey edges inherit metadata from either previous or following components (this is called automated metadata propagation)
Trash - A truly useful component 5:20
Trash is a useful development component that you can use to incrementally develop your data flows. Trash discards all incoming records, effectively being a dump bin for whatever you’re testing. (/dev/null if you will)
- Trash bs_icon name=”glyphicon glyphicon-new-window”]