{"id":1370,"date":"2017-04-24T08:00:49","date_gmt":"2017-04-24T06:00:49","guid":{"rendered":"http:\/\/www.pitss.org\/blog\/?p=1370"},"modified":"2018-02-20T17:18:29","modified_gmt":"2018-02-20T16:18:29","slug":"oracle-reports-and-the-alternatives","status":"publish","type":"post","link":"https:\/\/pitss.org\/de\/oracle-reports-and-the-alternatives\/","title":{"rendered":"Comparing JasperReports and BI Publisher"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;3.0.82&#8243; custom_margin=&#8220;|||&#8220; custom_padding=&#8220;0px|||&#8220;][et_pb_row _builder_version=&#8220;3.0.47&#8243; background_size=&#8220;initial&#8220; background_position=&#8220;top_left&#8220; background_repeat=&#8220;repeat&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_post_title author=&#8220;off&#8220; categories=&#8220;off&#8220; comments=&#8220;off&#8220; _builder_version=&#8220;3.0.89&#8243; title_font=&#8220;|on|||&#8220; title_font_size=&#8220;40px&#8220;][\/et_pb_post_title][et_pb_text _builder_version=&#8220;3.0.95&#8243;]<a href=\"https:\/\/pitss.org\/de\/oracle-reports-abloesung-alternativen\/\"><em><strong>German<\/strong>? Click here to go to Article &#8222;Oracle Reports Alternativen&#8220;<\/em><\/a><br \/>\n[\/et_pb_text][et_pb_text _builder_version=&#8220;3.0.95&#8243; background_color=&#8220;#e7e6e6&#8243; custom_padding=&#8220;20px|20px|20px|20px&#8220;]<em>&#8222;<a href=\"https:\/\/pitss.org\/de\/oracle-reports-abloesung-alternativen\/\">Oracle Reports<\/a> released with Oracle Fusion Middleware\u2019s 12.2.1.3.0 will be its terminal release. Oracle Reports will be supported in accordance with the Oracle Fusion Middleware Lifetime Support Policy. Customers are advised to use Oracle BI Publisher for their reporting needs.&#8220;<\/em><br \/>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;3.0.47&#8243; background_size=&#8220;initial&#8220; background_position=&#8220;top_left&#8220; background_repeat=&#8220;repeat&#8220;][et_pb_column type=&#8220;1_3&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_image src=&#8220;https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2017\/12\/JasperVSOracle-book-mockupMagazin-neu.jpg&#8220; url=&#8220;\/de\/jasper-reports-bi-publisher-whitepaper\/&#8220; _builder_version=&#8220;3.0.93&#8243;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8220;2_3&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_text _builder_version=&#8220;3.0.95&#8243; custom_margin=&#8220;-5px|||&#8220;]<\/p>\n<p>As mentioned in the statement of direction from October 2016 the next <a href=\"..\/oracle-forms-12c-features\/\">Oracle Forms release 12.2.1.3.0<\/a> will be the last which ships out <a href=\"..\/oracle-reports-abloesung-alternativen\/\">Oracle Reports.<\/a>\u00a0So Reports will not be part of future Oracle Forms releases, which leaves customers with the question of what to do. Oracle intends to push Oracle Forms customers towards the usage of BI Publisher, which is Oracle\u2019s preferred replacement for Reports. Therefore Oracle Forms 12c has been delivered with an much easier integration of the BI Publisher Reporting solution.<\/p>\n<p>But are there any other alternatives out for Oracle Forms customers? In this blogpost we would like to give you an overview over the two most frequently mentioned solutions when it comes to Oracle Reports alternatives: Oracle BI Publisher and <a href=\"..\/jasper-reports-review\/\">Jasper Reports<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;3.0.47&#8243; background_size=&#8220;initial&#8220; background_position=&#8220;top_left&#8220; background_repeat=&#8220;repeat&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_text _builder_version=&#8220;3.0.98&#8243;]<\/p>\n<h3><strong>BI Publisher<\/strong><\/h3>\n<p>If Oracle is asked, then there is only one real Oracle Reports replacement: Oracle BI Publisher. But BI Publisher (in the past XMLPublisher) is not a one-to-one replacement for Reports &#8211; it\u2019s rather a different concept for reporting that is quite different to <a href=\"..\/oracle-reports-abloesung-alternativen\/\">Reports<\/a>.<\/p>\n<p>BI Publisher divides the reporting into data, layout and language.<\/p>\n<p>This changes the flow of work when it comes to the creation of a report. The advantage is, that reports that use the same data source but have a different layout must not be created multiple times. For creating these different layout-templates the development environment or a Microsoft Word Add-in can be utilized. An additional advantage of BI Publisher compared to Reports is that BI Publisher supports many sources and export formats.<\/p>\n<p>One is not limited to an Oracle Database as a source of data &#8211; you can use different other sources like WebServices, files or external systems. Those can be exported to a wide range of formats like: PDF, PPT, SML, Excel to different output channels (printer, filesystem, mail etc.). BI Publisher additionally offers a dashboard functionality with which users can create their own reports. All of those mentioned possibilities make BI Publisher to a not to cheap Enterprise Reporting solution.<\/p>\n<p>If you have licensed the iAS-EE the use of BI Publisher is free of an extra charge.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8220;10px||0px|&#8220; _builder_version=&#8220;3.0.82&#8243;][et_pb_column type=&#8220;1_2&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_blurb title=&#8220;Pros&#8220; use_icon=&#8220;on&#8220; font_icon=&#8220;%%49%%&#8220; icon_color=&#8220;#00c136&#8243; icon_placement=&#8220;left&#8220; _builder_version=&#8220;3.0.91&#8243; header_font=&#8220;|on|||&#8220; animation=&#8220;off&#8220;]<\/p>\n<ul style=\"margin-left: -15px;\">\n<li><em>Full support from Oracle<\/em><\/li>\n<li><em>Multiple format output<\/em><\/li>\n<li><em>Oracle Migration Assistant (not error-free)<\/em><\/li>\n<li><em>Central reporting solution<\/em><\/li>\n<li><em>Existing PL \/ SQL logic can be reused<\/em><\/li>\n<li><em>Loose couple data, layout and distribution<\/em><\/li>\n<li><em>Multi Language Support<\/em><\/li>\n<li><em>Easy Integration in Forms\/APEX &amp; ADF<\/em><\/li>\n<li><em>Reports Scheduling &amp; Bursting<\/em><\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8220;1_2&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_blurb title=&#8220;Cons&#8220; use_icon=&#8220;on&#8220; font_icon=&#8220;%%48%%&#8220; icon_color=&#8220;#ff2b2b&#8220; icon_placement=&#8220;left&#8220; _builder_version=&#8220;3.0.82&#8243; header_font=&#8220;|on|||&#8220; animation=&#8220;off&#8220;]<\/p>\n<ul style=\"margin-left: -15px;\">\n<li><em>License fees (for non iAS customers)<\/em><\/li>\n<li><em>No fully automated migration of Oracle reports<\/em><\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8220;27px|0px|27px|0px&#8220; _builder_version=&#8220;3.0.82&#8243;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_text _builder_version=&#8220;3.0.95&#8243;]<\/p>\n<h3><a href=\"https:\/\/pitss.org\/de\/jasper-reports-review\/\"><strong>Jasper Reports (TIBCO)<\/strong><\/a><\/h3>\n<p>Before I would like to go over the benefits of using JasperReports here some points of the history of the product:<br \/>\n[\/et_pb_text][et_pb_blurb use_icon=&#8220;on&#8220; font_icon=&#8220;%%92%%&#8220; icon_placement=&#8220;left&#8220; use_icon_font_size=&#8220;on&#8220; icon_font_size=&#8220;22px&#8220; _builder_version=&#8220;3.0.92&#8243; animation=&#8220;off&#8220; custom_css_blurb_image=&#8220;width: 22px; padding-top: 2px;&#8220; custom_css_blurb_title=&#8220;margin-top: -8px;&#8220;]<span style=\"color: #006bb3;\"><strong>2001\u00a0<\/strong><\/span>\u2014 Created and launched by Teodor Danciu<br \/>\n[\/et_pb_blurb][et_pb_blurb use_icon=&#8220;on&#8220; font_icon=&#8220;%%92%%&#8220; icon_placement=&#8220;left&#8220; use_icon_font_size=&#8220;on&#8220; icon_font_size=&#8220;22px&#8220; _builder_version=&#8220;3.0.98&#8243; animation=&#8220;off&#8220; custom_css_blurb_image=&#8220;width: 22px; padding-top: 2px; &#8220; custom_css_blurb_title=&#8220;margin-top: -8px;&#8220;]<span style=\"color: #006bb3;\"><strong>2004\u00a0<\/strong><\/span>\u2014 Teamed up with Panscopic, forming Jaspersoft JasperReports Server, providing\u00a0 advanced report server capabilities, also open source<br \/>\n[\/et_pb_blurb][et_pb_blurb use_icon=&#8220;on&#8220; font_icon=&#8220;%%92%%&#8220; icon_placement=&#8220;left&#8220; use_icon_font_size=&#8220;on&#8220; icon_font_size=&#8220;22px&#8220; _builder_version=&#8220;3.0.98&#8243; animation=&#8220;off&#8220; custom_css_blurb_image=&#8220;width: 22px; padding-top: 2px;&#8220; custom_css_blurb_title=&#8220;margin-top: -8px;&#8220;]<span style=\"color: #006bb3;\"><strong>2014\u00a0<\/strong><\/span>\u2014 TIBCO acquired Jaspersoft<br \/>\n[\/et_pb_blurb][et_pb_text _builder_version=&#8220;3.0.98&#8243;]So you can see, that the product itself already has quite a history.<\/p>\n<p>So why should you consider Jasper Reports as a serious Oracle Reports alternative? Well there are quite a few good reasons, but the main one: It\u2019s open source \u2013 well at least to a certain degree. Jasper Reports is developed and maintained by Jaspersoft. You can create your JasperReports using the main library and distribute them as long as you don\u2019t change the source code. If you need further support from JasperSoft or different licensing, then you have to buy additional products.<\/p>\n<p>The second main reason for Jasper is, that it is written in Java, which is widely used. JasperReports can handle various data source options: JDBC, Hibernate, XML, EJB, POJO. While there are many data sources possible, there are loads of export formats available: PDF, HTML, XLS, RTF, ODT, XML, CSV, TXT, DOCX.<br \/>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8220;10px||0px|&#8220; custom_margin=&#8220;|||&#8220; _builder_version=&#8220;3.0.82&#8243;][et_pb_column type=&#8220;1_2&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_blurb title=&#8220;Pros&#8220; use_icon=&#8220;on&#8220; font_icon=&#8220;%%49%%&#8220; icon_color=&#8220;#00c136&#8243; icon_placement=&#8220;left&#8220; _builder_version=&#8220;3.0.82&#8243; header_font=&#8220;|on|||&#8220; animation=&#8220;off&#8220;]<\/p>\n<ul style=\"margin-left: -15px;\">\n<li><em>Flexible layout<\/em><\/li>\n<li><em>Multiple data sources \u2013 more than BIRT<\/em><\/li>\n<li><em>Multiple format output<\/em><\/li>\n<li><em>Jaspersoft Studio = WYSIWYG, Eclipse-based<\/em><\/li>\n<li><em>Expressions language: Java, JavaScript, Groovy<\/em><\/li>\n<li><em>Matrix reports, conditional formatting<\/em><\/li>\n<li><em>Supported platforms: Windows, Linux, Mac OS<\/em><\/li>\n<li><em>High quality page printing output<\/em><\/li>\n<li><em>Plugins for version control, including Subversion<\/em><\/li>\n<li><em>Generates reusable sub-reports<\/em><\/li>\n<li><em>Charting, graphics<\/em><\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8220;1_2&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_blurb title=&#8220;Cons&#8220; use_icon=&#8220;on&#8220; font_icon=&#8220;%%48%%&#8220; icon_color=&#8220;#ff2b2b&#8220; icon_placement=&#8220;left&#8220; _builder_version=&#8220;3.0.82&#8243; header_font=&#8220;|on|||&#8220; animation=&#8220;off&#8220;]<\/p>\n<ul style=\"margin-left: -15px;\">\n<li><em style=\"font-size: 16px;\">Difficult to learn<\/em><\/li>\n<li><em>SQL-designer available, but difficult to use<\/em><\/li>\n<\/ul>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;3.0.82&#8243;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_text _builder_version=&#8220;3.0.98&#8243;]While using Jasper Reports has some benefits it comes with some negative aspects and problems when you are moving from Oracle Reports. The biggest problem for most Oracle Reports developers will be the fact, that Jasper is not supporting PL\/SQL. So if there is a lot of logic or validation in your reports we recommend to move the PL\/SQL Code to the database and refactor the validation within Java.<br \/>\nAnother problem could be, that you need Java knowledge to utilize JasperReports: If you already have Java knowledge in your company your Java developers will find it easier to work with JasperReports, but if your developers are pure PL\/SQL developers Java training to a certain extend is not a bad idea. Also Java resources are quite common (Java is still the most famous programming language).<br \/>\n[\/et_pb_text][et_pb_text _builder_version=&#8220;3.0.98&#8243; custom_margin=&#8220;50px||50px|&#8220; custom_padding=&#8220;|||&#8220;]ProblemSolution<\/p>\n<table style=\"width: 100%; border: 1px #bbb solid; background: #E7E6E6;\">\n<tbody>\n<tr>\n<td style=\"border: 1px #999 solid;\">No PL\/SQL support<\/td>\n<td style=\"border: 1px #999 solid;\">move PL\/SQL to DB\/Java<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px #999 solid;\">No validation triggers<\/td>\n<td style=\"border: 1px #888 solid;\">refactor logic with Java<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px #999 solid;\">Generally limited triggers<\/td>\n<td style=\"border: 1px #999 solid;\">refactoring, sub-reports<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px #999 solid;\">No detailed filtering of query groups<\/td>\n<td style=\"border: 1px #999 solid;\">refactoring<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px #999 solid;\">No PL\/SQL formula columns<\/td>\n<td style=\"border: 1px #999 solid;\">refactoring<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px #999 solid;\">Too many sub-reports can result in very poor performance because each sub-report opens its own database connection, thread and query<\/td>\n<td style=\"border: 1px #999 solid;\">perfomance test + refactoring, if necessary<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8220;3.0.82&#8243; custom_margin=&#8220;||50px|&#8220;]<\/p>\n<h3><strong>Summary<\/strong><\/h3>\n<p>There is currently some pressure on Oracle Forms customers \u2013 we know that Oracle Forms 12.2.1.3.0 will be the last shipped with Reports. So there is the need for Oracle Reports developers \u00a0to look into the alternatives that the market provides. There are other alternatives available (BIRT, plpdf, etc\u2026) while BI Publisher and JasperReports are probably one that most customers look into.<\/p>\n<p>BI Publisher\u2019s big advantage is that existing PL\/SQL logic can be reused and if you have the iAS-EE license now free of use.<\/p>\n<p>For JasperReports speaks, that it\u2019s open source in parts and written in Java \u2013 if you plan to get away from Forms to Java at all I would consider using JasperReports for the Reporting. Both BI Publisher and JasperReports offer a wide range of input and output formats.<\/p>\n<p><em>by <a href=\"mailto:cpiasecki@pitss.org\">Christian Piasecki<\/a>\u00a0&amp;\u00a0<a href=\"mailto:dkampf@pitss.org\">Daniel Kampf<\/a><\/em><br \/>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=&#8220;40px|50px|45px|50px&#8220; custom_margin=&#8220;||50px|&#8220; background_color=&#8220;rgba(0,0,0,0.8)&#8220; _builder_version=&#8220;3.0.95&#8243; background_image=&#8220;https:\/\/pitss.org\/wp-content\/uploads\/2017\/05\/AdobeStock_87070391-3.jpeg&#8220; background_blend=&#8220;overlay&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;3.0.47&#8243; parallax=&#8220;off&#8220; parallax_method=&#8220;on&#8220;][et_pb_cta title=&#8220;Reports Orientation Day %91WORKSHOP%93&#8243; button_url=&#8220;https:\/\/pitss.org\/reports-orientation-day-workshop\/&#8220; button_text=&#8220;Schedule a workshop today&#8220; use_background_color=&#8220;off&#8220; _builder_version=&#8220;3.0.95&#8243; header_font=&#8220;|on|||&#8220; header_font_size=&#8220;34px&#8220; text_orientation=&#8220;left&#8220; border_style=&#8220;solid&#8220;]Schedule a Reports Orientation Day workshop to learn about Oracle Reports alternatives and make strategic decisions regarding your reporting future.<br \/>\n[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>German? Click here to go to Article &#8222;Oracle Reports Alternativen&#8220; &#8222;Oracle Reports released with Oracle Fusion Middleware\u2019s 12.2.1.3.0 will be its terminal release. Oracle Reports will be supported in accordance with the Oracle Fusion Middleware Lifetime Support Policy. Customers are advised to use Oracle BI Publisher for their reporting needs.&#8220; As mentioned in the statement [&hellip;]<\/p>\n","protected":false},"author":47,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[153,159,97,85,139,155,81],"tags":[205,120,74,206,207,208,209,66,127,211],"class_list":["post-1370","post","type-post","status-publish","format-standard","hentry","category-bi-publisher","category-development","category-forms_reports","category-java","category-oracle-forms-12c","category-oracle-reports","category-tech-blog","tag-12-2-1-3-0","tag-12c","tag-bi-publisher","tag-jasper","tag-jasper-reports","tag-jasperreports","tag-jaspersoft","tag-oracle","tag-oracle-forms","tag-reporting"],"_links":{"self":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/1370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/comments?post=1370"}],"version-history":[{"count":40,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/1370\/revisions"}],"predecessor-version":[{"id":19092,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/1370\/revisions\/19092"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/media?parent=1370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/categories?post=1370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/tags?post=1370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}