so we have requirement to convert bunch of XML's into SQL however we need to transform data in between based on condition set,
such as:
condition 1 : if clientname = 'a' and processtype = 'n' then columna = 'hello from a & some additional text'
condition 2 : if clientname = 'b' and processtype = 'm' then columnb = 'hello from b & some additional text'
condition 3 : if date between '1/1/2017' and '1/1/2018' then columng = 'hello from c & some additional text'
condition 4 : if flag = 'retrunclient' then columnx = 'hello from x & some additional text'
and so on...
we have bunch of condition like this & depending on condition, we need to update value for different column each time.
most of the XML's have different schema & depending on the XML, we can load data into appropriate sql table however we need something that we can use as generic transformation.
We dont want to write all these condition in tMap as we need some flexible solution that allow us to change above condition without changing the job.
We are using enterprise version 6.4. Is there something already available in Talend that we can use? drools? validation rules?
Apart from the Drools BRMS embedded into Talend Administration Center, you can also install and use Red Hat BRMS or JBoss BRMS to manage business rules. For further information, see Red Hat JBoss BRMS documentation.
I never used these but looks like this could solve your problem.
I was trying to use tRules but it only seems to allow 2 columns in the Schema for the rule so no use if validation condition applies to more than 2 columns
