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

Using Snapshot tables with Rational Insight

Questions
Tags
Users
Badges
Steve Mulligan
(176●13●21) Apr 09 '13, 4:30 p.m.

The current ETL that I run for RTC 3.0 gets RTC data from the Snapshot tables (e.g. COMMON_SNAPSHOT.CONTRIBUTOR) in the RTC DB2 database. 

With the Rational Insight 1.1.1.1 system that we are evaluating, the Snapshot tables are not populated.  The RI Data Manager ETL uses XML ODBC to access the RTC data, so Snapshot tables are not required. 

We would like to run the existing ETL against the Snapshot tables in parallel with the RI ETL until all our datawaouse and reporting requirements are ported to RI.

Can the Snapshot tables be populated with CLM and RI? 

0 votes

1 answer
7,197 views
0 votes

One answer

Permanent link
Jackie Albert
(1.6k●1●49●47) Apr 09 '13, 5:01 p.m.
Our team does this today. In CLM you set your data provider to 'Local' instead of 'Warehouse' and the data mart will be populated via the data movement tasks from the CLM server.   You can then still run the ETL's from Rational Insight to populate the warehouse.

I don't believe this is the recommended method - the data warehouse is preferred over the data mart (Snapshot tables) and I think starting with CLM 4.0.1 you will get reduced reporting functionality if you use this instead of warehouse.

1 vote

Comments
Steve Mulligan
Apr 10 '13, 2:45 p.m.
You are referring to a datamart being populated via the data movement tasks from the CLM server.  Are you referring to a datamart in the CLM warehouse?   The Snapshot tables I am referring to are in the Live RTC database, not the CLM warehouse.  The non-CLM ETL I am currently running gets RTC 3.0 data directly from those Snapshot tables and puts it into are existing warehouse.   When we move to RTC 4.0, I would like to run both the existing non-CLM ETL against the Live Snapshot tables into our existing warehouse and run the Rational Insight ETL through the XML ODBC interface.  The Snapshot tables in our current Live RTC 3.0 database are currently being populated.  However, the Snapshot tables are not being populated in the Live RTC database for our evaluation CLM 4.0.1.

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.

Ask a question
Guidelines
FAQ
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
× 6,180

Question asked: Apr 09 '13, 4:30 p.m.

Question was seen: 7,197 times

Last updated: Apr 10 '13, 2:45 p.m.

Confirmation Cancel Confirm