Hi Anil, Sorry that it took so long to respond. This email got lost in my inbox, it seems.
Regarding a mapper UI: there is not currently anything like that in NiFi. I do not know of anyone building such a thing either. However, it would be very helpful, for sure, if it is something that you are interested in contributing. Regarding ExecuteSQL (I'm assuming that this is the processor that you're referring to), I agree that this can be better. In the latest version, 1.2.0, we introduced the concept of Record Readers and Record Writers, and I think that this Processor needs to be updated to make use of those. This would allow you to choose JSON, Avro, etc. as the output format. At the moment, there is no Record Reader or Writer for XML but I think that we will need to be building one in the near future (again, another great place for you to jump in if you are interested in contributing). I have seen someone make use of the scripted Record Writer in order to write XML, as well, as Groovy has a lot of built-in niceties for reading and writing XML, so that would be another option. Thanks! -Mark > On May 19, 2017, at 12:14 PM, Anil Rai <anilrain...@gmail.com> wrote: > > Hi, > I was wondering if there is an UI for XML mapping that is already available > or some is working on? > We have transformXML. But the problem is that we need to generate the XSLT > outside and then feed it in. It would be nice if we have a mapper that a > developer/business user can use to map the source to the target graphically. > Also today the DB connector out comes out in avero format. We are forced to > add additional transforms like avero to json or avero to xml to proceed. It > would be nice if we could configure the DB processor to output the file in > the format that we need/ > Any thoughts? > > Thanks > Anil