It's all about the answers!

Ask a question

How to query data from data warehouse?


li bin (121) | asked Jul 30 '09, 5:30 a.m.
Hi,
I've followed this wiki(https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending) extends the data warehouse.
I am wondering how to query data from the data warehouse in RTC 2.0.Can anyone show me some code example?

Take the numbers snapshot service as an exmaple, how to query records by CONTINENT_COLUMN? I wanna get the result as "select * form Numbers whereCONTINENT_COLUMN =?".

Thanks

One answer



permanent link
James Moody (3.3k24) | answered Jul 30 '09, 2:19 p.m.
JAZZ DEVELOPER
On 7/30/2009 5:38 AM, icyfire0105 wrote:
Hi,
I've followed this
wiki(https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending)
extends the data warehouse.
I am wondering how to query data from the data warehouse in RTC
2.0.Can anyone show me some code example?

Take the numbers snapshot service as an exmaple, how to query records
by CONTINENT_COLUMN? I wanna get the result as "select * form
Numbers whereCONTINENT_COLUMN =?".

Thanks


At the moment, your options are:

1. Use our ODA service, which provides access to the data in a limited
way (basically, the same way that our BIRT data sets do). So you won't
be able to do arbitrary SQL but you can still choose which columns to
select, and pass values in for other columns a la "where" (although you
can only do "=" and "IN", not other types of comparisons).

2. Direct JDBC access to the database, which we don't recommend and is
fraught with problems and gotchas.

3. Wait for a future release of RTC, where we hope to add REST-enabled
API that allow you read and write access to the data warehouse.

Hope this helps.

james
RTC Reports Team Lead

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.