List of Tables

1.1. CloverETL Community Edition vs CloverETL Designer general comparison of components

1.2. CloverETL Community Edition vs CloverETL Designer comparison - Readers

1.3. CloverETL Community Edition vs CloverETL Designer comparison - Writers

1.4. CloverETL Community Edition vs CloverETL Designer comparison - Transformers

1.5. CloverETL Community Edition vs CloverETL Designer comparison - Joiners

1.6. CloverETL Community Edition vs CloverETL Designer comparison - Job Control

1.7. CloverETL Community Edition vs CloverETL Designer comparison - Others

21.1. Standard Folders and Parameters

31.1. Estimated Memory Demands per Edge Type

32.1. Data Types in Metadata

32.2. Available date engines

32.3. Date Format Pattern Syntax (Java)

32.4. Rules for Date Format Usage (Java)

32.5. Date and Time Format Patterns and Results (Java)

32.6. Date Format Pattern Syntax (Joda)

32.7. Rules for Date Format Usage (Joda)

32.8. Numeric Format Pattern Syntax

32.9. BNF Diagram

32.10. Used Notation

32.11. Locale-Sensitive Formatting

32.12. Numeric Format Patterns and Results

32.13. Available Binary Formats

32.14. List of all Locale

32.15. CloverETL-to-SQL Data Types Transformation Table (Part I)

32.16. CloverETL-to-SQL Data Types Transformation Table (Part II)

32.17. CloverETL-to-SQL Data Types Transformation Table (Part III)

34.1.

40.1. Transformations Overview

53.1. Readers Comparison

53.2. Functions in DataGenerator

53.3. EmailReader_Message - Output port 0

53.4. EmailReader_Attachment - Output port 1

53.5. Error Metadata for FlatFileReader

53.6. Java data type to CTL2 data type conversion

53.7. JSONReader_TreeReader_ErrPortWithFile

53.8. MongoDBReader_Attributes

53.9. MongoDBReader_Result

53.10. MongoDBReader_Error

53.11. Error Metadata for Parallel Reader

53.12. Error Metadata for QuickBaseRecordReader

53.13. Error Port Metadata - first ten fields have mandatory types, names can be arbitrary

53.14. Format strings

53.15. Error Metadata for XMLReader

54.1. Writers Comparison

54.2. Error Metadata for DB2DataWriter

54.3. Error Fields for InformixDataWriter

54.4. Error Fields for MSSQLDataWriter

54.5. Error Metadata for MySQLDataWriter

54.6. Error Fields for QuickBaseImportCSV

54.7. Error Fields for QuickBaseRecordWriter

54.8. SalesforceWaveWriter_Wave_Success - Output port 0

54.9. SalesforceWaveWriter_Wave_Error - Output port 1

55.1. Transformers Comparison

55.2. List of Aggregate Functions

55.3. Functions in Denormalizer

55.4. Functions in Normalizer

55.5. Functions in Partition (or ParallelPartition)

55.6. Functions in Rollup

56.1. Joiners Comparison

56.2. Functions in Joiners, DataIntersection and Reformat

57.1. Job control Comparison

58.1. File Operations Comparison

59.1. Data Partitioning Components Comparison

60.1. Data Quality Comparison

60.2. Database Enrichments and File Types

60.3. Error Fields for EmailFilter

60.4. Validator error codes

61.1. Others Comparison

61.2. HTTPConnector_Request

61.3. HTTPConnector_Response

61.4. HTTPConnector_Error

61.5. Input Metadata for RunGraph

61.6. Output Metadata for RunGraph

64.1. Literals

66.1. National Characters