If you want to add dynamic data in your output, apart from what is found in the primary input XML file, then you have 2 options:

1.You can define additional XML files (apart from the primary XML), and let the template(s) find the data as described here.

2.The alternative is to do a lookup in a database file and enrich the XML file with the extra information you have found after doing a lookup in the database. This option is covered below.

Prerequisites

1.You need a JDBC driver to access the database. If you are running InterFormNG on Windows, then you can place the driver in the directory: C:\Program Files\Java\jrexxx\lib\ext (where xxx is the Java version) or in the directory: C:\Program Files\AdoptOpenJDK\jdkxxx\jre\lib\ext, if you use OpenJDK (where xxx is the version).

2.You need to write an xent file  to describe the properties of the lookup in the database.

3.Setup the workflow to activate the xent file (database lookup) via a transform definition.

4.It is a very good idea first to remove any action for the transformed XML file in the workflow, and transform to a sample XML file. Then you can use the new transformed XML file as the basis for your template, so you can see the new structure and build your design on this new XML file layout.

5.When your template has been updated you can now add the actions in the workflow to build PDF files, print or email.