nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

duplicate BMM Model and change the connection pool details

Vinay Karnam

I have test connection pool and respective tables and also having BMM Model and Presentation SA, I got a new requirement saying I need to duplicate BMM model and point to another Connection Pool. In detail for example :

Connection Pool 1) having test db configuration details and Test Model in BMM

need to copy the TEST Physical Schema and BMM model to Archive Model and connection pool should be point to Archival DB instead TEST DB

Please advise

PHYSICAL SCHEMA : BMM Model

Test Test Model

Archive Archive Model

Note: Tables and structure are same in both physical schema ONLY CONNECTION STRING IS DIFFERENT.

Thanks in advance

Cheers

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Right click on the BMM > "Duplicate with Subject Area", right click on the physical DB > "Duplicate". Change the connection pool settings. Change the links between BMM LTS and physical tables by using the Tools > Utilities > "Replace Column or Table in Logical Table Source" utility.

Done ...

[Deleted User]

Beaten by Gianni by some second

Vinay Karnam

Thanks Giani, but my BMM Model is huge and having 100's of tables I can't do one by one table.. Please help any alternative..

I have done duplicating the BMM Model, chosen "Required Fully qualified domain in Physical layer" in connection pool and

--> in BMM Layer -- > Query repository tool --> Physical Model --> Show Parent and Finally if I edit the parent DB name then its creating another duplicating Physical DB not allowing to modify the existing DB name.

Thanks

Gianni Ceresa

vinay.lakshmi wrote:but my BMM Model is huge and having 100's of tables I can't do one by one table..

You can, you definitely can do one table at a time, you just don't want, that's different ...

The one above is the supported way of doing what you ask for.

It's a one shot thing, you do it once and it's done, it will take you 1h but it will be done and in the right way...

[Deleted User]

+100 - what's worse? doing this once correctly or redoing the whole thing manually?

Vinay Karnam

Still no luck.. it's been taking one table at single time. Therefore its difficult to do the same exercise for other tables. since there is a lot of tables are there in BMM

Vinay Karnam

can you please explain step by step how to do bulk change in a single shot. I have total 300+ tables in Physical Table. Many thanks for your help

@Gianni

You can, you definitely can do one table at a time, you just don't want, that's different ...

The one above is the supported way of doing what you ask for.

It's a one shot thing, you do it once and it's done, it will take you 1h but it will be done and in the right way...

Gianni Ceresa

The "one shot thing" is the duplication: you aren't going to duplicate your model every week, you duplicate it once and it's done. So spending 1h to do the job isn't too much or impossible.

asim cholas

Hello Vinay,

Why cant you try a dynamic physical connection pool, So that you dont need to duplicate anything , and make it switch according to the user login.