I see in clover 2.5 there is support for XSLT transformations, at least, I see a node called XSLDataTransformer that leads me to believe i *could* do something w/ XSLT.
my use case is I’m converting some XML and stuffing it into a database. The XML I’m given is in the most horrendous format possible and is really difficult to use.
So I made an XSLT to transform the bad XML input into something more reasonable to handle. the specifics of why its bad are not important, just that it needs to be transformed.
what I would like to have is a node read in the bad xml, pipe that to another node which will transform that xml into the “good” format, and then send that XML blob to the XmlXPathReader where I can pull out all the relevant bits into a data record which will eventually end up in the database.
reading the XSLDataTransformer, well, half the javadoc looks like it was copied and pasted from the Sort node, so I dont know what to think. But i’m left with the impression that you can only perform transformations on fields in a data record, and not an arbitrary blob of xml. what i’m looking for is:
- can XSLDataTransformer be used for my use case?
- if XSLDataTransformer cannot be used for my use case, is there another out of the box component than can be?
- if there is not another out of the box component, what’s the best way to put an xslt transformation in front of an xml file being read in?
If all else fails, I can do this xslt pre-processing before the ETL phase, but this is a use case that clover should support (in my opinion) so i’m hoping this can be done within the existing framework.
ideas?
Thanks.