Reporting technologies comparison: Oracle Reports VS Oracle Analytics (BI Publisher) VS Jasper Report

Reporting technologies Match-Up: Oracle Reports VS Oracle Analytics Publisher VS Tibco JasperReports

Reporting technologies Match-Up: Oracle Reports VS Oracle Analytics Publisher (BI Publisher) VS Jasper Reports

As Oracle Reports Premium Support arrives to its end (August 2022), many companies are in the process of chosing between the two most popular replacement technologies are Oracle Analytics Publisher and Jasper Reports (Community or Enterprise editions). You are probably wondering how they compare to each other. We have built a comprehensive side by side comparison to help compare the three solutions easily.

Titleimage

Posted by Nestor Zuluaga on 2021:12:20 13:27:17

Oracle Reports vs Oracle Analytics Publisher vs JasperReports.

We described a two popular Reports Alternatives (Analytics Publisher and JasperReports) some time ago. As the Oracle Reports Premium Support date is coming up quickly (August 2022) many customers are currently in the process of replacing Oracle Reports. The below deep dive comparison between the two most appealing options could serve as a good reference to help you chose the right reporting platform for your business going forward.

 

Reporting technologies functionalities comparison Oracle Reports Oracle Analytics Publisher (BI Publisher) Jaspersoft JasperReports Server
Version 12c (Terminal Version)

5.5.0

v6.17

       

Output

     

PDF

Yes

Yes

Yes

Excel

No

Yes

Yes

CSV

No

Yes

Yes

Email ( From Forms)

Yes

Yes

Yes

FTP

Yes

Yes

Yes  - Inbuilt REST API allows to pass the FTP details but requires some development

Printer

Yes

Yes

Yes

XML (Distribution File)

Yes Yes Yes

Built-In Scheduler

No Yes

Yes - Using built-in schedulder or via java libraries (quartz)

WebDAV
(Sending report output to WebDAV)

Yes

PDF / Excel /CSV (SSL)

PDF / Excel /CSV using the Jaspersoft Library JAR files, into WEB  Application

       

Data Sources

     

JDBC

Only Oracle

JDBC, JNDI

JDBC, JNDI

Web Service

No

Yes

Yes

Non-Oracle DB (JDBC connexion to PostgreSQL, SQL Server, etc)

No

Yes

Yes

       

Data Model

     

Data Sets (SQL Queries)

Yes

Yes - The Data Model for an complex report with multiple SQL queries with multiple joins, group filters, group links, calculated fields or elements by expression. Use of database packages or functions inside of SQL queries too. This Data Model is more in line / Compatible with Oracle Reports

Yes - The Data Model for an complex report with multiple SQL queries with multiple joins, group filters, group links, calculated fields or elements by expression. Use of database packages or functions inside of SQL queries too.

Event Triggers

Yes

Yes

Yes

List of Values (LOV) for Parameters

Yes

Yes

Yes

Centralized Data Model (Domain - One Data Model Leveraged for multiple Layouts)

No

Yes

Yes, Enterprise Edition Only

       

Layout Type

     

Multiple Layout Types

No (Only One Layout Type)

BI Publisher Layout =  Report can be created using the BI Publisher Report Editor, a kind of wizard for simple or medium reports or for interactive reports.

Enterprise Edition Only: Jaspersoft Studio, this is quivalent to BI Publisher, but here there are more than 20 templates, but here the reports which are designed here are pixel Perfect and simple to complex reports can be designed here. We can design, drill downs temmplates, fonts, localization, customization etc.

Rich Text Format (RTF)= Most reports are created as RTF template, in Words with BI Publisher plug-in. Contains complex layout design, using repeating groups, tables/forms, pivot tables, charts, conditional formats, conditional regions, variables,extended functions (xdofx, xdoxslt).

XML- Report can be written in XML.
Java- Report can be written using Jasper Java Library.

Microsoft Excel = A few reports created as XLS template, in Excel (xls) with BI Publisher plug-in.

Not Available
JasperReports does not have plug-in to work from excel, offers the options of using excel as a datasource  or as an output format

       

Integration

     

API

No

Yes

Yes (JasperReports server or DEV API)

DBMS_SCHEDULER (Or DBMS_JOB) + PL-SQL

Yes

Yes

Yes

Call from FMB/PLL

Yes (Native)

Yes (Native)

Yes (Not Native)

Call from Oracle DB Package.

Yes

Yes -
XML is created using function "write_xml" from report_pkg.

Yes - via a URL
From Oracle DB Pkg you can call a JasperReporte through a URL and save the output

Sending Email (PDF in attachment) Form Oracle Forms

Yes

Yes

Yes (requires additional development)

       

Access control

     

Active Directory integration

No

Yes - AD LDAP authentication

Yes - LDAP, CAS, Authentication with external DB

SSO

Yes (via OAM or via RAM - RENAPS Access Manager)

Yes - AD LDAP authentication - zero sign-in (Weblogic/Kerberos) - also compatible with RAM (Renaps Access Manager)

Yes - SSO, LDAP, Not compatible with RAM

       

Other Business requirements

     

Output more dynamic -
example to see values in graphs when hovering over values etc

No

Yes (Interactive Reports)

Yes, Enterprise Edition Only. Dynamic output avaiable, but the HTML5 charts are only available in professional or enterprise versions

Reusable Templates or Sub Templates

No

Yes

Yes, Enterprise Edition Only. Dynamic output avaiable, but the HTML5 charts are only available in professional or enterprise versions

Reusable Style Templates

No

Yes

Yes (Style Templates can be made or templates can be used, they are more like CSS which contains information of the report design styling)

Multilingual output

Yes

Yes (two options available)

Yes - There are several languages available, French, English, dutch, even two Byte language such as thai, Chinese, Hindi are supported

Mobile

No

Yes - Native Application called Oracle BI

Yes - JasperMobile is a native application for your iOS or Android device that lets you browse, view, and interact with reports from JasperReports Server.

Email Bursting

No

Yes

No

High-Availability Architecture (cluster etc)

Yes, (Weblogic Cluster)

Yes, (Weblogic Cluster)

Yes, conventional cluster architectures and containers (dockers, kubernetes)

 

We hope this guide will be useful to you and help you pick the right technology for your specific needs. You may as well read this article to lean about some of the automatic migration possibilities.

Posted by Nestor Zuluaga on 2021:12:20 13:27:17

Return to Blog