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

How can I configure ETLs to extract data from a single project area in RTC?

Questions
Tags
Users
Badges
Jorge Alarcon
(41●11●22) Jul 22 '16, 5:08 p.m.
Hi

I now that Rational Insight offers to customize jobs, but I would like to know how to do it if what I want is to extract the data from only one project area within an RTC to fill up a datawarehouse, or is this something that can be done using DCC?

Regards

0 votes

Comments
Kevin Ramer
Jul 22 '16, 5:26 p.m.
This might be possible, but all reporting against the data warehouse respects the visibility of data against the authority of the person executing the report, if that is part of your concern....

Jorge Alarcon
Jul 22 '16, 5:44 p.m.
Hi Kevin Our situation is that a client wants to be able to extract the information from their project area directly from the database however due to certain policies we can't give them access because they will have access to other clients projects that share the same clm, so we opted to configure a rational insight to fill another datawarehouse with their project area information only so that they can read all that information. Thanks

Steve Mulligan
Jul 25 '16, 10:08 a.m.
The Rational Insight XML interface only supports getting data from all the project areas for a CLM server.  However, The second instance of Rational Insight could be set up with a filter on the Data Manager JFS and RTC jobs to filter out all projects but the one you want into second warehouse.  You would have to reapply the filter when Rational Insight is upgraded.

1 vote

Jorge Alarcon
Jul 25 '16, 2:28 p.m.
Hi Steve do you know where can I find more detailed information / tutorials that could help me to create these filters? Regards

1 answer
5,240 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) edited
Jul 23 '16, 10:23 a.m.
I don't believe that is possible, at least not easily. I think the new Reporting in RTC 6.0.x respects access control to project areas as far as I can tell.

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.

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
× 12,144
× 232
× 53

Question asked: Jul 22 '16, 5:08 p.m.

Question was seen: 5,240 times

Last updated: Jul 25 '16, 2:28 p.m.

Confirmation Cancel Confirm