Components show
Name:
Partition
Description:
Partitions data into distinct flows. Each connected port becomes one flow. For each record read, the partition function chosen denotes which output flow (port) will be the record sent to. Which partition algorithm becomes active depends on following: partitionKey is NOT specified/defined, partitionKey IS specified and NO ranges is specified or BOTH partitionKey and ranges are specified.
Download - clover.ETL - rel-2-4-0
Notes
Changes
+ new wrapper SystemOutByteChannel protects System.out against close()+ sftp protocol support for readers which use multifile reader
+ possibility of copying ByteDataField as BLOB
+ new implementation of "partition by range" feature with range lookup table usage
+ field unquoting before setting value by delimited and universal data parsers
+ the set of available functions in the Clover transformation language was extended:
- string remove_blank_space(string );
- string get_alphanumeric_chars(string,boolean,boolean);
- string translate(string, string,string );
- string join(anytype,....);
- boolean is_long(string)
- integer index_of(string, string, integer)
- boolean try_convert(anytype, anytype, string)
- numeric num2num(numeric, symbol)
- bool num2bool(numeric)
- numeric bool2num(bool, symbol)
- bool str2bool(string)
- date long2date(long)
- long date2long(date)
- string to_string(anytype)
- byte base64byte(string)
- string byte2base64(byte)
- string bits2str(byte)
- byte str2bits(string)
- byte hex2byte(string)
- string byte2hex(byte)
+ Clover transformation language supports two new variable types, byte array and record
+ some components have new optional "rejected" port(s) (AproxMergeJoin, CheckForeignKey, DBJoin, LookupJoin)
+ DBConnection - for threadSafe connections java.sql.Connections are stored specifically for element ids
--> method getConnection() was replaced by getConnection(String)
--> some classes (SQLDataParser, DBLookupTable) now work with java.sql.Connection
instead of org.jetel.connection.DBConnection
+ DBOutputTable accepts more queries at once; new jetel-sql query syntax introduced
+ DBOutputTable has new attribute "errorAction" - COMMIT or ROLLBACK on errors
+ StructureWriter has 3 input ports: "body", "header" and "footer". There can be different masks for each input port
+ all component attributes, which contain a java code or a Clover TL language code, are not resolved for special
characters
+ new graph processing facility - GraphExecutor, GraphPool.
+ new component XmlWriter with example graphXmlWriter.grf
+ new component SpeedLimiter
+ XLSWriter can write to different sheets depending on record's value
+ data record metadata can specify a default field delimiter
+ the DataReader component recognizes too few or too many fields per record
+ the DataReader component has extended error port metadata - field number where an error occurs is attached
+ new JavaExecute component
+ new component attribute type - properties
+ ascending/descending flag in sort component can be specified per each key field