access to data warehouse programmatically
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
On 3/19/2010 7:23 AM, albjazz wrote:
Hi, I have to access to the datawarehouse to get values from SCM 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
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.