Data warehouse

[Hans Forbrich]

Daniela Giovenzana wrote:
We need to install a data warehouse on a windows server. The packages we have to buy are: Database: Oracle 9.0.1.2 or next Enterprise Edition.

- definitely next ... 9.2
Application Server: Oracle9iAS 1.0.2.2 or next.

- definitely recommend the 'next' & I understand the 9.0.4 is coming out very
soon.
- optional but highly recommended for the access utilities (Discoverer,
Reports, cache, integration from source, etc.)
Oracle Enterprise Manager: OEM 9.0.1.

Included with the database AND application server license - use the highest
number you find.
Oracle Workflow: Oracle Workflow server: 2.6.1/2.6.2 (2.6.2 is better) and Workflow client: 2.6.1

- Included with the database and with the application server license
- 2.6.2 = 2.6.1 + event handling.
Warehouse Builder: Release 9.03

Part of Oracle Developer Suite (also used to develop the reports and
administer the Discoverer stuff that's part of 9iAS. So get the latest
Developer Suite.

HTH
/Hans

[Hans Forbrich]

Ryan wrote:
so the developer suite and the 9iAS license is bundled now? i thought i

No. (And I don't think I stated/implied that in the post either ...)

Suggest you look at OTN where it is fully described.

In a nutshell

- Developer Suite includes ALL the tool set, including JDeveloper, Forms
Developer, Reports Developer, Warehouse Builder, etc. etc. etc.;
- Application Server provides the infrastructure for full scale deployment of
stuff developed using Developer Suite (as well as other stuff);

heard somewhere you can get jdeveloper and deploy it without having to buy 9iAS? it was some kind of special? is that still around?

I think it's still around. If it is, it's on OTN.

Remember, there is a license with all of this stuff. Even the "free"
version. Ands that governs the use and deployment.

(But most of us don't bother to read licenses. Why bother? It's even more
useless than documentation, right? Right up there with READMEs. Our time is
far better spent searching for undocumented stuff.)