DCC: what to specify as "A Relational Database DataSource"?
I am working with DCC version 5.0.2.
I have already deployed and configured it, integrated it with the CLM applications and connected it to its own database.
I am a bit confused, however, by the "" section under the data sources page.
According to the guide, this is where DCC writes the metrics for the Data Mart, and I should provide the connection settings to the data warehouse database.
Anyway, the data warehouse connection settings are already provided in another page of the DCC administration site.
Is this necessary because the Data Mart database could be different from the one we use for the Data Warehouse?
I have already deployed and configured it, integrated it with the CLM applications and connected it to its own database.
I am a bit confused, however, by the "" section under the data sources page.
According to the guide, this is where DCC writes the metrics for the Data Mart, and I should provide the connection settings to the data warehouse database.
Anyway, the data warehouse connection settings are already provided in another page of the DCC administration site.
Is this necessary because the Data Mart database could be different from the one we use for the Data Warehouse?
Accepted answer
Hello Luca,
it's correct, you need to specify the data warehouse database connection details in
Rational Reporting Data Warehouse Database > "".
It's configured in 2 places because the one in the Resource Group Configuration page will be used to Read the data from the data warehouse for the Metrics jobs, and the one in the "Data Collection Configuration" page will be used to Write the data processed by the data collection for all the job into the data warehouse.
This can be a bit confusing, but was done with the purpose of keeping all the data sources together and the data warehouse is both the data source and the target in the data mart (metrics) jobs.
Best Regards
Francesco Chiossi
it's correct, you need to specify the data warehouse database connection details in
Rational Reporting Data Warehouse Database > "".
It's configured in 2 places because the one in the Resource Group Configuration page will be used to Read the data from the data warehouse for the Metrics jobs, and the one in the "Data Collection Configuration" page will be used to Write the data processed by the data collection for all the job into the data warehouse.
This can be a bit confusing, but was done with the purpose of keeping all the data sources together and the data warehouse is both the data source and the target in the data mart (metrics) jobs.
Best Regards
Francesco Chiossi