OBIEE 12c Installation

Question

Hi guys,

I have a doubt when we are installing obiee, first we needs to install the oracle db then on top of we will install the obiee here my doubt is instead of installing oracle data base is it possible to install other then any db ms sql , db2 , mysql, on top of that is it possible to install obiee 12c is it possible?

Note: I know that using RPD I can connect any other DBS, my qun is different

Thanks in advance

Gianni Ceresa · Answer

As Ebin said, and as the certification matrix clearly states too: RCU schemas (BIPLATFORM and the other 6-7) are supported only on Oracle Database, SQL Server or DB2 (check the matrix or Ebin answer for details on versions).

MySQL isn't supported for the RCU schemas.

Then of course as you said you can use many other databases as sources in the RPD for your analysis etc.

Sree!!! · Answer

but it will support any kind of DB's or it's support only oracle db, because when we will install obiee it will create Dev_biplatform and dev_mds schemas in oracle db's. So when point other dbs ms sql, mysql,db2 those schema will get insert in to these db's

Gianni Ceresa · Answer

Hi,

You got the answer from the 2 replies above, both pointing you to the certification matrix and listing you the possible supported DB.

Just a detail:

Sree!!! wrote:... first we needs to install the oracle db then on top of we will install the obiee...

It's not really "on top", in general the DB is in another server because it's the normal DB you already have (for example where your darawarehouse is located).

Installing DB and OBIEE in the same environment is mainly a quick test or a POC but not really more common than that (also because installing a DB just to host the RCU schemas ... it's a lot of work for what it is ...).