Not available in Community Designer

Write records to Clover file.

Solution

Set up the File URL attribute.

If the file exists, the data in the file is overwritten.

Append records of each graph run to an existing file my-clover-file.cdf.

Solution

Set up File URL and Append attributes.

Write data to file my-clover-file.cdf in the directory cdrw. The directory may not exist.

Solution

Use attributes File URL and Create directories.

The first 10 records should be omitted. Write the rest of the records.

Solution

Use attributes File URL and Number of skipped records.

Write at most 100 records.

Solution

Use attributes File URL and Max number of records.

Metadata on the input edge of CloverDataWriter has fields ID, Firstname,Surname and Salary. Save list containing Firstname and Surname to Clover data file employees.cdf.

Solution

Use attributes File URL and Exclude fields.

List of students contains fields Firstname, Lastname and Mark. Categorize records into several files according to the mark. The created files will have names: students_A.cdf, ... students_F.cdf.

Solution

Use attributes File URL, Partition key and Partition file tag.

Note: Records with students without mark will be saved into file students_.cdf.

The input data contain number of active customers for particular countries. The countries are of different regions. Categorize records into the files according to the region.

CZ|105
UK|651
US|827
...

The input metadata contain fields CountryCode and Customers but nothing in the record denotes the region directly. You have list of country codes with corresponding region to be used for partitioning.

CZ|Europe
UK|Europe
US|America
...

Some country codes may not be present in the list, store records with country codes not present in the list into separate file region_missing.cdf.

Solution

Use the attributes File URL, Partition key, Partition lookup table, Partition file tag, Partition output fields, Partition unassigned file name. You need a lookup table CountryCodeRegion too.

The files region_Europe.cdf, region_America.cdf, ... and region_missing.cdf will be created.

Since 2.9 version of CloverETL CloverDataWriter writes also a header to output files with version number. For this reason, CloverDataReader expects that files in Clover binary format contain such a header with the version number. CloverDataReader 2.9 cannot read files written by older versions of CloverETL nor these older versions can read data written by CloverDataWriter 2.9.

The internal structure of zip archive has changed, graphs relying on the structure will stop working. Graphs using a plain file URL without any internal entry specification are not affected.

zip:(${DATAIN_DIR}/customers.zip) - will work
zip:(${DATAIN_DIR}/customers.zip)#DATA/customers - won't work

As Clover format can use compression internally, addition of next compression level is redundant.

Values of parameters Save metadata and Save index are not used since CloverETL 4.0.

Since 4.4.0-M2, CloverDataWriter can write to output port just to byte or cbyte field.