Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE, OBIA, INfo, Dac, sql server on 2014

Received Response
34
Views
14
Comments
User_MSQS7
User_MSQS7 Rank 6 - Analytics Lead
in Oracle Business Intelligence Applications

Dear Experts,

Planning this setup on windows server 2012 r2, same setup will be work for windows server 2016 ?
================================== 
Informatica Power Center 10.1.0 with  DAC 11g  MS SQL Server 2012
OBIEE 12.2.1.4.0
OBIEE 11.1.1.9.0 with  BI APPS 7964

=======================================

Please send your suggestion,

Thanks in advance

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    The answer is here: https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

    Look at the certification matrix for both BI Apps 7.9.6.4 and OBIEE 12c 12.2.1.4 (as they are separate products).

    If both are certified for Windows Server 2016 you will be good, if one of the 2 isn't certified I wouldn't do it as you will end up with an unsupported system (if it works and you manage to install).

    Making it short: BI Apps 7.9.6.4 certification matrix doesn't mention Windows 2016, it stops at 2012, therefore it doesn't seem to be supported (didn't read small notes to see if there is something there inside).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    . Adding to what Gianni said - OBIA 7.9.6.4 is old and won't ever be certified for Windows 2016. It wasn't out when 7.9.6.4 came out and since OBIA has moved on in the meantime...that's software cycles for you. Outdated things don't get validated and certified without end.

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Thanks for your reply @ Gianni ceresa!!!

    I am new to admin part..

    I am planning on dual headed installation, i have seen certifications

    OBIEE 11.1.1.9.x with OBIA 7964 supports 2012

    OBIEE 12.2.1.4.0 supports                          2012, 2016-----? if I go with 2016 will it supports for this apps and database

    informatica and DAC supports                     2012

    ms sql server supports                                2012, 2014----? if I go with 2014 will it supports for ETL, DAC and OBIEE

    here I am picking the latest versions of Operating systems from each, will it work without any issues ?

    Thanks!!!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3808468 wrote:OBIEE 12.2.1.4.0 supports 2012, 2016-----? if I go with 2016 will it supports for this apps and database

    If you only run OBIEE 12.2.1.4 on Win 2016 you will be fine. OBIEE doesn't care where the data comes from.

    3808468 wrote:ms sql server supports 2012, 2014----? if I go with 2014 will it supports for ETL, DAC and OBIEE

    Are you talking about MS SQL Server 2014 running on Win 2012? Or MSSQL 2012 on Win 2012? Or MSSQL 2012 on Win 2016?

    MS SQL doesn't care where the data goes to.

    Your problem is the "OBIA" part. So the ODI and DAC part "on the middle". Not the database. Not OBIEE.

    Put MS SQL Server 2014 on Windows 2016 and OBIEE on Win 2016. Put "OBIA" on Win 2012.

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Thanks for the update Christian Berg!!!

    This is the below circle you have given. As per your experience what is the best way, installing all the software's on the same platform like  windows 2012 r2 or going below is the best option ?

    1) MS SQL Server 2014 on Windows 2016

    2) OBIEE 12.2.1.4 is on Win 2016

    3) Informatica & DAC is on Windows 2012 r2

    4) OBIA and OBIEE 11.1.1.9.x on Win 2012 r2

    Thanks !!!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Uhhh what is point number 4?!

    OBIA is your number 2 plus your number 3. Not sure what your fourth option is supposed to be.

  • Gianni Ceresa
    Gianni Ceresa Mod

    To add extra wording to Christian reply:

    OBIA is Informatica + DAC + OBIEE 11g + the warehouse

    You have your warehouse in your MS SQL Server, good.

    So the "rest" of OBIA (Informatica + DAC + OBIEE 11g) can be all together in the same place, mainly because that OBIEE 11g will not receive requests as your users will be using your OBIEE 12c.

    So get rid of 4) as that's into 3).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Thanks for the additional words Gianni ;-)

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Dear Christian,

    Following this OBIA 796: Support of BI Applications 7.9.6.3 & 7.9.6.4 with OBIEE 12.2.1(12C) (  Doc ID 2087632.1  )

    Dual headed installation.

    When I was spoke with the oracle support they were mentioned this setup compared to previous setup here we required 1 machine extra

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Thanks for your reply Gianni Ceresa!!

    When I was spoke with the oracle support they were mentioned below setup

    a) 4 machines required

    =============================================

    1) MS SQL Server 2014 on Windows 2012r2

    2) OBIEE 12.2.1.4 is on Win 2016

    3) Informatica & DAC is on Windows 2012 r2

    4) OBIA and OBIEE 11.1.1.9.x on Win 2012 r2

    ==================================================

    As per your comments we can install complete setup  (Informatica, DAC, OBIA(HR analytis) & OBIEE 11.1.1.9.x) on one machine. Looks good.

    will it work out without any issues & the complete setup is on same machine will it required more RAM size.

    I noted below point from your comment : OBIEE 11g will not receive requests as your users will be using your OBIEE 12c

    b) 3 machines required

    =======================================================

    1) MS SQL Server 2014 on Windows 2012r2

    2) OBIEE 12.2.1.4 is on Win 2016

    3) Informatica, DAC, OBIA(HR analytis) & OBIEE 11.1.1.9.x on Win 2012 r2

    Thanks!!!