It's all about the answers!

Ask a question

access to data warehouse programmatically


Alberto Ceravolo (1698) | asked Mar 19 '10, 7:09 a.m.
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.

One answer



permanent link
James Moody (3.3k24) | answered Mar 26 '10, 11:22 a.m.
JAZZ DEVELOPER
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

Your answer


Register or to post your answer.