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 |
|||
|
|
Yes |
Yes |
Yes |
|
Excel |
No |
Yes |
Yes |
|
CSV |
No |
Yes |
Yes |
|
Email ( From Forms) |
Yes |
Yes |
Yes |
|
FTP |
Yes |
Yes |
Yes - built-in 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 scheduler or via java libraries (quartz) |
|
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: in Jaspersoft Studio this is equivalent to BI Publisher, there are more than 20 templates. We can design drill-down templates, 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. |
||
|
Microsoft Excel = A few reports created as XLS template, in Excel (xls) with BI Publisher plug-in. |
Not Available |
||
|
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 - |
Yes - via a URL |
|
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 - |
No |
Yes (Interactive Reports) |
Yes, Enterprise Edition Only. Dynamic output available, 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 available, 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 also 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