Pennant has developed a new Ad Hoc tool for OmegaPS to replace Oracle’s Business Intelligence query tool Discoverer. As many of our customers know, Discoverer is no longer available with the 11g WebLogic/Forms and Reports application software. The tool is called OmegaPS Data Query.

The new solution developed in Oracle’s APEX Data Reporter (comes with the database license), and uses ORDS (Oracle REST Data Services) and GlassFish. All three of these are free from Oracle. If you already have an existing 11g installation, you will be able to install the Ad Hoc solution separately.

To launch the tool, customers will use a link from within OmegaPS.
For clients with business with the Canadian Department of National Defence, there is a second Ad Hoc Query tool available called OmegaPS DND Data Reporter. This tool comes pre-loaded with standard reports DND has defind for Acquisition projects.
Customers wishing to use these add-on query tools will require a license from Pennant.