Re: oracle versions?

> DTS (Data Transformation Services) is in sqlserver 2000
> ----> Oracles Tool?
> - daily scheduled automatically import over odbc driver from navision 3.10
> database

Nothing, you can do this since oracle 8.1.6, if you are talking of just import raw data without transformation.

> MS Analysis Services 2000 (Olap Service) is in sqlserver 2000
> ----> Oracles Tool?
> I create some OLAP Cubes

http://www.oracle.com/ip/index.html?olap_intro.html

OLAP Option of Orale 9i release 2 EE.

>
> on the client side I use the Pivot Table Service (is in Office XP
> ----> Oracles Tool?
> this need my users to wiork with the different cubes

Maybe Discoverer 9i would fit your needs, but you can use third parties software.
Anyway Oracle Magazin of July/August has an article about olap with oracle9i; here is the link

http://otn.oracle.com/oramag/oracle/02-jul/o42bi_cover.html

> 2. What is included in the oracle personal edition? Difference to full
> oracle version? Can I this version also install on a windows 2000 server?

Yep...pretty different. If you want to do OLAP you have to go with Enterprise edition

http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandoptions.html

ciao. Received on Fri Sep 20 2002 - 05:29:01 CDT