PITSS Tech Blog

News about APEX, Java, PL/SQL, Development & Technology

Q&A – Boost your Oracle Reports2Jasper Reports [webcast]

“For 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. ” (Customer)

“With 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)

The high interest in last week’s #LiveMigration Oracle Reports to Jasper Reports confirmed the huge significance in the topic. About #100 attendees and their interesting questions about the nearing end of support of Oracle Reports and the great future of Jasper Reports inspired this event.
See some FAQs from this webcast, which will help you on the way to your replacement project of Oracle Reports.

Your most important questions about a Oracle Reports to JasperReports migration

What about our Oracle Reports that we are executing in batch files? Do we have the same functionality with Jasper Reports?

Yes – you could run Jasper also from command line 

What are the componants required to convert from oracle to Jasper? (server, license, cost, integration time frame, etc....)?
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
Could you connect more than one database to one report?
Yes!
How does Jasper handle dashboards?
How long does it take for an Reports developer to become competent with Jasper?
I take a 5 day training and I’m 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’s importent to train on the job and start with the easy once
How to connect with oracle database before migration?
Use setup database connections via JDBC
Are there any Oracle Reports features that the conversion tool has difficulty converting? Such as conditional formatting, Graphs, etc?
We don’t cover matrix reports by now (matter of not realy used by the customers so far) we adive to redo graphics, because they are cool in Jasper and fast to setup
Is it possible to send a Jasper report directly to a specified printer ?
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.
We call and use a lot of database functions, can they be called and used in Jasper?
Yes – in the Query and within the scriplets.
Does Oracle Apex have a report development tool? Can it create complicated reports like Oracle Reports and Jasper?
There is no APEX internal reporting tool available. You could use the export functionalities of Interactive Grids. Oracle tend to integrate AOP – we are also work on migration to this approach.
Is the development tool for the Pro and Community versions the same? Does it have the same functionality?
If you cover the functionalities from Oracle Reports the „basics“ 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
Can Jasper reports be called from Oracle Forms? We need to embed Jasper or whatever reporting tool we use into our application.
Stephan made it sound like BI Publisher doesn't have a true development tool like Jasper and Oracle Reports. Is this true?
Bi Publisher has development tool but is very difficult to use and is not like the Jasper Tool eniviroment like you will see in the DEMO at the end
So, beside Oracle Application server also a Jasper Server is needed?
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.
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?
there are different downloads. there is a community edition and a pro edition. You click the pro-version
How can i get this too? and your offers?
How the reports can be integrated into our current Banner CIS system and how we can create a Jaspersof dashboard to run the reports
Character based printing (invoices, pay checks)
Is there a way of automatic conversion?
What about licensing to jasper reports? What about BI publisher/OAC and another open source reports options?

The next recommended step is to take the Free Migration Quickcheck to see your Oracle Reports being migrated to Jasper Reports.

Any question left?

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.