hello, We're evaluating different tools to achieve real-time (or almost real-time) data integration. We basically need to move data from a system (persisted in an Oracle DB) to another system (another Oracle DB) applying different transformation rules in the process. Could you tell me if it is possible with Jaspersoft ETL to do the following: 1. Have data from certain table fields end up in different fields in the destination schema v.g.: destination.table1.field1=source.table1.field7 2. Have data end up in a table field, or another, depending on values of other table fields v.g.: if source.table1.field1='A' then destination.table1.field1=source.table1.field1 ; if source.table1.field1='B' then destination.table1.field1=source.table1.field2 3. Have data discarded/'transformation omitted' depending on values of table fields v.g.: if DESTINATION.table1.field1='A' then DO NOT DO destination.table1.field7=source.table1.field7 4. Apply mathematical transformations/functions to the original values v.g.: destination.table1.field1=source.table1.field7*7 5. Apply format conversions to the original values v.g.: destination.table1.field1=substring(source.table1.field7*7,.........) 6. Run job(s) whenever a predefined group of origin table fields change and apply the rules only to the changed rows. I know the commercial version supports real-time integration but do not know about the details I know these are very specific questions/requirements so thanks very much in advance for your answers and/or any suggestions.