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 |
