Jasper4Oracle Server

TEAM has redesigned the Jasper4Oracle Server (J4O Server) from the ground up from the experience of many customer projects to avoid the time-consuming problems associated with using the TIBCO JasperReports Server in migration projects, including an easy-to-use PL/SQL API that makes embedding the J4O Server into existing Oracle projects easy.

In addition, it was developed directly for embedding JasperReports in Oracle projects (Oracle Forms, APEX, ADF, Java Web projects) and is designed to replace the Oracle Reports server with minimal effort.

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 */
TEAM_J4O.add_param('deptId',:departments.department_id);

/* 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)

then
   /* 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.

Print
Display

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.

PDF
Mail

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.

User

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.

Deployment
Global

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.

Equal
Interface

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.

Installation

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

Downloads

Test version Jasper4Oracle Server

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

*The runtime of the timely restricted version is limited to 8 hours. After that a restart is required. Runtime limitations can be removed by purchasing a license key. The timely restricted version has no other limitations.

Documentation Jasper4Oracle Server – Installation Guide

Jasper4Oracle Server – Installation Guide: Hints | Installation | Konfiguration | Use | Contact

Flyer Jasper4Oracle Server – The perfect replacement for the Oracle Reports Server

A short overview: Jasper4Oracle Server – the perfect replacement for the Oracle Reports Server.

Have we caught your attention?

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: