Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

ODBC Data Access connection to Jazz Repository for BRIO

I was wondering if an ODBC data connection can be made to the Jazz repository / Data warehouse to allow BRIO to collect data. If so, how?

Thanks O. Frank

0 votes



One answer

Permanent link
I'm not an ODBC expert, but I think it should be possible to connect using the same elements of the JDBC connection spec: host+post+database name.

That's likely the easy part. After that, you'll need some info from https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas to understand what you're seeing in the data warehouse. Note that the data warehouse table names vary slightly by database vendor, so reports which don't use the BIRT ODA adapters will end up being database-specific.

Hope this helps.

Scott Rich
Jazz team

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 21 '09, 8:17 a.m.

Question was seen: 4,755 times

Last updated: Apr 21 '09, 8:17 a.m.

Confirmation Cancel Confirm