This discussion is archived
2 Replies Latest reply: Dec 1, 2012 11:11 AM by AhsanShah RSS

OBIA Database creation question

EBSDBA Expert
Currently Being Moderated
Hi,
I am installing BI Apps 7.9.6.3 on Linux.

I have the following question.

I know that, i have to create a database instance for

•DAC Repository

•Informatica Domain

•Informatica Repository

•Oracle Business Analytics Warehouse

As per your experience please share if creating one db to hold all the above four is good or should i create a separate database for "Oracle Business Analytics Warehouse" ?.

Thanks


Thanks
  • 1. Re: OBIA Database creation question
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Its better to have separate databases for each.

    Check this doc for more help
    http://docs.oracle.com/cd/E20490_01/bia.7963/e19038/toc.htm

    Appreciate if you mark as correct/helpful
  • 2. Re: OBIA Database creation question
    AhsanShah Expert
    Currently Being Moderated
    There is no set rule...and you dont need separate "instances" for each..just schemas. the DAC/INFA metadata is fairly small so you can put them together if you want but OBAW is usually created in its own separate instance since the maintenance may be different. It really is a question for your DBA team. Suppose you need higher availability for certain instances, or if there is maintenance windows where you need the OBAW DB separate from INFA..or if you are using the INFA rep for populating other systems, you may not want to group it with OBAW. These are some things to consider.

    Pls mark helpful or correct

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points