SYMPLiK XTRACT4J is a stand-alone, pure Java program that can create XML files from one or more dependent or independent SQL queries. A post-processing hook can be applied to this XML file, e.g. using Oracle BI Publisher RTF template to create professional PDF report with embedded barcodes. It was originally designed as a drop-in replacement for Oracle Report, with highly configurable and easy-to-use features.

Operating Systems

Recent releases

  •  05 May 2010 15:36

    Release Notes: This release adds an APPLICATIONS MODE connection, a user-selectable Responsibility dialog for EBS queries, a "Test Connection" button to verify connection parameters, chart support for XDO processing, changeable Look-and-Feel support, personalization features where some GUI components can be hidden, and i18n support in the GUI. The dependency on the JGoodies Look-and-Feel library has been removed due to an i18n issue. There are some minor bugfixes. The output file will be opened when the process is finished. The Error dialog box is shown for data validation.

    •  15 Oct 2009 10:19

      Release Notes: Oracle BI Publisher integration was added. You can now merge the XML data file generated by XTRACT4J with a BI Publisher RTF template to create professional PDF reports. 1D and 2D barcode support was added, allowing you to embed barcode images in your RTF template.

      •  09 Sep 2009 20:21

        Release Notes: SQL queries can be embedded in the input XML file. Using this feature, the input XML file can be self-contained, and you don't need to specify the Query XML anymore.

        •  07 Sep 2009 09:42

          Release Notes: This version is a stand-alone, self-contained Java program which can execute dependent (nested) and independent queries against Oracle databases to create XML data files. It uses the same data definition markup XML and methodology as in Version 1. This program also provides XSL transformation for further modification of this XML file (e.g. to convert it to HTML). In addition, this program also provides a post-processing hook so that you can write your own actions to take place after this XML file is generated.

          •  24 Apr 2009 11:11

            Release Notes: This release provides a post processing hook so the output XML DOM can be passed to a custom PostProcessor class for further operation. Two examples can be found on the Web site: sending the output XML file to a designated FTP site, and further processing the XML file to create a PDF report with a barcode using the iText library.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.