dbTalk Databases Forums  

Microstrategy Edition for Oracle and SQL server

comp.databases.olap comp.databases.olap


Discuss Microstrategy Edition for Oracle and SQL server in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jin Yan
 
Posts: n/a

Default Microstrategy Edition for Oracle and SQL server - 08-19-2003 , 07:19 AM






Hello all,

We have Microstrategy with SQL server now, we are thinking about put
in some Oracle at back end, is that true that Oracle need
Mircostrategy Enterprise Edition vs. SQL server working with
Microstrategy Standred Edition. Here you talk about Microstrategy
Standred Edition is half the price of Enterprise Edition.

Any one has information on it?

Thanks.

Reply With Quote
  #2  
Old   
Niko
 
Posts: n/a

Default Re: Microstrategy Edition for Oracle and SQL server - 08-21-2003 , 11:00 PM






Not sure if this is right. Microstrategy Standard Edition can talk to
SQL Server or Oracle, there maybe optimizations in the enterprise
edition that you cannot leverage. In addition Oracle on Windows and
Oracle on Unix are not like DB2 which can be a different codebase.
Either way you can connect using the same ODBC driver, merant(supplied
with mstr) or oracle's own.

I just checked with a license key that I think is non-enterprise and
had no troubles.

"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote

Quote:
MicroStrategy standard edition limits the relational database to running
only on Windows. So you can use Oracle as a back-end, but only on Windows,
not Unix.

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

In news:2d6b1484.0308190419.7bb194a5 (AT) posting (DOT) google.com,
Jin Yan <yan3_2001 (AT) yahoo (DOT) com> wrote:
Hello all,

We have Microstrategy with SQL server now, we are thinking about put
in some Oracle at back end, is that true that Oracle need
Mircostrategy Enterprise Edition vs. SQL server working with
Microstrategy Standred Edition. Here you talk about Microstrategy
Standred Edition is half the price of Enterprise Edition.

Any one has information on it?

Thanks.

Reply With Quote
  #3  
Old   
Niko
 
Posts: n/a

Default Re: Microstrategy Edition for Oracle and SQL server - 08-22-2003 , 11:40 AM



You're right about the DB2, it was just a simple example and I meant
MVS, I've been through the pain of porting from a Windows dev to MVS -
frustrating, it was easier to port to Oracle in the end.

I'm going to follow this up a little more and ask some firends how
they expect to enforce it and why should they add another complication
to there licensing. The fact is I will soon be able to build a 64-bit
Windows server using 16 high-end intel or AMD chips which will outpace
many unix boxes, it could even be a 32-bit machine in some
circumstances.

"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote

Quote:
It may just be a licensing restriction that cannot be enforced by the
software.

Incidentally, I think that DB2 UDB on Windows and Unix do have the same
codebase. It started out as OS/2 Database Manager that was all-new and later
ported to NT and Unix. It's the OS/400 and MVS versions that are actually
different (older) products that just happen to share the same name.

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

"Niko" <nick_wakefield (AT) hotmail (DOT) com> wrote in message
news:9da94cd1.0308212000.ade7d5e (AT) posting (DOT) google.com
Not sure if this is right. Microstrategy Standard Edition can talk to
SQL Server or Oracle, there maybe optimizations in the enterprise
edition that you cannot leverage. In addition Oracle on Windows and
Oracle on Unix are not like DB2 which can be a different codebase.
Either way you can connect using the same ODBC driver, merant(supplied
with mstr) or oracle's own.

I just checked with a license key that I think is non-enterprise and
had no troubles.

"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote in message
news:<1061297342.63291.0 (AT) eunomia (DOT) uk.clara.net>...
MicroStrategy standard edition limits the relational database to
running only on Windows. So you can use Oracle as a back-end, but
only on Windows, not Unix.

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

In news:2d6b1484.0308190419.7bb194a5 (AT) posting (DOT) google.com,
Jin Yan <yan3_2001 (AT) yahoo (DOT) com> wrote:
Hello all,

We have Microstrategy with SQL server now, we are thinking about put
in some Oracle at back end, is that true that Oracle need
Mircostrategy Enterprise Edition vs. SQL server working with
Microstrategy Standred Edition. Here you talk about Microstrategy
Standred Edition is half the price of Enterprise Edition.

Any one has information on it?

Thanks.

Reply With Quote
  #4  
Old   
Jeremy Rickard
 
Posts: n/a

Default Re: Microstrategy Edition for Oracle and SQL server - 09-21-2003 , 06:54 PM



"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote


Quote:
Incidentally, I think that DB2 UDB on Windows and Unix do have the same
codebase. It started out as OS/2 Database Manager that was all-new and later
ported to NT and Unix. It's the OS/400 and MVS versions that are actually
different (older) products that just happen to share the same name.
DB2 UDB originated from a merge of two products - DB2 Common Server
and DB2 Parallel Edition. DB2 Common Server was (as its name
suggested) the first common code base edition of DB2.

Currently DB2 UDB (v8) runs with the same code base on Windows, Linux
and UNIX platforms. v7.2 was the last to support OS/2.

So yes, DB2 does have a common code base - on non-mainframe platforms.


Jeremy Rickard


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.