ORACLE REPORTS TO JASPER – Q&A
Your Questions and Answers about the Migration from Oracle Reports to JasperReports
Why and how to modernize legacy applications efficiently
The 4 step migration path from legacy to modern reporting
BAR Group takes decision for PITSS Forms & Reports Manager
Your most important questions about a Oracle Reports to JasperReports migration
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 & Reports landscape.
Can we integrate JasperReports with Oracle Forms?
If you need to run the Reports asynchronous in the background, JasperServer provides a CLI, which you could integrate via DBMS_SCHEDULER as a one-time job or on a regular base.
How does the cost of JasperReports compare to the cost of a BI Publisher license?
If you like to use them outside the Forms ecosystem, you have to purchase a license via BI Suite or as a standalone component.
JasperReports is basically an open source tool without any license fees. You can purchase a support contract for error handling and maintenance.
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´s BI Suite.
Does JasperReports have any limitations that BI Publisher does not have?
What´s the difference between JasperReports and Oracle Reports?
What is the most important thing to validate before the change or migration?
Three things to keep in mind:
- Migration is a project and you should treat it seriously. It’s not only a click on a button and runs next to the daily work
- Take the chance to improve your reporting landscape. JasperReports provides concepts of reusability that aren’t available for Oracle Reports. Harmonizing the layout, consolidating queries and functions increases the maintainability afterwards
- 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
Is the Reports2Jasper Modeler an automated tool with minimum interaction from a developer?
Our product addresses the three most important issues during a migration:
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’t calculatable for a developer
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.
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.
How long to convert per Report?
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 – DML inside a format trigger is easy in Oracle Reports, but it’s not a good idea in JasperReports.
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!
Does JasperReports use the existing FMW Weblogic infrastructure?
Theoretically speaking yes – you could also deploy Jasper Server on WLS, but I haven’t seen any customer doing it yet. With a lightweight WebServer, the administration overhead is even smaller than with a WLS instance. Beside starting and stopping the managed server there aren’t any benefits for this infrastructure, isn’t it?
What about our Oracle Reports that we are executing in batch files? Do we have the same functionality with Jasper Reports?
What are the componants required to convert from oracle to Jasper? (server, license, cost, integration time frame, etc....)?
Could you connect more than one database to one report?
How does Jasper handle dashboards?
How long does it take for an Reports developer to become competent with Jasper?
How to connect with oracle database before migration?
Are there any Oracle Reports features that the conversion tool has difficulty converting? Such as conditional formatting, Graphs, etc?
Is it possible to send a Jasper report directly to a specified printer ?
We call and use a lot of database functions, can they be called and used in Jasper?
Does Oracle Apex have a report development tool? Can it create complicated reports like Oracle Reports and Jasper?
Is the development tool for the Pro and Community versions the same? Does it have the same functionality?
Can Jasper reports be called from Oracle Forms? We need to embed Jasper or whatever reporting tool we use into our application.
Does BI Publisher have a true development tool like Jasper and Oracle Reports?
1.) There is a webbased online design tool for simple reports. It’s easy to use but with limited functionalities.
2.) Microsoft Word. With this you create a RTF Template in the way you create classic form letters in Word.
3.) Direct writing of XSL without an IDE.
From the developer point of view, none of them is an IDE like Oracle Reports developer or Eclipse.
You said that Jasper reports is open source but on jaspersoft.com I see only a "Try Jaspersoft Free for 30 Days". It's open source or not?
Beside Oracle Application server also a Jasper Server is needed?
How the reports can be integrated into our current Banner CIS system and how we can create a Jaspersoft Dashboard to run the reports
JasperReports Dashboards are a functionality of the Server and you could configer them directly in the WebUI of the server.
Is Character based printing (invoices, pay checks) possible?
Is there a way of automatic conversion?
What about licensing to jasper reports? What about BI publisher/OAC and another open source reports options?
Is there any solution in APEX that will replace printing with Reports in Forms?
The answer could be given in two levels of complexity. If reporting is very easy, like a tab report of a query, you could use export functionality of an APEX grid. This allows you to create HTML, Excel or PDF Formats which could slightly be customized.
If reporting is getting more complex and see a lot of implementation in Oracle Reports, you should consider a separate solution. Preferred frameworks are BI Publisher, Jasper Reports or AOP.