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.
7 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.
Post a Comment