Datawarehouse extension - new tables in repository

1. If you want to use the new datawarehouse tables in a brand new database, patch the server / repotools with the new bundle you created and use repotools -createTables to create all the tables including the new datawarehouse tables

2. If you want to use it in an existing database, patch the server to include the new bundle and use repotools -addTables to add the new datawarehouse tables to the database

After you have added the new datawarehouse tables, you will be able to create a snapshot of the information you want to capture.

--- Balaji
Jazz Server Team

The article https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending was very helpful to understand how to extend the jazz Datawarehouse schema. One thing that was unclear was the following statement:

Creating the Tables in your Repository

The data warehouse tables are created upon server installation (or, during local development, when running the JUnit test case that creates all of the databases).

If a datawarehouse extension is deployed to the server for a completely new dimension or fact table, is that taken care of by the Datawarehouse framework, or do those tables have to be manually created in the backend database? Also, any pointers on how that can be done using the RTC client for a backend Derby repository?

Thanks,

Thanks Balaji. We will add this information to the wiki article, as it
seems to be missing (and is important).

james

balajik wrote:

1. If you want to use the new datawarehouse tables in a brand new
database, patch the server / repotools with the new bundle you
created and use repotools -createTables to create all the tables
including the new datawarehouse tables

2. If you want to use it in an existing database, patch the server to
include the new bundle and use repotools -addTables to add the new
datawarehouse tables to the database

After you have added the new datawarehouse tables, you will be able to
create a snapshot of the information you want to capture.

--- Balaji
Jazz Server Team

smehtawrote:
The article
https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending
was very helpful to understand how to extend the jazz Datawarehouse
schema. One thing that was unclear was the following statement:

Creating the Tables in your Repository

The data warehouse tables are created upon server installation (or,
during local development, when running the JUnit test case that
creates all of the databases).

If a datawarehouse extension is deployed to the server for a
completely new dimension or fact table, is that taken care of by the
Datawarehouse framework, or do those tables have to be manually
created in the backend database? Also, any pointers on how that can
be done using the RTC client for a backend Derby repository?

Thanks,