Comparatif des technologies de rapports: Oracle Reports VS Oracle Analytics Publisher VS Tibco Jaspe
Comparaison des technologies de Reporting: Oracle Reports VS Oracle Analytics (BI Publisher) VS Jasper Reports
Comme le support Premium d'Oracle Reports tire à sa fin (Aout 2022) plusieurs organisations sont à choisir parmi les deux plus options de remplacement les plus populaires: Oracle Analytics Publisher ou Jasper Reports (Édition Enterprise ou communauté). Si tel est votre cas, vous vous demandez certainement quels sont les avanatages et inconvénients de chacun d'eux. Nous vous présentons ici un tableau comparatif des trois solutions.
Titleimage
Mis en ligne par Nestor Zuluaga le 2021:12:20 13:27:17
Some title here : Titre pour patrick.
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.
| Reports technologies Functionalities comparisons | 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 - 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 |
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. |
||
|
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 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.