Very Computer

Quote:(Chris McClellan) writes:
>OSA must use Express as the database engine.  As an alternative, you
could
>create Express programs which load the data via ODBC, but it
would be much
>better if you used the dataloader routines.  

Chris

Quote:>McClellan

I thought that OSA 1.5.2.x could utilize the Relational Access Manager to
access data from an ODBC source, providing it was in a star/snowflake schema.

Cheers,
Paul Dean
Director
Express Implementation Services
Braun Technology Group
612-915-4685
Cheers,
Paul Dean

        Remember me from Waltham, April ?  Anyway, yes, the data cen
be STORED in a relational (datawarehouse) database, but OSA always
needs Express.  In this case, Express generates the SQL statements to
retrieve the data into a read-only OSA database.

Hope this helps,

Chris McClellan
Oracle Corporation
OLAP Education

One of my colleagues in Switzerland has used RAM/RAA with OSA to access data
stored in an oracle RDBMS. *NO* data (ie numbers) was stored permanently in
the Express environment. (Though the Express engine is still needed for the
middle tier of the architecture).

Apparently user performance was good. Obviously OSA build times were
negligible as only the structures/hierarchies were needed in Express

Mark Gee
Secor Consulting (BI & OLAP)

www.secor.com/uk
+44(0) 181 942 0252

Quote:>(Chris McClellan) writes:

>>OSA must use Express as the database engine.  As an alternative, you
>could
>>create Express programs which load the data via ODBC, but it
>would be much
>>better if you used the dataloader routines.

>Hope this helps....

>Chris
>>McClellan
>Oracle Corporation (Australia)
>OLAP Education

>I thought that OSA 1.5.2.x could utilize the Relational Access Manager to
>access data from an ODBC source, providing it was in a star/snowflake
schema.

>Cheers,
>Paul Dean
>Director
>Express Implementation Services
>Braun Technology Group
>612-915-4685
>Cheers,
>Paul Dean

Even if you store your data in a relational database, there is still an
Express Server component of OSA.  You can't run OSA without Express Server.
 I thought that was the question being asked.

Chris Futia,
Nabisco, Inc.