Contact us at +1.415.901.7500 or

Oracle Discoverer: It’s Time to Move On QA Session

Oracle Discoverer: It’s Time to Move On QA Session

A couple of weeks ago we had our webcast on CloudIo: “Oracle Discoverer: It’s Time to Move On” and we had more questions than we had time to answer live. Today we bring you the Q&A session transcript from the hands of CloudIO’s CEO and Founfer Sreenivas Thammaneni. If you missed the webcast and would like to download a copy of the recording including a live demo, click here.

Does CloudIO work on 11i and what’s the impact on upgrading to R12 or future releases?

Yes, the platform can work on all EBS releases, starting from 11i to the latest R12.2.4 release.  The entire configuration is outside of Oracle EBS so it doesn’t impact the upgrade of Oracle and we don’t touch Oracle’s standard APIs.

Is it connected directly to the EBS application database to run the report underlying queries?

Yes, it is. There are two options. All these reports are real time against Oracle EBS. If you’re logged in as an administrator, you can actually see the query, so if you go to Recent SQL you can see the exact query. It’s very developer-friendly, so you can just copy this and use it in a developer tool if you want to troubleshoot.

At the same time we do have a Cash-in feature, where you can ASK to yield the query based on a schedule you set, it can be hourly, every 6 hours, monthly etc. It will perform the query and store the data in the cash. This way all the summary information can be scheduled so that when the user accesses it, it’s much faster. Queries that would take minutes take milliseconds with this feature.

Can you provide some insight on the high level architecture?

At a high level, it’s a standard J2EE application, so it can be deployed on top on any J2EE container like Tomcat, Weblogic, JBoss, any Java container. And it can reside on the same … as Oracle middle tier. In terms of technical components, CloudIO is built 100% using Java and Google web toolkit. There isn’t any proprietary technology used, it’s all open standards and it supports any modern browser.

How fast is it to migrate discoverer BA into CloudIO?

It can be as fast as 5 minutes to maybe a few hours; it depends on how complex the reports are. If we’re talking about reports with multiple sheets, in Discoverer there’s an option to export in XML, so the time to create the report is much less than uploading the XML, it’s pretty fast. Once you have the reports, you can open de CloudIO designer and on the left side you’ll have the complements and in the middle the properties and it’s extremely easy to make changes, rearrange views, edit the layout, etc.

How does the licensing work?

We sell enterprise licenses, so it’s unlimited on users and unlimited on servers.  It can be deployed in any number of servers and accessed by a number of users. The architecture is highly scalable, so you can add server to increase the number of users. One single server, let’s say one Tomcat, will support approximately 2,000 users.

Can Discoverer report templates be imported to CloudIO or will there be a need to rebuild the templates?  Will we be able to utilize the custom views currently used on Discoverer reports?

Yes, there is an option to export the Discoverer template as an XML and import it to the Reporting WorkCenter. There is also another option where you can migrate the Discoverer reports directly by selecting the reports. These are all database views, so we could generate reports from those views.

How’s the End User Layer migrated from Discoverer? Or what’s the data model needed?

We have our own data model for reports, so you don’t have to worry about migrating the data model. Since this is going on top of Oracle EBS, you only have to migrate the end user layer.

Can you avoid end users from changing reports? Can they save their own version?

Yes, end users first of all don’t have the right-click option to go to customize page to alter the reports, they can only customize the views they can see, and even this can be disabled. It’s 100% configurable. As a Super User, Admin or Developer you can have total control over your reports.

Why CloudiO over OBIEE/OBIA?

It’s basically a matter of price and ease of use.

My users do heavy building of ad-hoc reporting on top of Discoverer reports (for example – adding new parameters) what will be the process here?

CloudIO Designer is 100% browser based and all the reports built on CloudIO are 100% metadata driven. Users with little training can customize the reports from within the Browser.

Are the licenses limited to CPUs?

No.  Current licensing is based on Enterprise level, unlimited users.

Does the Discoverer XML import work 100% in regards to formatting, subtotals etc.?

The import would bring in most of the formatting and it’s very easy to do any additional formatting if need be. In the process the report will be more interactive and modern looking on CloudIO.

Don’t’ forget to register for our next webcast on surviving open enrollment season: “Open Enrollment 2016: Invest Now or Pay Later?” on July 16th. Reserve your spot here.