Saturday, May 05, 2012

Oracle Reports to JasperReports-I need your questions

Hi guys,

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? 
What are your questions?

Cheers,
Dietmar.

7 comments:

ranaguir said...

When migrating from Reports 6i, it's very important direct printing. How can we send reports direct to the printer?

daust_de said...

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.

Unknown said...

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?

Dietmar Aust said...

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.

Unknown said...

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

Unknown said...

Thanks for reply. Is there any tool to convert the Oracle Report to Jasper.

Dietmar Aust said...

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.