PDF Generator is mostly used to convert existing documents from one format (such as a Word document) into a PDF.
It sounds like you don't have an existing document, you have data in an Oracle DB. In that case you need to merge the data onto a template to produce your PDF. That is usually done with either LiveCycle Forms (for interactive PDFs) or LiveCycle Output (for non-interactive, print PDFs).
You would define your template (the layout of the data) using LiveCycle Designer which produces an XDP file. You then feed the XDP template and the data into Forms or Output and you get a PDF.
Thank you so much, Hodmi!
So, yes, LiveCycle Output is what I need!
I read the info about LC Output and saw the data needs to be fed in XML format. Do I need another layer between Oracle and Output or does Output get the data directly using some connector? (maybe I should move this to the Output forum?).
1 person found this helpful
LiveCycle does include a JDBC connector that can access data from an Oracle instance, but that data will need to be formatted into XML at some point. Whether that's easier to do on the Oracle side or on the LiveCycle side will depend on your setup, what kind of data you are accessing and how much data there is.