Re: Analysis Services on top of an Oracle DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi,

As far as I know there is now difference in writing back to for example
a ms access database or sql server database. This should be the same
for Oracle.

We have great experience with a DWH in Oracle and OLAP cubes in MS
Analysis Services 2000 + Panorama NovaView as webbased frontend for the
OLAP cubes.

Regards, Marco
www.gmsbv.nl


Joerg Narr schreef:
> I forgot... is the support of Oracle in AS 2005 better? Or am i forced to
> use SQL Srvr relational with it?
>
> "Joerg Narr" <joerg_narr@xxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:42b958d9$0$16325$9b622d9e@xxxxxxxxxxxxxxxxxx
> > Hi there,
> >
> > can anyone tell me if Microsoft Analysis Services is as good on top of an
> > Oracle DB as it is on top of Microsoft SQL Server? I am especially
> > interested if it is possible to write-back data into Oracle - I couldn't
> > get it working and assume that it is not possible. I am also particularly
> > interested in any problems you ran in your mixed projects.
> >
> > Please don't send me advice of the kind "use SQL Server relational" or
> > information on any *excellent* front end.
> >
> > Thank you a lot.
> >
> > Kind regards,
> >
> > Joerg
> >

.



Relevant Pages

  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... tried opening the SQL Server database, I use the SQLOLEDB.1 provider. ...
    (microsoft.public.vb.general.discussion)
  • Analysis Services on top of an Oracle DB
    ... Oracle DB as it is on top of Microsoft SQL Server? ... Kind regards, ...
    (microsoft.public.sqlserver.olap)
  • Re: Distributed Transaction
    ... I have one SQL Server database and one oracle database.... ... Under this scenario I would use two separate transactions, one for SQL Server and one for Oracle. ... second operation fails, e.g. Oracle, then you would rollback the SQL Server transaction. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... > tried opening the SQL Server database, ... > Here is my code to open SQL Server database: ...
    (microsoft.public.vb.general.discussion)
  • Re: Importing views from Oracle
    ... view you would only be importing the view definition, ... >to a SQL Server database. ... >from Oracle to SQL Server? ...
    (microsoft.public.sqlserver.odbc)