RE: WebFocus and Oracle Views
- From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
- To: "'niall.litchfield@xxxxxxxxx'" <niall.litchfield@xxxxxxxxx>, "Dominic.Brooks@xxxxxxxxxxxxxxxxxxx" <Dominic.Brooks@xxxxxxxxxxxxxxxxxxx>
- Date: Wed, 5 Jan 2011 10:29:13 -0500
I am not all that familiar with Webfocus other than what we all find on the web
but I agree with Niall and Dominic. Sounds like Webfocus is builds it's own
data dictionary for it's own BI interface (Remedy does this as well which I am
all too sadly familiar with). Given that it's a BI tool I wonder if he wants
the MV to get a snapshot of the data (for a look up as Dominic suggested) if
it's from a source that changes quickly like a streamSQL or CEP type of source
though the 1 minute refresh interval is a bit troubling and makes little sense,
to me at least.
Rui Amaral
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: Wednesday, January 05, 2011 9:52 AM
To: Dominic.Brooks@xxxxxxxxxxxxxxxxxxx
Cc: Richard.Goulet@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: WebFocus and Oracle Views
I passed on this snippet to Dick earlier but there's a forum thread at there's
a forum post at
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2781022281?r=365109704#365109704
that suggests very strongly that WebFocus is exactly building its own
(presumably database independent) dictionary from queries against the Oracle
Data dictionary - though the problem in the thread is the reverse of the
developer's stated position. Fortunately with reference to my earlier post, not
only am I never going to become King, I've also yet to meet a development or
reporting tool that couldn't speak SQL if really required (or at the very least
use the output of stored procedures), more usually the issue is that the
developer doesn't speak SQL.
On Wed, Jan 5, 2011 at 2:01 PM,
<Dominic.Brooks@xxxxxxxxxxxxxxxxxxx<mailto:Dominic.Brooks@xxxxxxxxxxxxxxxxxxx>>
wrote:
It might be revealing to trace what WebFocus is doing that means it can't use a
view (allegedly).
From what little documentation there is publically available, who knows what
the "SQL Translation" layer does.
But it's not impossible that it's doing some sort of lookup against something
like USER_TABLES as it "translates SQL to an internal, canonical form" and then
back to "specific SQL dialects supported by proprietary RDBMSs" - "whatever".
However, it also looks like it can operate with straight "SQL Pass through" so
maybe this would avoid any source of the problem.
But, my first reaction is that some sort of lookup is involved and that causes
the problem - find the lookup and you're at least part of the way to thinking
about ways to avoid the issue.
Cheers,
Dominic
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of Goulet, Richard
Sent: 05 January 2011 12:29
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: WebFocus and Oracle Views
Guys and Gals,
I've a WebFocus developer here who is telling mew that he cannot use a
view to query data from the database. The app developers have created and
tuned these views to the n'th degree so that they provide correct data quickly
( I have to pat these folks on the back as they really did work hard on them).
Anyway this duhveloper wants to create MV's out of them so that "WebFocus will
behave as expected" and he is absolutely adamant about it to the point that he
has not started his work because "we won't let him create his MV's". BTW: he
wants to refresh these at 1 minute intervals and they will require a full
refresh. I've searched the WEB and even talked to a couple of others that I
know who've used WebFocus and can't find anything that in any way substantiates
what this person is telling me. In a bit of frustration with him I'm turning
to the list to see if any of you have ever heard or seen anything along these
lines. All replies are appreciated. As I understand it it's WebFocus 7.0 on
Linux RH5 using an Oracle 11.1.0.7 backend database also on RH.
Thanks in advance.
Dick Goulet
Senior Oracle DBA
_______________________________________________
This e-mail may contain information that is confidential, privileged or
otherwise protected from disclosure. If you are not an intended recipient of
this e-mail, do not duplicate or redistribute it by any means. Please delete it
and any attachments and notify the sender that you have received it in error.
Unless specifically indicated, this e-mail is not an offer to buy or sell or a
solicitation to buy or sell any securities, investment products or other
financial product or service, an official confirmation of any transaction, or
an official statement of Barclays. Any views or opinions presented are solely
those of the author and do not necessarily represent those of Barclays. This
e-mail is subject to terms available at the following link:
www.barcap.com/emaildisclaimer<http://www.barcap.com/emaildisclaimer>. By
messaging with Barclays you consent to the foregoing. Barclays Capital is the
investment banking division of Barclays Bank PLC, a company registered in
England (number 1026167) with its registered office at 1 Churchill Place,
London, E14 5HP. This email may relate to or be sent from other members of the
Barclays Group.
_______________________________________________
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
NOTICE: Confidential message which may be privileged. Unauthorized
use/disclosure prohibited. If received in error, please go to www.td.com/legal
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié.
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière
d'aller au www.td.com/francais/avis_juridique pour des instructions.
Other related posts:
