It's all about the answers!

Ask a question

Does Common Reporting in RTC require a DB (beta?)


Erin O'Connor (46166) | asked Jul 09 '10, 12:12 p.m.
JAZZ DEVELOPER
It takes a bit to get databases from our DBA team. So, I need to ask in advance.
Right now, there is a database created for our eval RTC, one for our eval of RRC, one for our production RQM. And there are also 2 or 3 (can't remember) for our Insight evaluation. When we get the beta drop to test, am I asking for 3 SQL Server DBs for these 3 projects? Is the "common reporting--which is based on Insight" going to require additional databases as well?

6 answers



permanent link
James Moody (3.3k24) | answered Jul 13 '10, 10:06 a.m.
JAZZ DEVELOPER
It takes a bit to get databases from our DBA team. So, I need to ask in advance.
Right now, there is a database created for our eval RTC, one for our eval of RRC, one for our production RQM. And there are also 2 or 3 (can't remember) for our Insight evaluation. When we get the beta drop to test, am I asking for 3 SQL Server DBs for these 3 projects? Is the "common reporting--which is based on Insight" going to require additional databases as well?


Hi,

I'll leave the first part of your question for someone else, but I can address the reporting-related question. The CLM reporting story will involve a common data warehouse, which is a database separate and distinct from the transactional/operational databases that underlie RTC/RQM/RDRP. So yes, there is an additional database to support reporting.

james
CLM Reports Team Lead

permanent link
Sterling Ferguson-II (1.6k9282269) | answered Jul 13 '10, 10:42 a.m.
Hello,

Thanks for the response. So, just to clarify. I want to download the milestone and install the Full CLM Workbench. How many DBs do I need?

RTC = Y
RQM = Y
RDRP = ? Is this separate or a part of RQM?
(Common Reporting) = Y?
Anything else?

thanks...


It takes a bit to get databases from our DBA team. So, I need to ask in advance.
Right now, there is a database created for our eval RTC, one for our eval of RRC, one for our production RQM. And there are also 2 or 3 (can't remember) for our Insight evaluation. When we get the beta drop to test, am I asking for 3 SQL Server DBs for these 3 projects? Is the "common reporting--which is based on Insight" going to require additional databases as well?


Hi,

I'll leave the first part of your question for someone else, but I can address the reporting-related question. The CLM reporting story will involve a common data warehouse, which is a database separate and distinct from the transactional/operational databases that underlie RTC/RQM/RDRP. So yes, there is an additional database to support reporting.

james
CLM Reports Team Lead

permanent link
Sterling Ferguson-II (1.6k9282269) | answered Jul 15 '10, 12:05 p.m.
Has anyone installed the full CLM on this forum? Does anyone know the full number of databases required if you install everything?

thanks...

Hello,

Thanks for the response. So, just to clarify. I want to download the milestone and install the Full CLM Workbench. How many DBs do I need?

RTC = Y
RQM = Y
RDRP = ? Is this separate or a part of RQM?
(Common Reporting) = Y?
Anything else?

thanks...

permanent link
Ralph Schoon (63.2k33646) | answered Jul 16 '10, 3:19 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

i don't have everything up and running yet, however after installing 3.0M6 and looking into its structure the following appears to be the case.

- There is a DB used by the jazz team server e.g. for common user administration
- Each CLM product in usage has its own DB e.g. RTC, RQM, RDRP

If additional products get installed that need databases, these would have to be added.

Too many databases? Please keep in mind that the solution would have to scale, integrate and needs some flexibility. That means usage can grow causing growing database space and usage. Newly deployed products e.g. in different departments need to be integrated with existing ones.

I think the current solution addresses that.
e.g. it would be possible to move databases to different DB servers RTC to DBS1 and RQM to DBS2 maybe the Jazz DB to DBs99.
Even if installed on a different application server RTC could still work with the other products as if it would be installed on the same.

I think this is a pretty good overview: http://jazz.net/projects/rational-workbench-for-clm/

Ralph


Has anyone installed the full CLM on this forum? Does anyone know the full number of databases required if you install everything?

thanks...

Hello,

Thanks for the response. So, just to clarify. I want to download the milestone and install the Full CLM Workbench. How many DBs do I need?

RTC = Y
RQM = Y
RDRP = ? Is this separate or a part of RQM?
(Common Reporting) = Y?
Anything else?

thanks...

permanent link
Sudhakar Frederick (80113631) | answered Jul 19 '10, 12:04 a.m.
JAZZ DEVELOPER
(Common Reporting) = Y?
You need 2 separate databases for the Common Reporting piece - one for

the Content Store, another for the Data Warehouse.

Freddy

On 14/07/2010 12:52 AM, itengtools wrote:
Hello,

Thanks for the response. So, just to clarify. I want to download the
milestone and install the Full CLM Workbench. How many DBs do I
need?

RTC = Y
RQM = Y
RDRP = ? Is this separate or a part of RQM?
(Common Reporting) = Y?
Anything else?

thanks...


jmoodywrote:
It takes a bit to get databases from our
DBA team. So, I need to ask in advance.
Right now, there is a database created for our eval RTC, one for our
eval of RRC, one for our production RQM. And there are also 2 or 3
(can't remember) for our Insight evaluation. When we get the beta
drop to test, am I asking for 3 SQL Server DBs for these 3 projects?
Is the "common reporting--which is based on Insight" going
to require additional databases as well?

Hi,

I'll leave the first part of your question for someone else, but I can
address the reporting-related question. The CLM reporting story will
involve a common data warehouse, which is a database separate and
distinct from the transactional/operational databases that underlie
RTC/RQM/RDRP. So yes, there is an additional database to support
reporting.

james
CLM Reports Team Lead


permanent link
James Moody (3.3k24) | answered Jul 20 '10, 10:58 p.m.
JAZZ DEVELOPER
That's true if you're using the optional custom reporting, but not for
the out-of-the-box reporting, which only requires the data warehouse.

james
CLM Reporting Team Lead

On 7/19/2010 12:04 AM, Freddy wrote:
(Common Reporting) = Y?
You need 2 separate databases for the Common Reporting piece - one for
the Content Store, another for the Data Warehouse.

Freddy

On 14/07/2010 12:52 AM, itengtools wrote:
Hello,

Thanks for the response. So, just to clarify. I want to download the
milestone and install the Full CLM Workbench. How many DBs do I
need?

RTC = Y
RQM = Y
RDRP = ? Is this separate or a part of RQM?
(Common Reporting) = Y?
Anything else?

thanks...


jmoodywrote:
It takes a bit to get databases from our
DBA team. So, I need to ask in advance.
Right now, there is a database created for our eval RTC, one for our
eval of RRC, one for our production RQM. And there are also 2 or 3
(can't remember) for our Insight evaluation. When we get the beta
drop to test, am I asking for 3 SQL Server DBs for these 3 projects?
Is the "common reporting--which is based on Insight" going
to require additional databases as well?

Hi,

I'll leave the first part of your question for someone else, but I can
address the reporting-related question. The CLM reporting story will
involve a common data warehouse, which is a database separate and
distinct from the transactional/operational databases that underlie
RTC/RQM/RDRP. So yes, there is an additional database to support
reporting.

james
CLM Reports Team Lead


Your answer


Register or 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.