This is a complete list of the videos contained within the QSG. You can watch them sequentially from this page or just use the page as a video reference guide. All of these videos appear within the Guide itself within the relevant chapters, so don't feel you have to go through them all here.
Beginner Phase
|
[2:39] |
Introduction |
This shows you around the key areas of the Clover Designer. |
|||||
|
||||||||
|
[4:16] |
Video I |
Creating a new project and adding a "Universal Data Reader" component into out new Graph. This reads in data from any flat file format. |
|||||
|
||||||||
|
[4:35] |
Clover Philosphy |
An overview of the way Clover thinks about data transformations or "graphs". |
|||||
|
||||||||
|
[4:45] |
Video II |
At this point we explain 2 things you need to understand
This is only an introduction, so don't expect a full tutorial or reference here (you can get an excellent overview here http://www.cloveretl.com/cloveretl-designer/components. We just want you to be aware of these things at this stage. |
|||||
|
||||||||
|
[4:59] |
Video III |
In almost every case, you will want to tweak various things before you have your output data exactly right. This shows you how to do tweak and debug your transformations. |
|||||
|
||||||||
|
[4:56] |
Video IV |
Now we start to do something meaningful and we map the input data fields into a new output format. |
Intermediate Phase
|
[3:38] |
Key Concepts |
Key Concepts II |
|
|
||||
|
[4:45] |
Sorting & Filtering |
Sorting and filtering data. |
|
|
||||
|
[4:46] |
Joining / Aggregating Part 1 |
Joining and aggregating data from multiple data sources (part 1) |
|
|
||||
|
[4:06] |
Part 2 |
Joining and aggregating data from multiple data sources (part 2) |
|
|
||||
|
[4:50] |
Database Reading |
Replacing customers.csv with a MySQL table. |
|
|
||||
|
[4:35] |
Parameters |
Passing in parameters to a graph |
|
|
||||
|
[4:46] |
Sequences |
How to use Sequences for generating sequential numbers automatically. |
|
|
||||
|
[4:56] |
Lookups |
Using Lookups |
|
|
||||
|
[3:47] |
Externalizing |
Sharing Metadata, Connection, Sequences, Parameters and Lookup definitions. |
|
|
Advanced Phase
|
[4:34] |
Fancy Writing |
Automatically writing output to file names determined by field content |
|
|
||||
|
[4:50] |
XML Writing |
Merge customers, orders and order details into an XML output file |
|
|
||||
|
[4:16] |
XML Reading |
Extract the customers, orders and orderdetails records from XML |
|
|
||||
|
[4:59] |
XML XPath Reading |
Extract selected fields from an XML file using the XMLXpathReader component |
|
|
||||
|
[4:18] |
HTTP GET / POST |
How to make an HTTP Web Service call using GET or POST |
|
|
||||
|
[4:51] |
SOAP Calls |
Using the HTTPConnector to make a SOAP call. |