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

How do I pull only specific ClearQuest info through Data Services into the Data Warehouse

We installed Rational Insight Data Services and connected it to the customer's CQ repository.  I want to only pull data into the Data Warehouse that meets a specific criteria for the Project field like 'where Project = 'Project A'.  Where would I do this?  I could only find documentation on adding new fields or attributes to the xdc file.

Not sure if in this case I do it through the Data Manager ODS jobs and add on to the where clause where 'modified_since' is or in the xdc file.

Is there any documentation on this? Customer is on Insight 1.1.1.2

0 votes



One answer

Permanent link

Hi Michael,

You'd want to do this in the Data Manager job, and add an additional filter on the where clause after the 'modified_since', rather than in the XDC file itself. 

2 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
× 12,020
× 7,495

Question asked: Mar 11 '14, 3:33 a.m.

Question was seen: 4,072 times

Last updated: Mar 11 '14, 9:12 a.m.

Confirmation Cancel Confirm