How to query data from data warehouse?

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