Re: question on data warehouse tools by oracle

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Wed, 30 Oct 2002 05:48:29 -0800
Message-ID: <F001.004F7453.20021030054829@fatcity.com>

It's nice to recommend but since you do not seems to really know the Oracle product how will you convince the managers to spend at least in the six figures (US money) ?
Do you have any criterias ?

Just to choose a reporting tool we had over 40 criterias that each companies had to to answer and that was to get on the short list.

Oracle 9i, the partitionning option is needed in almost all DW (I do know clients doing data mining) Oracle Warehouse builder is the ETL and its in the developper suite
Oracle 9i Reports
Oracle 9i AS (that includes Oracle Portal I think) Discoverer will be needed
Oracle Designer to design and manage all the deliverables

Also, you might use Advanced queuing to organize the different jobs, the OEM pack can also help depending on the DBA.

I do not remember if discoverer is bundled with the 9iAS.

Last year I was in a biotech company that had that setup : all Oracle. Also, they had bought CDM, the Oracle meyhodology. Big big bucks !!!

• Rahul <rahul_at_ratelindo.co.id> a écrit : > list,
  > i'm in the process of recommending Oracle as a
  > "completel solution" for a
  > ;large
  > data warehouse (for a central bank) . After doing
  > thru some of the
  > documentation on OTN ..i have the following info
  > on the products i would need. Please comment if i'm
  > missing something
  >
  > - 9i database (with data mining option ?? wil this
  > help ?)
  > - Oracle warehouse builder (is this the GUI to
  > develope the ETL procedures
  > etc ???)
  > - Oracle 9i reports
  > - 9i App server( portal, reports server) to deploy
  > and distribute the
  > reports
  > - discoverer( required ?? )
  >
  >
  > (..do i realy require the following....??? )
  >
  > - OLAP
  > - express server / analyzer
  >
  > TIA
  > Rahul
  >
  >
  >
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Rahul
  > INET: rahul_at_ratelindo.co.id
  >
  > Fat City Network Services -- 858-538-5051
  > http://www.fatcity.com
  > San Diego, California -- Mailing list and web
  > hosting services
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com

---

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 30 2002 - 07:48:29 CST