Jasper4Oracle-Server THE perfect replacement for the Oracle Reports Server

Jasper4Oracle Server

TEAM hat den Jasper4Oracle-Server (J4O-Server) aus der Erfahrung von vielen Kundenprojekten von Grund auf neu entwickelt.Damit werden die zeitraubenden Probleme umgangen, die beim Einsatz des TIBCO JasperReports-Servers im Rahmen von Migrationsprojekten entstehen.So beinhaltet der J4O-Server eine einfach zu bedienende PL/SQL-API, wodurch die Einbettung in bestehende Oracle Projekte besonders einfach wird. Zudem wurde er direkt für die Einbettung von JasperReports in Oracle-Projekte (Oracle Forms, APEX, ADF, Java-Web-Projekte) entwickelt.Dabei ist er so ausgelegt, dass er mit minimalem Aufwand den Oracle Reports-Server ersetzen kann.

The differences between TEAM’s and TIBCO’s JasperReports servers become clear when you download the following feature overview.

Overview of
“The different JasperReports Server”

Easy integration in Forms, Apex, JavaEE etc.

A lightweight PL/SQL API is included. To call a JasperReport from Forms, for example, you only need the following lines:

/* Specify the report */
TEAM_J4O.set_report(P_PROJECT_NAME => 'j4o_Demo',
                    P_REPORT_NAME => 'EmployeeExample',
                    P_FORMAT => 'PDF',
                    P_LOCALE => 'de_DE');

/* Pass the parameters */

/* Call the report */
if not TEAM_J4O.get_report_view_url(P_URL => v_url,
                                    P_ERR_CODE => v_err_code,
                                    P_ERR_MSG => v_err_msg)

   /* Display the PDF in the browser window */
   web.show_document (v_url,'_BLANK');
end if;

Jasper4Oracle-Server, Part 2 – Forms
How to include the Jasper4Oracle Server in Forms

Jasper4Oracle-Server, Part 3 – APEX
Integration of the Jasper4Oracle Server in APEX

Direct printing

By specifying the printer with the PL/SQL API, the report is printed directly, also from DB background processes (DBMS_JOB or DBMS_SCHEDULER). You simply specify the target printer. To determine the possible printers, the API also provides a function that returns all printers that can be reached by the J4O Server.


Display and Download

Display and download of PDF, Word, Excel etc. are possible as well as display via a simple URL, even directly from Forms. With TIBCO’s JasperServer, a password must be specified in plain text in the URL for direct access from other applications, which is not necessary with the J4O Server. For security reasons, the server generates a one-time token that can be used to display the report once.

pdf-file on the server

You can also use a directory on the server as the output destination to make printing easy in batch processes. You simply specify the directory and the report name as the output destination for the report.


Direct sending of e-mails

A created document can also be sent directly by email via the PL/SQL-API of the J4O server.

You specify one or more recipients, CC or BCC and the email content. The document is then sent to the recipient as an attachment.

Deploying reports with different users

When executing the report, the database user can optionally be specified.  In many projects, Oracle Reports uses the current user passed by Forms. To facilitate migration, the PL/SQL-API allows you to specify the database user for each print call.


Further advantages of the Jasper4Oracle Server compared to the free TIBCO JasperServer

Jasper4Oracle-Server, Part 4 – Deployment
How do I deploy a report to the Jasper4Oracle server?

Easy deployment

The deployment takes place by storing a jar file in the directory structure on the J4O server. The jar file can contain all resources of the report, including fonts, images and Java classes (scriptlets). The jar file, which contains all necessary resources, can be created in the Jasper Studio with 2 clicks.


Global Resources

Wenn Ressourcen wie Subreports, Fonts, Bilder, Java-Klassen (Scriptlets) etc. global zur Verfügung gestellt werden sollen, so ist dies als Jar-File als globale Ressource möglich.

Same functionality in JasperStudio and J4O Server

No changes to expressions are necessary when including subreports. In contrast to the TIBCO JasperServer, the J4O Server behaves like the Studio.


Easy administration interface

Via the administration interface, you can quickly and easily view errors and report runtimes.

Easy to install

The J4O Server is a standalone application. All you need is a Java environment (the OpenJDK is sufficient). The server is only unpacked and started. The PL/SQL-API requires some DB permissions because it communicates with the server via REST. However, installation scripts are available for this.


Jasper4Oracle-Server, Part 1 – Installation
Brief introduction to installing the Jasper4Oracle Server


Testversion des Jasper4Oracle-Server
Zip-Datei des Jasper4Oracle-Servers, Version 1.8.1 (zeitlich limitierte Test-Version*)

Integration of JasperReports in Oracle Forms or Apex application with a PL/SQL API for replacing Oracle Reports.
The PL/SQL API offers functions for printing, exporting, downloading, mailing and showing documents (PDF, Word, Excel etc.) in a Browser.

Features: JasperReports | PL/SQL | Oracle | Forms | Apex | ADF | Oracle Reports | Reports | Jasper

*In der Testversion ist die Laufzeit auf 8 Stunden begrenzt. Danach ist ein Neustart erforderlich. Die Laufzeitbegrenzung kann durch den Erwerb eines Lizenz Keys aufgehoben werden. Die Testversion hat ansonsten keine weiteren Einschränkungen.

Die Jasper4Oracle Dokumentation

Produktblatt Jasper4Oracle-Server

Der Jasper4Oracle-Server stellt sich als perfekten Ersatz für den Oracle Reports Server heraus.

Have we caught your attention?

Noch mehr Infos finden Sie auf der Webauftritt vom Jasper4Oracle Server:

If you would like more information about JasperReports, or would like to talk to a JasperReports expert, call us at +49 5254 8008-0, or leave your contact details and we will get back to you: