|Important: Java FieldTransform function is deprecated in Jedox 2019.1 and will no longer work as of Jedox 2019.2.
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.
|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.