RTC 3.0 Datawarehouse and Enterprise Database
What are the recommendations for using an enterprise database with the RTC 3.0 datawarehouse?
It appears as if Derby is the default database for use with the DW, and there do not appear to be any repotools or /setup commands that configure the DW tables for use with an enterprise database. |
3 answers
What are the recommendations for using an enterprise database with the RTC 3.0 datawarehouse? Hi Joe, For RTC 3.0, the data warehouse functions the same way as it did in RTC 2.0: that is, it's part of the same database as the repository store, and doesn't require any separate or explicit setup. If you move your repository to DB2, for example, the data warehouse goes with it. In CLM Beta 2, however, we've introduced a new, shared data warehouse that is separately configurable from the repository database(s), and does indeed require separate setup and configuration. There's a separate "Configure Data Warehoue" step in the server setup wizard to help you do this, and a repotools command as well. It sounds like you're asking about RTC 3.0 - can you confirm that's the case? james RTC Reports Team Lead |
|
Yes, RTC 3.0. Thanks. We had seen information in the Release Candidate InfoCenters recommending creation of a separate database for the DW, but I see that information has been removed from the InfoCenters for 3.0 GA. Thanks for the reply.
|
I'm installing RTC 3.0.1 RC2 and configuring via the /jts/setup steps.
On the Datawarehouse setup page, I want to use the existing Oracle databases, you mention "it's part of the same database as the repository store, and doesn't require any separate or explicit setup" Does this mean that com.ibm.team.repository.db.jdbc.location and com.ibm.team.datawarehouse.db.jdbc.location should be identical? |
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.