Re: A GUI Interface to the database?
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: Job Miller <jobmiller@xxxxxxxxx>
- Date: Fri, 3 Dec 2010 22:44:35 -0500
The problem is that Oracle's BI EE product has very heavy technology stack ... app server, ?BI? server, client software, et cetera ad endless nauseam. All the user community really needs/wants is a query by example interface to their data. The IT support team wants the cleanest, most reliable (read easiest) web enabled application we can persuade the customer to adopt. <SIGH /> V/R, Gus On Fri, Dec 3, 2010 at 8:25 PM, Job Miller <jobmiller@xxxxxxxxx> wrote: > > Brio and Interactive Reporting have been replaced by Oracle's BI EE product > from the siebel acquisition from Oracle's perspective. > > OBI EE uses a BI Server to federate to multiple data sources yet create a > single ODBC data source that all the front end tools (dashboards, ad-hoc, > pixel perfect reports, etc..) use to access the disparate back end sources. > it has custom functionality available it to based on the capabilities of > the source system it is connected to. > > visually attractive tool, but definitely includes licensing costs. > > Job > ------------------------------ > *From:* Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> > *To:* Richard.Goulet@xxxxxxxxxxx > *Cc:* gus.spier@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx> > *Sent:* Thu, December 2, 2010 11:58:59 AM > *Subject:* Re: A GUI Interface to the database? > > Hyperion is very good, however it has the downside of Essbase... as > databases go it's far from my favorite... granted, I'm strictly an RDBMS > guy, so multidimensional databases are strange to me, but Essbase's > recoverability is dodgy at best, backups require downtine... it's not fun. > On the other hand, you can always rebuild an essbase database from a DWH, > so... that's that problem solved :-P > > Personally, for graphical interface with the database, and reporting > wizards and that stuff, I use APEX... it took me a while to learn its tricks > (OBE and Oracle Forums were a big help there) but in the end, it's versatile > and you don't need a lot of skill to get a simple report up and running and > have users modify it to their will. > > So, it would take some custom development, but you could have a really > cheap tool if you go with Apex... whereas Hyperion has... well.. Oracle > Licensing... > > Alsto, it's been a while since I used Oracle Apps, but perhaps Discoverer, > Siebel or EBS could also work. It depends on what you need. > > Cheers. > Alan.- > > > On Thu, Dec 2, 2010 at 1:14 PM, Goulet, Richard < > Richard.Goulet@xxxxxxxxxxx> wrote: > >> Brio, boy do I ever remember that tool. My recommendation would be to >> investigate Hyperion as a replacement. Previous employer that's what we >> did. >> >> >> Dick Goulet >> Senior Oracle DBA >> >> >> ------------------------------ >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Gus Spier >> *Sent:* Wednesday, December 01, 2010 8:39 PM >> *To:* oracle-l >> *Subject:* A GUI Interface to the database? >> >> I have inherited an entrenched user community that has become accustomed >> to interfacing with the database through an application called "Brio". Brio >> has long since become unsupported and really needs to be replaced. >> >> So, I'm asking around for recommendations from the List for a >> query-by-example graphical user interface that I can persuade the user >> community to adopt. >> >> Any recommendation would be appreciated. >> >> Regards, >> Gus >> > > >