ETL on DR site for OBIEE 11g : Please help
edited Jan 15, 2013 2:14AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hello Gurus,
I have a requirement to to setup ETL jobs on top of Active Guard for EBS DR Database. The need is the use DR DB to pull or push the data into data-warehouse tables and not on Primary Prod DB.
The Physical Standby database configured in DR with data guard replicating the data between PROD and DR using Redo Apply. This DR Site Db is not allowed for writing this is READ ONLY.
Should I create OBIEE schema (DEV_BIPLATFORM, DEV_MDS) on DR DB? Or should re use the PROD schema replicated on DR DB?
As I mentioned earlier, DR db is in standby mode with no access to read/write. Is It common practice to set up ETL for DR environment?
I have a requirement to to setup ETL jobs on top of Active Guard for EBS DR Database. The need is the use DR DB to pull or push the data into data-warehouse tables and not on Primary Prod DB.
The Physical Standby database configured in DR with data guard replicating the data between PROD and DR using Redo Apply. This DR Site Db is not allowed for writing this is READ ONLY.
Should I create OBIEE schema (DEV_BIPLATFORM, DEV_MDS) on DR DB? Or should re use the PROD schema replicated on DR DB?
As I mentioned earlier, DR db is in standby mode with no access to read/write. Is It common practice to set up ETL for DR environment?
0