access to data warehouse programmatically

On 3/19/2010 7:23 AM, albjazz wrote:

Hi, I have to access to the datawarehouse to get values from SCM
snapshot. I don't want use reports, but get values programmatically.
My idea is to get values by SQL queries (using jdbc if it's possible)
but I haven't found documentations or tutorials, so.. any suggestions?
It's possible to access to the datawarehouse by JDBC? There is some
example somewhere that shows how access and interrogate the
datawarehouse programmatically? Thanks.

Doing it generically using SQL queries could be difficult - it's
possible but won't work across database vendors.

Our custom ODA driver uses a repository mapping layer to translate the
logical table and column names into physical names, which may vary
depending on the db type. This is the implementation we use when
accessing data for BIRT reports. You can find the code for this in
com.ibm.team.reports.service.oda, starting in class ServiceQuery. Doing
something similar to what this driver does may be what you want.

james
RTC Reports Team Lead