ARSystem plugins for Pentaho Kettle Wiki
AR-System step and db plugins for Pentaho Data Integration Kettle V5
Status: Alpha
Brought to you by:
seschmidt
Datatype mapping stream fields => ARS Server
ARS datatype | Input field datatype | Remark |
---|---|---|
Integer | java.lang.Integer | |
java.lang.Long | ||
java.lang.String | Integer.parseInt | |
Time | java.util.Date | |
java.lang.String | only as "dd.MM.yyyy HH:mm:ss" | |
Enum | java.lang.String | must match with the attribute name |
java.lang.Integer | index of the attribute | |
java.lang.Boolean | true or false must match with one of the field attribute names |
|
Real | java.lang.String | Double.parseDouble |
java.lang.Long | ||
java.lang.Integer | Integer.parseInt | |
java.lang.Double | ||
java.lang.Number | ||
java.lang.Boolean | true=>1, false=>0 | |
Char | java.lang.Object | all java types => toString() |
Diary | java.lang.Object | all java types => toString() |
Decimal | java.lang.String | new BigDecimal(value) |
java.math.BigDecimal | ||
java.lang.Integer | ||
java.lang.Long | ||
java.lang.Double | ||
java.lang.Number | ||
java.lang.Boolean | true=>1, false=>0 | |
Date | java.lang.String | only as "dd.MM.yyyy" |
java.util.Date | ||
TimeOfDay | java.lang.String | only as "HH:mm:ss" |
java.util.Date | only the HH:mm:ss part of the date | |
java.lang.Integer | nr of seconds of the day | |
Attachment | java.lang.String | full qualified filename |
Currency | - | not supported |
If fix values are defined in the insert/update definition, they are considered as java.lang.String
input. They must match with this target datatype.
e.g.
"01.01.2014 12:34:45" => Time field
"1" => Integer field
"1.22" => Decimal Field
"12:34:21" => TimeOfDay Field