How to administer Data Warehouse with Plain-Java-App?

If you are planning to extend the server with new data warehouse snapshots and tables, check the wiki topic: https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending.

Keagen85 wrote:

Hello Jazz-Team,

I have the following problem...
I want to put data about Estimates, Time Spent etc. of the past into
my current RTC project. It is important for us to have the product
burndown chart with the data of the past available in RTC. Therefore
I think I need to manually create a snapshot in Data Warehouse with
the data I want to put in.

How can I do this with an Java application? Can you give me a few
lines of code?

THX
C. Zuendorf

See the article that Rafik links to in the other post in this thread.
Extending the data warehouse (i.e. to contribute code which populates
the data warehouse) is done in java code, but only as plug-in that is
deployed to the server (i.e. not as a plain java application). We don't
currently provide any externally-visible APIs (REST APIs, for example)
that would let you access the data warehouse from a plain java
application, and we don't provide JDBC access to the data warehouse.

In the 1.1 timeframe we'll be looking at various options to make
extending the data warehouse easier, as this is important to us.

Hope this helps.

james
Jazz Reports Team Lead

Hello James and Rafik,

we already entered the past data by altering Derby database. An easier access to Data warehouse would be a great improvement. Especially when somebody want to migrate to RTC, and want to fill in "old" data.

We are looking forward to your next release.
Thx for your help

C. Zndorf