at the next ODTUG conference (http://kscope12.com/) I will be speaking about about moving your existing reports written in Oracle Reports to JasperReports.
Since many people are moving away from Oracle Forms, Oracle APEX seems to be a natural choice, since you can leverage your existing PL/Skills as well as your existing PL/SQL business logic nicely.
But what about your reporting needs? What alternative will you choose for your existing reports written in Oracle Reports?
What questions would be interesting for making a choice and migrating your reports?
Here are a few samples:
- are there any license costs involved?
- are all features that we need, supported? What are these features, that YOU need?
- are there any limits, e.g. the size of the files that can be generated?
- how can JasperReports integrated into my APEX application and secured?
- is it performant?
- is there a batch interface like rwcli?
Cheers,
Dietmar.
11 comments:
When migrating from Reports 6i, it's very important direct printing. How can we send reports direct to the printer?
Hi ranaguir,
excellent question.
The facility is generally available ( http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/sample.reference/printservice/index.html ).
Would you need that in my JasperReportsIntegration kit (https://www.opal-consulting.de/tools)?
Then you can add an enhancement request here: https://www.opal-consulting.de/forums.
Thanks,
Dietmar.
Hi,
How the connectivity performance between jasper report & Oracle db, as Oracle report have builtin connection to connect to the db. what about the Jasper report?
Hi Unknown,
sorry for the late response.
I don't see any performance issues using the thin jdbc driver instead of the oci driver with Oracle.
See here (and the further links): http://dbatips4u.blogspot.de/2010/08/tip28-thin-jdbc-vs-thick-oci-driver.html
Even Oracle recommends using the thin driver over the oci driver.
Cheers,
Dietmar.
Hello Dietmar,
We are currently looking for alternative tool to convert our existing Oracle Reports 11g to another tool.
Can you recommend any document/link with the roadmap for converting Oracle Reports to Jasper?
Thanks
Alex
syncreon automotive
Thanks for reply. Is there any tool to convert the Oracle Report to Jasper.
Hi,
no, not that I would know of.
Even PITTS (who are known for Oracle Reports analysis for migration purposes) are only targeting Oracle BI Publisher as a possible migration target.
Well, I could build a conversion tool If you would be willing to pay for that ;).
Cheers,
~Dietmar.
Hi ,
I have a project at my university and i have to list the differences between Jasper and Oracle reports , to be more specific i have to find out Jasper Reports added capabilities compared to let's say report builder in oracle, and use it to create data visualizations and reports.
Can you please help me with this topic ?
Hi Pamela,
I have not exactly researched what you are searching for ... but I have looked at the typical use cases when using Oracle Reports and how to implement that using JasperReports: https://daust.blogspot.de/2012/07/odtug-kscope12-slides-and-samples.html
Hope that helps.
Good luck,
~Dietmar.
If this thread is still alive I would like to know if its a good idea to migrate to APEX instead of jasperreports due to the limitations of latter to handle plsql code and triggers. reformatting all our reports will be too much work for us considering we have 50 odd reports with complex logic
Well, these kinds of reports will have to be rewritten anyhow ... no matter which technology you choose.
But JasperReports can handle plsql code and triggers, here is my old presentation: http://www.opal-consulting.de/downloads/presentations/2012-06-28-ODTUG-KScope12/2012-06-28-ODTUG-KScope12-jasper-reports.pdf
I could possibly give you access to the samples when you shoot me an email.
Cheers,
~Dietmar.
Post a Comment