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

OBIA 7964 with info 10.2 hf1

Received Response
91
Views
12
Comments
User_MSQS7
User_MSQS7 Rank 6 - Analytics Lead
in Oracle Business Intelligence Applications

Dear Experts,

I am plan to install all the below software's in the below format bcz of my current OS expiry could you please provide your suggestions.

on MS windows server 2012 r2 OS

Server1--->BI APPS 7964 & OBIEE 11.1.1.9.0 & Informatica Power Center 10.1.0 or 10.2 hf1 & DAC 11g

Server2---> MS SQL Server 2012

Server3--->OBIEE 12.2.1.4.0

OBIA7964 with Informatica 10.2 HF1 will supports with SQL Server Database?

Thanks in Adavance!!!

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    All your answers can be found in the relative certification matrix: https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

    PS: you maybe want to have a look at as you never closed a single thread so far ...

  • PhHein
    PhHein Rank 2 - Community Beginner

    MOD: moved from OBIEE

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Thank Gianni for your reply,

    Is it ok below everything installed in to one server

    Server1--->BI APPS 7964 & OBIEE 11.1.1.9.0 & Informatica Power Center 10.1.0 or 10.2 hf1 & DAC 11g

    will it works fine without any issues?

    Thanks,

  • Gianni Ceresa
    Gianni Ceresa Mod

    I have a feeling of "déjà vu"

    As you plan to use OBIEE 12c as front-end, your OBIEE 11g is required but will not be much used, therefore not a problem to have it on the same server as DAC & Informatica as OBIEE 11g there will be like "transparent", not adding any relevant load on the system.

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Thank you Gianni..you are correct...but part of OBIA (dual headed installation) we should install OBIEE 11.1.1.9.x and OBIEE 12C also. So I wants to reduce the no of servers installing  OBIEE 11g, DAC & Informatica in to a single machine.

    Let me know your suggestions

  • Gianni Ceresa
    Gianni Ceresa Mod

    I already wrote them above

    Let's reformulate in a different way:

    server1 = OBIEE 11g + DAC + Informatica ?

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Dear Gianni Ceresa thanks for your suggestion.

    1) server1 = OBIEE 11g + DAC + Informatica  + OBIA 7964

    2) Here I dont get it one thing. How it is related OBIEE 11g with OBIEE 12c, we are installing different servers these BI software's. OBIA is on 11 g server, how obiee 12c( server2) Prebuild RPD and Reports and Dashboards can communicate with OBIA 7964(server1)

    3) If we escape obiee 11g and obia 7964 instalaltion part will it works fine ( only install Informatica & DAC(server1), OBIEE 12C(server2), DB(server3)

    Thanks for your patience to answer

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

    OBIA comes with OBIEE 11g which is outdated and the reason why most customers run OBIEE12c on the side in order to have a modern system.

    "OBIEE" per se doesn't come with any prebuilt dashboards and analyses - not "reports"; "reports" is BI Publisher, a different technology. OBIA comes with prebuilt content which you would then migrate over to OBIEE 12c. Because OBIEE does not care one bit of what's uinderneath.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3808468 wrote:OBIA is on 11 g server, how obiee 12c( server2) Prebuild RPD and Reports and Dashboards can communicate with OBIA 7964(server1)

    It doesn't, because of what Christian said.

    You need to forget OBIA 7964 as a product, because it isn't a product. OBIA 7964 is not a tool.

    OBIA 7964 is "simply" a bundle package: it has a set of tools with pieces connected and pre-built content.

    As Christian said, you need to do a classical OBIEE migration from OBIEE 11g (coming by default with OBIA) to your own OBIEE 12c. This is not an OBIA task, it's purely an OBIEE job.

    OBIEE isn't connected to anything, all it needs is a RPD + a catalog. These are the 2 pieces you migrate (and security on top).

    How does OBIEE 12c connect to " OBIA " ? A database connection, the one defined in the RPD telling OBIEE where is the database storing data.

    I don't know if you job is just to do a plan and somebody else will do the install and config, but it's maybe worth to read documentation on what OBIEE is and how it works, look at some tutorials, check the migration documentation and then the same for OBIA so that you can clearly understand what tool does what and how and what are the dependencies.

    The forum can give you high level ideas, but will never teach you the details.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Gianni Ceresa wrote:I don't know if you job is just to do a plan and somebody else will do the install and config, but it's maybe worth to read documentation on what OBIEE is and how it works, look at some tutorials, check the migration documentation and then the same for OBIA so that you can clearly understand what tool does what and how and what are the dependencies.The forum can give you high level ideas, but will never teach you the details.

    I couldn't agree more.