Any public Java class method can be used for fieldwise transformation. This provides a wide range of transformation possibilities. During the transformation process, the method is processed with the input of each row of the transform.
Parameters
Class | The Java class (i.e. its constructor). It can be static. |
Method | The name of the public method in the Java class. The method can have one or several input parameters and a return value, all of simple data types. |
The input fields of the function are assigned to the parameters of the Java class constructor and/or the Java method: the first input is assigned to the first parameter, the second input to the second parameter, etc.
Each input field requires the following specifications:
Input | The name of the input field (as for other functions in a FieldTransform). |
Type | A data type that has to match the corresponding parameter type in the Java method. If specified, the input field is converted to this data type. The possible values are: string (default), double, int, byte, float, short, long, and object. |
Target | class: for input fields of the constructor class method: for parameters of the method class |
If the Java class is not part of the JRE (like e.g. java.lang.String), it has to be copied to the Jedox Integrator installation. To do this, perform the following actions:
- Stop the JedoxSuiteTomcatService service
- Copy the .class or .jar file of the Java class to the .\tomcat\webapps\etlserver\WEB-INF\lib_external folder.
- Start the JedoxSuiteTomcatService service
For the generation of the Java class file, the same JDK version used for the Jedox Integrator installation should be used to avoid compatibility issues.