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

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

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

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

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

(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

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