Categories
OBIEE 12c Installation

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
Answers
-
Hi Sree,
Checkout the certification matrix to find the supported databases. For OBIEE 12.2.1.1.0, supported DB's are Oracle DB 12.2.0.1+; 12.1.0.1+; 11.2.0.4+, IBM DB2 10.5, Microsoft SQL Server 2012, 2014.
0 -
Hi , you can use other supported database that you can check from certification matrix. You don't need only oracle db.
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html
Also you can find lots of information about installation from doc.
0 -
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 ...).
0 -
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
0 -
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.
0