Connect the existing Subject Area to a new DB

Karthi_obiee

We have a OBIEE Subject Area connected to an oracle database named OLD_DB.

And there are few standard and adhoc reports which are built based on this subject area.

Now, a new database NEW_DB is built which is similar to OLD_DB with few more additional tables and columns. 

How can I connect the existing subject area with the new NEW_DB and run the existing standard and adhoc reports.

Please suggest.

Thanks!

[Deleted User]

OBI Jeopardy: What's the purpose and use of the wizard behind Tools -> Options -> Replace Column or Table in Logical Table Source?

Joel

do both have the same data? By this I mean do you have subsets of data in each? The data fragmentation will determine how you can incorporate both data sources into your  repository

Karthi_obiee

Thanks Christian, for your reply.

The table names and column names are all the same in the NEW_DB compared to the OLD_DB.

We do not want to use the existing business model so we want to create a new business model with the NEW_DB and connect it to the existing subject area.

Is this possible?

Karthi_obiee

Thanks Joel, for your reply.

The OLD_DB and NEW_DB are similar in data and structure.

New tables and columns are added to the NEW_DB which consists of type II tables.

Gianni Ceresa

So you have a new DB with the same old things (names) plus new ones.

You don't want to keep using the old ones but switch all the existing to the new DB and extend the business model with the new things.

Why don't you just change the connection pool to point the existing physical objects, business model and subject area to the new DB?

From there you start adding the new pieces.

Karthi_obiee

The existing business area is not clean in design, So we want to build the BMM layer from scratch and connect it to the subject area.

Gianni Ceresa

So you want to build a new physical layer based on the new DB, build a new business model based on the new physical objects, build a new Subject Area based on the new business model.

Once done take the existing subject area and replace it with the new one, which will have the same names as the old one, plus all the new things.

Build all your new things, once the new subject area is in line (at least) with the old one, rename the old one to something else, drop the alias, rename the new subject area, drop the alias. Done!

Karthi_obiee

Thanks Gianni.

I will work on the solution provided.