{"id":32827,"date":"2021-05-05T08:13:07","date_gmt":"2021-05-05T06:13:07","guid":{"rendered":"https:\/\/pitss.org\/de\/?p=32827"},"modified":"2022-04-19T15:47:37","modified_gmt":"2022-04-19T13:47:37","slug":"qa-boost-your-oracle-reports2jasper-reports","status":"publish","type":"post","link":"https:\/\/pitss.org\/de\/qa-boost-your-oracle-reports2jasper-reports\/","title":{"rendered":"Q&amp;A Boost your Oracle Reports2Jasper Reports"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#247df2&#8243; background_image=&#8220;https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/11\/Header-BLOG-ProjektDigital2000x550px.jpg&#8220; min_height=&#8220;400px&#8220; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_row _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; width=&#8220;75%&#8220; custom_margin=&#8220;10px|auto|||false|false&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_text content_tablet=&#8220;<\/p>\n<h1>PITSS Tech Blog<\/h1>\n<p>News zu Java, PL\/SQL, Entwicklung &#038; Technologiewechsel&#8220; content_phone=&#8220;<\/p>\n<h1>PITSS Tech Blog<\/h1>\n<p>News zu Java, PL\/SQL, Entwicklung &#038; Technologiewechsel&#8220; content_last_edited=&#8220;on|phone&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_font_size=&#8220;20px&#8220; text_line_height=&#8220;1.6em&#8220; header_font=&#8220;|||on|||||&#8220; header_text_align=&#8220;left&#8220; header_font_size=&#8220;2.5vw&#8220; header_line_height=&#8220;1.3em&#8220; background_color=&#8220;#ffffff&#8220; width=&#8220;55%&#8220; width_tablet=&#8220;&#8220; width_phone=&#8220;100%&#8220; width_last_edited=&#8220;on|phone&#8220; max_width=&#8220;100%&#8220; module_alignment=&#8220;left&#8220; custom_padding=&#8220;30px|30px|30px|30px|false|false&#8220; header_font_size_tablet=&#8220;&#8220; header_font_size_phone=&#8220;9vw&#8220; header_font_size_last_edited=&#8220;on|phone&#8220; border_radii=&#8220;on|12px|12px|12px|12px&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h1>PITSS Tech Blog<\/h1>\n<p>News zu Java, PL\/SQL, Entwicklung &amp; Technologiewechsel[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; specialty=&#8220;on&#8220; background_repeat_1=&#8220;no-repeat&#8220; background_repeat_2=&#8220;no-repeat&#8220; background_position_1=&#8220;top_left&#8220; background_position_2=&#8220;top_left&#8220; _builder_version=&#8220;4.15&#8243; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;3_4&#8243; specialty_columns=&#8220;3&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_row_inner admin_label=&#8220;Row&#8220; _builder_version=&#8220;4.15&#8243; global_colors_info=&#8220;{}&#8220;][et_pb_column_inner saved_specialty_column_type=&#8220;3_4&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text admin_label=&#8220;Text&#8220; _builder_version=&#8220;4.15.1&#8243; text_font=&#8220;Poppins|600|||||||&#8220; text_font_size=&#8220;34px&#8220; text_letter_spacing=&#8220;1px&#8220; text_line_height=&#8220;1.4em&#8220; header_letter_spacing=&#8220;1px&#8220; header_line_height=&#8220;1.3em&#8220; module_alignment=&#8220;left&#8220; z_index_tablet=&#8220;500&#8243; text_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; text_text_shadow_vertical_length_tablet=&#8220;0px&#8220; text_text_shadow_blur_strength_tablet=&#8220;1px&#8220; link_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; link_text_shadow_vertical_length_tablet=&#8220;0px&#8220; link_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ul_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ul_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ul_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ol_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ol_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ol_text_shadow_blur_strength_tablet=&#8220;1px&#8220; quote_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; quote_text_shadow_vertical_length_tablet=&#8220;0px&#8220; quote_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_2_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_2_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_2_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_3_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_3_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_3_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_4_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_4_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_4_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_5_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_5_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_5_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_6_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_6_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_6_text_shadow_blur_strength_tablet=&#8220;1px&#8220; box_shadow_horizontal_tablet=&#8220;0px&#8220; box_shadow_vertical_tablet=&#8220;0px&#8220; box_shadow_blur_tablet=&#8220;40px&#8220; box_shadow_spread_tablet=&#8220;0px&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>Q&amp;A &#8211; Boost your Oracle Reports2Jasper Reports [webcast]<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8220;Text&#8220; _builder_version=&#8220;4.15&#8243; text_font=&#8220;Poppins||||||||&#8220; module_alignment=&#8220;left&#8220; z_index_tablet=&#8220;500&#8243; text_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; text_text_shadow_vertical_length_tablet=&#8220;0px&#8220; text_text_shadow_blur_strength_tablet=&#8220;1px&#8220; link_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; link_text_shadow_vertical_length_tablet=&#8220;0px&#8220; link_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ul_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ul_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ul_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ol_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ol_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ol_text_shadow_blur_strength_tablet=&#8220;1px&#8220; quote_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; quote_text_shadow_vertical_length_tablet=&#8220;0px&#8220; quote_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_2_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_2_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_2_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_3_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_3_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_3_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_4_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_4_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_4_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_5_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_5_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_5_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_6_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_6_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_6_text_shadow_blur_strength_tablet=&#8220;1px&#8220; box_shadow_horizontal_tablet=&#8220;0px&#8220; box_shadow_vertical_tablet=&#8220;0px&#8220; box_shadow_blur_tablet=&#8220;40px&#8220; box_shadow_spread_tablet=&#8220;0px&#8220; global_colors_info=&#8220;{}&#8220;]<i>\u201cFor us Jasper Reports is the ideal technology to replace Oracle Reports. PITSS helped us with the technology selection and guided us through the migration project. \u201d (Customer)<\/i><\/p>\n<p><i>\u201cWith more than 15 million downloads, it is the reporting engine that takes raw data and turns it into beautifully rendered reports and data visualizations. (TIBCO Jaspersoft)<\/i><\/p>\n<p>The high interest in last week&#8217;s <b>#LiveMigration Oracle Reports to Jasper Reports<\/B> confirmed the significance of the topic. About <B>#100 attendees<\/B> and their interesting questions about the expiration of Oracle Reports support and the great future of Jasper Reports inspired this event.<br \/>\nSee some FAQs from this webcast, which will help you on the way to <b>your migration project of Oracle Reports<\/b>.[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=&#8220;4.15&#8243; custom_margin=&#8220;||0px||false|false&#8220; custom_padding=&#8220;||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column_inner saved_specialty_column_type=&#8220;3_4&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; text_font=&#8220;Poppins|500|||||||&#8220; text_font_size=&#8220;24px&#8220; text_letter_spacing=&#8220;1px&#8220; text_line_height=&#8220;1.3em&#8220; z_index_tablet=&#8220;500&#8243; text_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; text_text_shadow_vertical_length_tablet=&#8220;0px&#8220; text_text_shadow_blur_strength_tablet=&#8220;1px&#8220; link_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; link_text_shadow_vertical_length_tablet=&#8220;0px&#8220; link_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ul_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ul_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ul_text_shadow_blur_strength_tablet=&#8220;1px&#8220; ol_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; ol_text_shadow_vertical_length_tablet=&#8220;0px&#8220; ol_text_shadow_blur_strength_tablet=&#8220;1px&#8220; quote_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; quote_text_shadow_vertical_length_tablet=&#8220;0px&#8220; quote_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_2_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_2_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_2_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_3_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_3_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_3_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_4_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_4_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_4_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_5_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_5_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_5_text_shadow_blur_strength_tablet=&#8220;1px&#8220; header_6_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; header_6_text_shadow_vertical_length_tablet=&#8220;0px&#8220; header_6_text_shadow_blur_strength_tablet=&#8220;1px&#8220; box_shadow_horizontal_tablet=&#8220;0px&#8220; box_shadow_vertical_tablet=&#8220;0px&#8220; box_shadow_blur_tablet=&#8220;40px&#8220; box_shadow_spread_tablet=&#8220;0px&#8220; global_colors_info=&#8220;{}&#8220;]Your most important questions about an Oracle Reports to JasperReports migration<\/strong><\/h3>\n<p>[\/et_pb_text][et_pb_accordion open_toggle_background_color=&#8220;#f4951f&#8220; closed_toggle_background_color=&#8220;#ffffff&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; toggle_font=&#8220;|600|||||||&#8220; custom_margin=&#8220;||60px|||&#8220; hover_enabled=&#8220;0&#8243; z_index_tablet=&#8220;500&#8243; toggle_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; toggle_text_shadow_vertical_length_tablet=&#8220;0px&#8220; toggle_text_shadow_blur_strength_tablet=&#8220;1px&#8220; closed_toggle_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; closed_toggle_text_shadow_vertical_length_tablet=&#8220;0px&#8220; closed_toggle_text_shadow_blur_strength_tablet=&#8220;1px&#8220; body_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; body_text_shadow_vertical_length_tablet=&#8220;0px&#8220; body_text_shadow_blur_strength_tablet=&#8220;1px&#8220; body_link_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; body_link_text_shadow_vertical_length_tablet=&#8220;0px&#8220; body_link_text_shadow_blur_strength_tablet=&#8220;1px&#8220; body_ul_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; body_ul_text_shadow_vertical_length_tablet=&#8220;0px&#8220; body_ul_text_shadow_blur_strength_tablet=&#8220;1px&#8220; body_ol_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; body_ol_text_shadow_vertical_length_tablet=&#8220;0px&#8220; body_ol_text_shadow_blur_strength_tablet=&#8220;1px&#8220; body_quote_text_shadow_horizontal_length_tablet=&#8220;0px&#8220; body_quote_text_shadow_vertical_length_tablet=&#8220;0px&#8220; body_quote_text_shadow_blur_strength_tablet=&#8220;1px&#8220; box_shadow_horizontal_tablet=&#8220;0px&#8220; box_shadow_vertical_tablet=&#8220;0px&#8220; box_shadow_blur_tablet=&#8220;40px&#8220; box_shadow_spread_tablet=&#8220;0px&#8220; text_shadow_horizontal_length_tablet=&#8220;0px&#8220; text_shadow_vertical_length_tablet=&#8220;0px&#8220; text_shadow_blur_strength_tablet=&#8220;1px&#8220; global_colors_info=&#8220;{}&#8220; sticky_enabled=&#8220;0&#8243;][et_pb_accordion_item title=&#8220;Why JasperReports?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]JasperReports is one of the most popular and best open source reporting tools<br \/>\n(https:\/\/lnkd.in\/dvCzWEg)<br \/>\nand all requirements that you could implement with Oracle Reports are already covered by the community edition of JasperReports.<\/p>\n<p>The IDE is very familiar for all Java Developers and the concepts of bands, lists, subreports and scriptlets are in straight line. The learning of this framework is smooth and fast. With the Oracle Data Connector and the possibilities to consume Reports via URL and web services allows JasperReports to easily integrate into a classical Forms &amp; Reports landscape.[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Can we integrate JasperReports with Oracle Forms?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]\ud835\udc18\ud835\udc1e\ud835\udc2c, \ud835\udc2d\ud835\udc21\ud835\udc1a\ud835\udc2d\u2019\ud835\udc2c \ud835\udc29\ud835\udc28\ud835\udc2c\ud835\udc2c\ud835\udc22\ud835\udc1b\ud835\udc25\ud835\udc1e. In general there are three different layers, on which you can communicate to the JasperReports Server. The easiest one is to build an URL and call the Report via WEB.SHOW_DOCUMENT from the Forms module. The second approach allows more options for treating the output. You could consume the REST-API (described in our BLOG: https:\/\/lnkd.in\/gKCx-qFj) inside any PL\/SQL Package.<\/p>\n<p>If you need to run the Reports asynchronous in the background, JasperServer provides a CLI, which you could integrate via DBMS_SCHEDULAR as a one-time job or on a regular base.<br \/>\n[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How does the cost of JasperReports compare to the cost of a BI Publisher license?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]\ud835\udc11\ud835\udc28\ud835\udc2e\ud835\udc20\ud835\udc21\ud835\udc25\ud835\udc32 \ud835\udc2c\ud835\udc29\ud835\udc1e\ud835\udc1a\ud835\udc24\ud835\udc22\ud835\udc27\ud835\udc20, \ud835\udc1f\ud835\udc28\ud835\udc2b \ud835\udc0e\ud835\udc2b\ud835\udc1a\ud835\udc1c\ud835\udc25\ud835\udc1e \ud835\udc05\ud835\udc28\ud835\udc2b\ud835\udc26\ud835\udc2c \ud835\udc1c\ud835\udc2e\ud835\udc2c\ud835\udc2d\ud835\udc28\ud835\udc26\ud835\udc1e\ud835\udc2b\ud835\udc2c \ud835\udc30\ud835\udc22\ud835\udc2d\ud835\udc21 \ud835\udc1a \ud835\udc2f\ud835\udc1a\ud835\udc25\ud835\udc22\ud835\udc1d \ud835\udc2c\ud835\udc2e\ud835\udc29\ud835\udc29\ud835\udc28\ud835\udc2b\ud835\udc2d \ud835\udc1c\ud835\udc28\ud835\udc27\ud835\udc2d\ud835\udc2b\ud835\udc1a\ud835\udc1c\ud835\udc2d, \ud835\udc01\ud835\udc08 \ud835\udc0f\ud835\udc2e\ud835\udc1b\ud835\udc25\ud835\udc22\ud835\udc2c\ud835\udc21\ud835\udc1e\ud835\udc2b (\ud835\udc27\ud835\udc28\ud835\udc30\ud835\udc1a\ud835\udc1d\ud835\udc1a\ud835\udc32\ud835\udc2c \ud835\udc1c\ud835\udc1a\ud835\udc25\ud835\udc25\ud835\udc1e\ud835\udc1d \ud835\udc00\ud835\udc27\ud835\udc1a\ud835\udc25\ud835\udc32\ud835\udc2d\ud835\udc22\ud835\udc1c\ud835\udc2c \ud835\udc0f\ud835\udc2e\ud835\udc1b\ud835\udc25\ud835\udc22\ud835\udc2c\ud835\udc21\ud835\udc1e\ud835\udc2b) \ud835\udc22\ud835\udc2c \ud835\udc29\ud835\udc1a\ud835\udc2b\ud835\udc2d \ud835\udc28\ud835\udc1f \ud835\udc2d\ud835\udc21\ud835\udc1e \ud835\udc05\ud835\udc28\ud835\udc2b\ud835\udc26\ud835\udc2c\/\ud835\udc11\ud835\udc1e\ud835\udc29\ud835\udc28\ud835\udc2b\ud835\udc2d\ud835\udc2c \ud835\udc05\ud835\udc0c\ud835\udc16 \ud835\udc25\ud835\udc22\ud835\udc1c\ud835\udc1e\ud835\udc27\ud835\udc2c\ud835\udc1e.<\/p>\n<p>If you like to use them outside the Forms ecosystem, you have to purchase a license via BI Suite or as a standalone component.<br \/>\nJasperReports is basically an open source tool without any license fees. You can purchase a support contract for error handling and maintenance.<\/p>\n<p>Beside BI Publisher, JasperReports provides different editions with diverse functionalities. Out of our experience the Community Edition (open source) of JasperReports covers all functionalities you got with Oracle Reports as well. The most complex edition (TIBCO Jaspersoft) is a full BI Solution comparable to Oracle\u00b4s BI Suite.<br \/>\n[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Does JasperReports have any limitations that BI Publisher does not have?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]The functionality of the Community Edition covers the possibilities of Oracle Reports, but has less functionalities than the Oracle BI Publisher. Oracle BI Publisher provides features like self-service portals, reusable data models, multiple delivery channels, etc. If you need those functionalities you can consider the commercial version of JasperReports that has more features and is similar to BI Publisher. If you need more information, request our whitepaper \u201cJasperReports vs Oracle BI Publisher\u201d at <a href=\"Mailto: customerservice@pitss.org\"><span style=\"color: #ffffff;\"><u>customerservice@pitss.org<\/u><\/span><\/a>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;What\u00b4s the difference between JasperReports and Oracle Reports?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]When you run the JasperServer you will see a similar concept. You need a WebServer that can be a lightweight one (TomCat), define some data connections and manage a repository, where you deploy your Reports in. If you like to leave Oracle Forms as well, JasperReports provides an alternative infrastructure with the server as a JAR-Library that you could deploy next to your application code. [\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;What is the most important thing to validate before the change or migration? &#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220; body_ul_letter_spacing=&#8220;1px&#8220; body_ul_font_size=&#8220;16px&#8220;]Three things to keep in mind:<\/p>\n<ul>\n<li>Migration is a project and you should treat it seriously. It&#8217;s not only a click on a button and runs next to the daily work<\/li>\n<li>Take the chance to improve your reporting landscape. JasperReports provides concepts of reusability that aren\u2019t available for Oracle Reports. Harmonizing the layout, consolidating queries and functions increases the maintainability afterwards<\/li>\n<li>Destress yourself and run a fine grained stage approach. You can migrate and deploy one Report after the other, because the customer cannot figure out if the PDF comes from JasperReports or Oracle Reports.<\/li>\n<\/ul>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Is the Reports2Jasper Modeler an automated tool with minimum interaction from a developer?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220;]Yes, that is our \u201cWHY\u201d, so the reason why we do it.<\/p>\n<p>Our product addresses the three most important issues during a migration: <\/p>\n<p>1.) #SimplifyComplexity: Finding patterns in 1000 of Reports, proof assumptions of all code fragments before deciding on a new direction, show and follow global dependencies that aren\u2019t calculatable for a developer <\/p>\n<p>2.) #LegacyCodeMatters: If you start to develop from scratch, you may miss requirements, fail during implementation of complex queries and functions and face a huge test effort. Taking care of the existing code base as a baseline or springboard, reduces the risk and effort.<\/p>\n<p>3.) #DontRepeateYourself: However, you develop and will reach a point where you step into repeatable actions. That is a point where our product supports generation capabilities that could be highly customized. [\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How long to convert per Report?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220;]That depends on the complexity of the existing Report. We saw implementations with dozens of queries, nearly infinite loops of repeating frames and thousands of LOC inside functions. <\/p>\n<p>In some cases, not only the amount of objects derives the effort of finalizing the Report. The question is if the existing code (and requirements) addresses an existing solution in Jasper or not. As an example &#8211; DML inside a format trigger is easy in Oracle Reports, but it\u2019s not a good idea in JasperReports.<\/p>\n<p>Before you even calculate your project, our product can easily calculate the effort and obstacles of the migration, based exactly on your sources. Check it out!<br \/>\n[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Does JasperReports use the existing FMW Weblogic infrastructure?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220; sticky_enabled=&#8220;0&#8243; toggle_font=&#8220;Poppins|600|||||||&#8220; toggle_font_size=&#8220;16px&#8220;]<\/p>\n<p>Theoretically speaking yes &#8211; you could also deploy Jasper Server on WLS, but I haven&#8217;t seen any customer doing it yet. With a lightweight WebServer, the administration overhead is even smaller than with a WLS instance. Besides starting and stopping the managed server there aren\u2019t any benefits for this infrastructure, isn\u2019t it?<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;What about our Oracle Reports that we are executing in batch files? Do we have the same functionality with Jasper Reports?&#8220; open=&#8220;on&#8220; open_toggle_background_color=&#8220;#2047c1&#8243; closed_toggle_text_color=&#8220;#000000&#8243; closed_toggle_background_color=&#8220;#FFFFFF&#8220; _builder_version=&#8220;4.15.1&#8243; _module_preset=&#8220;default&#8220; body_text_color=&#8220;#FFFFFF&#8220; global_colors_info=&#8220;{}&#8220; toggle_text_color=&#8220;#FFFFFF&#8220;]<\/p>\n<p>Yes &#8211; you could run Jasper also from command line<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;What are the componants required to convert from oracle to Jasper? (server, license, cost, integration time frame, etc&#8230;.)?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]The typical starting point is: Tomcat with Jasper Server, Jasper Server in open-source community edition, integrate via WebService. Time Frame depends on the complexity of your reports[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Could you connect more than one database to one report?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]Yes! [\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How does Jasper handle dashboards?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>From the JasperReports Server User Guide: &#8222;A Jaspersoft Dashboard displays several reports in a single, integrated view. A dashboard can include other dashboards, input controls for choosing the data displayed in one or more frames, and custom frames that point to URLs for other content. By combining different types of related content, you can create appealing, data-rich dashboards that quickly convey trends.&#8220;<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How long does it take for an Reports developer to become competent with Jasper?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>I take a 5 day training and I\u2019m able to migrate the simple reports. My colleague, which are more familiar, have a very cool learning curve and after 2-3 month they are ready to take the biggest one. It\u2019s importent to train on the job and start with the easy once.<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How to connect with oracle database before migration?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Use setup database connections via JDBC inside the IDE. The report reference to the name of the db-connection, which could differ from IDE to test and production environment.\u00a0<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Are there any Oracle Reports features that the conversion tool has difficulty converting? Such as conditional formatting, Graphs, etc?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>We don\u2019t cover matrix reports by now (matter of not realy used by the customers so far) and we advise to redo graphics, because they are cool in Jasper and fast to setup.<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Is it possible to send  a Jasper report directly to a specified printer ?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]That is typically a task for a java post processing implementation. There is no out-of-the box solution in the jasper server, but this could be easily enhanced.[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;We call and use a lot of database functions, can they be called and used in Jasper?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]Yes &#8211; in the Query and within the scriplets.[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Does Oracle Apex have a report development tool?  Can it create complicated reports like Oracle Reports and Jasper?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]There is no APEX internal reporting tool available. You could use the export functionalities of Interactive Grids. Oracle tend to integrate AOP &#8211; we are also work on migration to this approach.[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Is the development tool for the Pro and Community versions the same?  Does it have the same functionality?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]If you cover the functionalities from Oracle Reports the \u201ebasics\u201c in Community and Pro are enough and the same. There are some addons in the Pro, which enhance the functionality (e.g. customizable Dashboards, etc.) but we do not rely on this in the migration. Most of our customer use the community edition[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Can Jasper reports be called from Oracle Forms?  We need to embed Jasper or whatever reporting tool we use into our application.&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Yes &#8211; you could integrate this via WebServices and Web.Show_Document features in Oracle Forms.\u00a0<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Does BI Publisher have a true development tool like Jasper and Oracle Reports?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>BI Publisher provide three different ways to create a layout for a designed data model:<br \/>1.) There is a webbased online design tool for simple reports. It&#8217;s easy to use but with limited functionalities.\u00a0<br \/>2.) Microsoft Word. With this you create a RTF Template in the way you create classic form letters in Word.\u00a0<br \/>3.) Direct writing of XSL without an IDE.\u00a0<br \/>From the developer point of view, none of them is an IDE like Oracle Reports developer or Eclipse.\u00a0<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Beside Oracle Application server also a Jasper Server is needed?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>You could integrate Jasper as a Java-class in your application or you could use the jasper server. This is usualy deployed on a lightweight server like tomcat or in Forms environment also on a WLS.<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;You said that Jasper reports is open source but on jaspersoft.com I see only a %22Try Jaspersoft Free for 30 Days%22. It&#8217;s open source or not?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>There are different downloads on the Jasper WebSite. There is a community edition and a pro edition available.<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;How the reports can be integrated into our current Banner CIS system and how we can create a Jaspersoft Dashboard to run the reports&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Jasperreports typically provide two different ways of integration. On one hand you can use the Jasperreports Javaclasses and embedding them into a Javabased application. With the API you could run the reports. On the other hand you could use the Jasperreports Server and communicate with them via webservices.\u00a0<br \/>Jasper Reports Dashboards are a functionality of the Server and you could configer them directly in the WebUI of the server.\u00a0<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Is Character based printing (invoices, pay checks) possible?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Yes, you could also create reports like invoices, pay checks, etc. with Jasper.\u00a0<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;Is there a way of automatic conversion?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Yes, try our Reports Replacer Kit!<\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8220;What about licensing to jasper reports?  What about BI publisher\/OAC and another open source reports options?&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; open=&#8220;off&#8220;]<\/p>\n<p>Jasper provide different Versions (community, professional, etc.) which have different licence costs. The community edition is the only free version of those you mentioned. BI Publisher and OAC are not free and need a licence of the Server or the cloud offerings. If you like to discuss other reports solution (BIRT, AOP, PLPDF, etc.) or if you are interested in any kind of licence, please get in contact with sales@pitss.org<\/p>\n<p>[\/et_pb_accordion_item][\/et_pb_accordion][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column_inner saved_specialty_column_type=&#8220;3_4&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_font=&#8220;Poppins||||||||&#8220; text_letter_spacing=&#8220;1px&#8220; custom_margin=&#8220;0px||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p>The next recommended step is to take the <b>Free Migration Quickcheck<\/b> to see your Oracle Reports being migrated to Jasper Reports.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8220;https:\/\/pitss.org\/reports2jasper-free-quick-check&#8220; button_text=&#8220;Learn more&#8220; button_alignment=&#8220;center&#8220; _builder_version=&#8220;4.7.0&#8243; _module_preset=&#8220;default&#8220; custom_button=&#8220;on&#8220; button_text_color=&#8220;#ffffff&#8220; button_bg_image=&#8220;https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2021\/02\/hg_green.png&#8220; button_border_radius=&#8220;12px&#8220; button_letter_spacing=&#8220;1px&#8220; button_font=&#8220;Poppins|700|||||||&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_button][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner admin_label=&#8220;Zeile&#8220; _builder_version=&#8220;4.15&#8243; global_colors_info=&#8220;{}&#8220;][et_pb_column_inner saved_specialty_column_type=&#8220;3_4&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; text_font=&#8220;Poppins||||||||&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<h2>Any question left?<\/h2>\n<p>Could you find all the answers to your questions on this page? If not, we will be happy to be there for you personally and clarify all open points. Just fill out the form below and we will get back to you as soon as possible.<\/p>\n<p>[ninja_form id=6][\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=&#8220;1_4&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_sidebar orientation=&#8220;right&#8220; area=&#8220;et_pb_widget_area_1&#8243; _builder_version=&#8220;4.15&#8243; global_colors_info=&#8220;{}&#8220;][\/et_pb_sidebar][et_pb_button button_url=&#8220;https:\/\/pitss.org\/de\/techblog&#8220; button_text=&#8220;\u2191 Zur\u00fcck zur \u00dcbersicht&#8220; button_alignment=&#8220;center&#8220; _builder_version=&#8220;3.16&#8243; custom_button=&#8220;on&#8220; button_text_size=&#8220;16&#8243; button_text_color=&#8220;#9b9b9b&#8220; button_border_color=&#8220;#d2d2d2&#8243; button_letter_spacing_hover=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; button_text_size__hover_enabled=&#8220;off&#8220; button_one_text_size__hover_enabled=&#8220;off&#8220; button_two_text_size__hover_enabled=&#8220;off&#8220; button_text_color__hover_enabled=&#8220;off&#8220; button_one_text_color__hover_enabled=&#8220;off&#8220; button_two_text_color__hover_enabled=&#8220;off&#8220; button_border_width__hover_enabled=&#8220;off&#8220; button_one_border_width__hover_enabled=&#8220;off&#8220; button_two_border_width__hover_enabled=&#8220;off&#8220; button_border_color__hover_enabled=&#8220;off&#8220; button_one_border_color__hover_enabled=&#8220;off&#8220; button_two_border_color__hover_enabled=&#8220;off&#8220; button_border_radius__hover_enabled=&#8220;off&#8220; button_one_border_radius__hover_enabled=&#8220;off&#8220; button_two_border_radius__hover_enabled=&#8220;off&#8220; button_letter_spacing__hover_enabled=&#8220;on&#8220; button_letter_spacing__hover=&#8220;0&#8243; button_one_letter_spacing__hover_enabled=&#8220;off&#8220; button_two_letter_spacing__hover_enabled=&#8220;off&#8220; button_bg_color__hover_enabled=&#8220;off&#8220; button_one_bg_color__hover_enabled=&#8220;off&#8220; button_two_bg_color__hover_enabled=&#8220;off&#8220;][\/et_pb_button][et_pb_image src=&#8220;https:\/\/pitss.org\/wp-content\/uploads\/2021\/05\/Anzeige-QuickCheck.jpg&#8220; title_text=&#8220;Anzeige-QuickCheck&#8220; url=&#8220;https:\/\/pitss.org\/reports2jasper-free-quick-check&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][\/et_pb_column][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; custom_padding_last_edited=&#8220;on|desktop&#8220; disabled_on=&#8220;off|off|off&#8220; admin_label=&#8220;section&#8220; module_id=&#8220;kontakt&#8220; module_class=&#8220;white-text&#8220; _builder_version=&#8220;4.15&#8243; background_color=&#8220;#757575&#8243; custom_padding_tablet=&#8220;50px|0|50px|0&#8243; custom_padding_phone=&#8220;&#8220; z_index_tablet=&#8220;500&#8243; transparent_background=&#8220;off&#8220; padding_mobile=&#8220;off&#8220; width_unit=&#8220;off&#8220; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_row column_padding_mobile=&#8220;on&#8220; admin_label=&#8220;row&#8220; module_id=&#8220;contact&#8220; _builder_version=&#8220;4.15&#8243; background_size=&#8220;initial&#8220; background_position=&#8220;top_left&#8220; background_repeat=&#8220;repeat&#8220; custom_margin=&#8220;0px||||false|false&#8220; custom_padding=&#8220;1px||||false|false&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_image src=&#8220;https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2019\/05\/PITSS-Logo-White.png&#8220; title_text=&#8220;PITSS-Logo-White&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; max_width=&#8220;31%&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8220;1_3,1_3,1_3&#8243; padding_mobile=&#8220;off&#8220; column_padding_mobile=&#8220;on&#8220; admin_label=&#8220;row&#8220; module_id=&#8220;contact&#8220; _builder_version=&#8220;4.15&#8243; background_size=&#8220;initial&#8220; background_position=&#8220;top_left&#8220; background_repeat=&#8220;repeat&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;1_3&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_font_size=&#8220;20px&#8220; text_letter_spacing=&#8220;1px&#8220; header_3_font_size=&#8220;1.6vw&#8220; header_4_font_size=&#8220;1.1vw&#8220; background_layout=&#8220;dark&#8220; text_font_size_tablet=&#8220;13px&#8220; text_font_size_phone=&#8220;13px&#8220; text_font_size_last_edited=&#8220;on|phone&#8220; header_3_font_size_tablet=&#8220;3vw&#8220; header_3_font_size_phone=&#8220;4vw&#8220; header_3_font_size_last_edited=&#8220;on|phone&#8220; header_4_font_size_tablet=&#8220;2.4vw&#8220; header_4_font_size_phone=&#8220;3.6vw&#8220; header_4_font_size_last_edited=&#8220;on|phone&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p><span style=\"font-size:24px\"><strong>Popul\u00e4re Themen<\/strong><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/migration-oracle-forms-nach-apex\">Forms nach APEX<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/migration-reports-nach-jasper\/\">Reports nach Jasper<\/a><\/span><\/p>\n<p>[\/et_pb_text][et_pb_divider show_divider=&#8220;off&#8220; disabled_on=&#8220;on|on|off&#8220; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; height=&#8220;100px&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_divider][\/et_pb_column][et_pb_column type=&#8220;1_3&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_font_size=&#8220;20px&#8220; text_letter_spacing=&#8220;1px&#8220; header_3_font_size=&#8220;1.6vw&#8220; header_4_font_size=&#8220;1.1vw&#8220; background_layout=&#8220;dark&#8220; text_font_size_tablet=&#8220;13px&#8220; text_font_size_phone=&#8220;13px&#8220; text_font_size_last_edited=&#8220;on|phone&#8220; header_3_font_size_tablet=&#8220;3vw&#8220; header_3_font_size_phone=&#8220;4vw&#8220; header_3_font_size_last_edited=&#8220;on|phone&#8220; header_4_font_size_tablet=&#8220;2.4vw&#8220; header_4_font_size_phone=&#8220;3.6vw&#8220; header_4_font_size_last_edited=&#8220;on|phone&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p><span style=\"font-size:24px\"><strong>Mehr Informationen<\/strong><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/produkte\/\">Produkte<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/referenzen\/\">Referenzen<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/unternehmen\/karriere\/\">Karriere<\/a><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;1_3&#8243; _builder_version=&#8220;4.15&#8243; custom_padding=&#8220;|||&#8220; global_colors_info=&#8220;{}&#8220; custom_padding__hover=&#8220;|||&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_font_size=&#8220;20px&#8220; text_letter_spacing=&#8220;1px&#8220; header_3_font_size=&#8220;1.6vw&#8220; header_4_font_size=&#8220;1.1vw&#8220; background_layout=&#8220;dark&#8220; text_font_size_tablet=&#8220;13px&#8220; text_font_size_phone=&#8220;13px&#8220; text_font_size_last_edited=&#8220;on|phone&#8220; header_3_font_size_tablet=&#8220;3vw&#8220; header_3_font_size_phone=&#8220;4vw&#8220; header_3_font_size_last_edited=&#8220;on|phone&#8220; header_4_font_size_tablet=&#8220;2.4vw&#8220; header_4_font_size_phone=&#8220;3.6vw&#8220; header_4_font_size_last_edited=&#8220;on|phone&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p><span style=\"font-size:24px\"><strong>N\u00fctzliches<\/strong><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/jirapitss.atlassian.net\/servicedesk\/customer\/portal\/7\/user\/login?destination=portal%2F7\">Developer Support<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/newsletter-anmeldung\/\">Newsletter<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/projektdigital\/\">Blog<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/us\/knowledgebase\/\">Knowledgebase<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/impressum\/\">Impressum<\/a><\/span><\/p>\n<p><span style=\"color: #ffffff\"><a style=\"color: #ffffff\" href=\"https:\/\/pitss.org\/de\/datenschutzerklarung\/\">Datenschutzrichtlinie<\/a><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8220;3_5,2_5&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; custom_margin_tablet=&#8220;30px||||false|false&#8220; custom_margin_phone=&#8220;&#8220; custom_margin_last_edited=&#8220;on|phone&#8220; custom_padding=&#8220;||0px|||&#8220; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_column type=&#8220;3_5&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][\/et_pb_column][et_pb_column type=&#8220;2_5&#8243; _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220;][et_pb_text _builder_version=&#8220;4.15&#8243; _module_preset=&#8220;default&#8220; text_orientation=&#8220;center&#8220; width=&#8220;100%&#8220; module_alignment=&#8220;center&#8220; global_colors_info=&#8220;{}&#8220;]<\/p>\n<p><a href=\"https:\/\/twitter.com\/PITSS_GmbH\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30547 size-medium\" src=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Twitter-300x219.png\" alt=\"\" width=\"40\" height=\"30\" srcset=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Twitter-300x219.png 300w, https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Twitter-400x300.png 400w, https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Twitter.png 411w\" sizes=\"auto, (max-width: 40px) 100vw, 40px\" \/><\/a>\u00a0<a href=\"https:\/\/www.linkedin.com\/company\/69888\/admin\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30545 size-medium\" src=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/LikedIn-300x266.png\" alt=\"\" width=\"32\" height=\"30\" \/><\/a>\u00a0<a href=\"https:\/\/www.xing.com\/companies\/pitssgmbh\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30548 size-medium\" src=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Xing.png\" alt=\"\" width=\"30\" height=\"30\" srcset=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Xing.png 300w, https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/Xing-150x150.png 150w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/><\/a>\u00a0<a href=\"https:\/\/www.youtube.com\/user\/pitssam\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30546 size-medium\" src=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/YouTube-300x179.png\" alt=\"\" width=\"46\" height=\"46\" \/><\/a>\u00a0<a href=\"https:\/\/www.facebook.com\/PitssDE\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30544 size-thumbnail\" src=\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2020\/10\/facebook-logo-150x150.png\" alt=\"\" width=\"30\" height=\"30\" \/><\/a><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PITSS Tech Blog News zu Java, PL\/SQL, Entwicklung &amp; TechnologiewechselQ&amp;A &#8211; Boost your Oracle Reports2Jasper Reports [webcast]\u201cFor us Jasper Reports is the ideal technology to replace Oracle Reports. PITSS helped us with the technology selection and guided us through the migration project. \u201d (Customer) \u201cWith more than 15 million downloads, it is the reporting engine [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":25953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[81],"tags":[434],"class_list":["post-32827","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-blog","tag-oracle-autonomous-database"],"_links":{"self":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/32827","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/comments?post=32827"}],"version-history":[{"count":10,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/32827\/revisions"}],"predecessor-version":[{"id":34862,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/posts\/32827\/revisions\/34862"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/media\/25953"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/media?parent=32827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/categories?post=32827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/de\/wp-json\/wp\/v2\/tags?post=32827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}