It's all about the answers!

Ask a question

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


Christopher Zuendorf (6162) | asked Oct 22 '08, 3:24 a.m.
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

3 answers



permanent link
Christopher Zuendorf (6162) | answered Oct 27 '08, 3:50 a.m.
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

permanent link
James Moody (3.3k24) | answered Oct 24 '08, 2:50 p.m.
JAZZ DEVELOPER
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

permanent link
Rafik Jaouani (5.0k16) | answered Oct 23 '08, 8:35 a.m.
JAZZ DEVELOPER
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.

Your answer


Register or to post 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.