Sourcing custom attribute values from database
We'd like to dynamically load values for custom attributes from existing data sources.
Is there anyway to source the enumeration values of a custom attribute from a database table?
Is extending AttributeValueProvider a feasible way to go? Or is there a better way?
On a related topic, I know you can extend the data warehouse database by creating new snapshot tables. But I am not sure whether we can extend the core RTC database with new tables?
Thanks!
Is there anyway to source the enumeration values of a custom attribute from a database table?
Is extending AttributeValueProvider a feasible way to go? Or is there a better way?
On a related topic, I know you can extend the data warehouse database by creating new snapshot tables. But I am not sure whether we can extend the core RTC database with new tables?
Thanks!
One answer
Starting in RTC-4.0, dynamically loading attribute values from an arbitrary HTTP source is available as "Filtered Value Set":
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_configuring_http_filtered_value_set.html
You can also store enumeration values in the database, allowing for permission-controlled additions to the enumeration values (no project area modification required):
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_defining_priorities_severities.html
WRT extending the data warehouse database, that requires purchasing a license to Rational Insight.
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_configuring_http_filtered_value_set.html
You can also store enumeration values in the database, allowing for permission-controlled additions to the enumeration values (no project area modification required):
https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_defining_priorities_severities.html
WRT extending the data warehouse database, that requires purchasing a license to Rational Insight.
Comments
For example see: https://jazz.net/library/article/1093 lab 5 how the HTTP Filtered value provider works.
Be aware that storing the enumeration values in the database currently does not work if you share a process. There is an enhancement request for that.
1 vote
Sigh.... I forgot to mention https://jazz.net/wiki/bin/view/Main/AttributeCustomization also describing how to do attribute customization. Please note you can also create Java extensions for that as described at the end of the page.