Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
duplicate BMM Model and change the connection pool details
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
Answers
-
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 ...
0 -
Beaten by Gianni by some second
0 -
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
0 -
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...
0 -
+100 - what's worse? doing this once correctly or redoing the whole thing manually?
0 -
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
0 -
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
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...
0 -
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.
0 -
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.
0
