Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Can Design Manager reuse some of the Oracle users/schemas created for CLM?

Questions
Tags
Users
Badges
paulo lacerda
JAZZ DEVELOPER (33●1●14●14) Oct 10 '12, 2:50 p.m.
Hello,

I'm will have only one oracle database for all CLM applications, including DM, can Design Manager reuse oracle users created for CLM (JTS and DW) instead of creating separated users as described in the installation procedure? If yes, I would only create DMUSER and VVCUSER users.

Reference: http://pic.dhe.ibm.com/infocenter/rdmhelp/v4/topic/com.ibm.rcam.install.doc/topics/t_database_setup_oracle.html

Thank you,
 Paulo

0 votes

1 answer
6,254 views
0 votes

Accepted answer

Permanent link
Alex Fitzpatrick
JAZZ DEVELOPER (558●3●8●16) Oct 10 '12, 3:21 p.m.
 I just verified this with development.

While you can share the oracle user between the databases, each application will need its own database / tablespace because there is some overlap in the schemas due to common storage frameworks.
paulo lacerda selected this answer as the correct answer

0 votes

Comments
paulo lacerda
JAZZ DEVELOPER Oct 10 '12, 4:34 p.m.
Thanks Alex, Even the DW has to be separated from the CLM DW? Regards, Paulo

Alex Fitzpatrick
JAZZ DEVELOPER Oct 11 '12, 10:35 a.m.
This FAQ suggests that all of CLM can share a data warehouse. I think that is also true for DM. I will try to confirm this. Confirmed, you only need one DB for a data warehouse. From development: DM does not use the data warehouse, we do not have any ETL jobs to push data into the warehouse so RRDI is not supported. As for CLM applications, there is one data warehouse and all 3 applications have ETL jobs to push their data into that warehouse. The RRDI extracts it data from that warehouse. 

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,624
× 2,383

Question asked: Oct 10 '12, 2:50 p.m.

Question was seen: 6,254 times

Last updated: Oct 11 '12, 10:35 a.m.

Confirmation Cancel Confirm