1 person found this helpful
Since Output uses XML data, you'll have to query your database (using the JDBC operation) and turn the data into XML (if its not already). Then send the result to Output.
Thanks for the input!
Now, where do I create the XML, inside some process inside LiveCycle (using LC Workbench maybe?) or do I need an additional layer for this?
And if I do need an additional layer, what is the language of choice (Java?) and how do I create this integration?
Since xpath doesn't really have an "addNode" function you really can't use the setValue operation to put together the XML using DOM like operations. You have to look at a couple of alternatives.
If your XML is simple then you may consider using a String variable to put together a string representaion of the XML. Using the setValue's string functions you could build up the XML (tags and all). Once its together you can then convert the whole thing to a XML variable using a deserialize function in another setValue. The problem with this is that if the XML is complex the string functions can easily get out of hand.
The other option is to build a custom component in Java and then load that component into LiveCycle. You'll then be able to call the component as you would any other LiveCycle operation. There is some good docs on custom components (also known as DSC):
http://www.adobe.com/devnet/livecycle/articles/dsc_development.html - Older article, but it should still have some useful info
That's great! Thank you!
Now, do I need to install Eclipse even having Workbench (and Flash Builder) installed on the same machine?