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
Although it's primary an output plugin, it's possible to load fields after insert/update from the ars server. E.g. if you want to insert new datasets, and you need the generated Request-id in subsequent transformations. By sending just one input row and with suitable lookup definition, you could use it as input step.
Datatype mapping AR fields => output rows
ARS datatype | Output field datatype | Remark |
---|---|---|
Integer | java.lang.Long | |
Time | java.util.Date | |
Decimal | java.math.BigDecimal | |
Char | java.lang.String | |
Real | java.math.BigDecimal | |
TimeOfDay | java.lang.String | as "HH:mm:ss" |
Enum | java.lang.Object | |
Date | java.util.Date | |
Diary | java.util.Date | Date of last diary entry |
java.lang.String | UserId of last diary entry | |
java.lang.String | text of last diary entry | |
Attachment | java.lang.String | Attachment name |
java.lang.String | ValueFileName | |
java.lang.Long | OriginalSize | |
java.lang.Long | CompressedSize | |
java.lang.String* | Path to file (if download file is checked) | |
Currency | - | not supported |