Nice suggestion.

Nice suggestion.

It really depends on how would you using these new data source.
A) You can create a report base on Rational Data warehouse.
B) You can create a live report base on REST server. Performance is your main concern.
Answer A:
1) Verify your new tables or new columns are already available on REST server. Most of Rational Insight supports data source are populating data on REST server. Mostly Rational Insight extract data from REST server not direct from data source. For example (CQ, CC, RQM..)
2) You need to customize the XDC file to map in the new tables or new columns
3) Modify data warehouse , to add in new tables or columns
4) Modify the ETL catalog to let it extract the data from REST server to data warehouse
5) Add in new tables and columns into DW Framework Manager model build relationship for the new tables, and publish the package again
Answer B:
1) Verify your new tables or new columns are already available on REST server. Most of Rational Insight supports data source are populating data on REST server. Mostly Rational Insight extract data from REST server not direct from data source. For example (CQ, CC, RQM..)
2) You need to customize the XDC file to map in the new tables or new columns
3) Add in new tables and columns into Live Framework Manager model build relationship for the new tables, and publish the package again

Nice suggestion.

It really depends on how would you using these new data source.
A) You can create a report base on Rational Data warehouse.
B) You can create a live report base on REST server. Performance is your main concern.
Answer A:
1) Verify your new tables or new columns are already available on REST server. Most of Rational Insight supports data source are populating data on REST server. Mostly Rational Insight extract data from REST server not direct from data source. For example (CQ, CC, RQM..)
2) You need to customize the XDC file to map in the new tables or new columns
3) Modify data warehouse , to add in new tables or columns
4) Modify the ETL catalog to let it extract the data from REST server to data warehouse
5) Add in new tables and columns into DW Framework Manager model build relationship for the new tables, and publish the package again
Answer B:
1) Verify your new tables or new columns are already available on REST server. Most of Rational Insight supports data source are populating data on REST server. Mostly Rational Insight extract data from REST server not direct from data source. For example (CQ, CC, RQM..)
2) You need to customize the XDC file to map in the new tables or new columns
3) Add in new tables and columns into Live Framework Manager model build relationship for the new tables, and publish the package again

Regarding B and performance, is there any additional information available around what can be expected for performance?

When I compare fields in Relational Packages (live connection) and Relational and Multidimensional Packages (DW connection) I have different fields maped.
For example, inside Execution Work Item Area we have Execution Work Item Related Test Plans query subject in the "live packages", but these same fields (query subject) are not avaiblable in "DW Packages".
Is there any way to include these fields in the out of box packages? I believe that we need to change the out of box packages, including ETL scripts. Does anyone know can I handle with that?

Hi Mario,

This is a tutorial that shows what should be done to customize Insight's ETL: Customizing the extract, transform, and load (ETL) process

Best Regards,
Paulo