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

48.1. Readers Comparison

48.2. Functions in DataGenerator

48.3. EmailReader_Message - Output port 0

48.4. EmailReader_Attachment - Output port 1

48.5. Error Metadata for FlatFileReader

48.6. Java data type to CTL2 data type conversion

48.7. JSONReader_TreeReader_ErrPortWithFile

48.8. MongoDBReader_Attributes

48.9. MongoDBReader_Result

48.10. MongoDBReader_Error

48.11. Error Metadata for Parallel Reader

48.12. Error Metadata for QuickBaseRecordReader

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

48.14. Format strings

48.15. Error Metadata for XMLReader

49.1. Writers Comparison

49.2. Error Metadata for DB2DataWriter

49.3. Error Fields for InformixDataWriter

49.4. Error Fields for MSSQLDataWriter

49.5. Error Metadata for MySQLDataWriter

49.6. Error Fields for QuickBaseImportCSV

49.7. Error Fields for QuickBaseRecordWriter

49.8. SalesforceWaveWriter_Wave_Success - Output port 0

49.9. SalesforceWaveWriter_Wave_Error - Output port 1

50.1. Transformers Comparison

50.2. List of Aggregate Functions

50.3. Functions in Denormalizer

50.4. Functions in Normalizer

50.5. Functions in Partition (or ParallelPartition)

50.6. Functions in Rollup

51.1. Joiners Comparison

51.2. Functions in Joiners, DataIntersection and Reformat

52.1. Job control Comparison

53.1. File Operations Comparison

54.1. Data Partitioning Components Comparison

55.1. Data Quality Comparison

55.2. Database Enrichments and File Types

55.3. Error Fields for EmailFilter

55.4. Validator error codes

56.1. Others Comparison

56.2. HTTPConnector_Request

56.3. HTTPConnector_Response

56.4. HTTPConnector_Error

56.5. Input Metadata for RunGraph

56.6. Output Metadata for RunGraph

59.1. Literals

61.1. National Characters