Hello - I have a requirement where in I need to look up for some external reference data to write my rule conditions. For example, if there is an external table with country names, I should be able to use it while writing my rules where a country name is required. Tomorrow if a new country is added to the external list, then it should be available for me to write a rule. I know this can be done using dynamic domains but looks like there are limitations with it. First is data duplication and second is for the size limit. I don't think dynamic domains can be used for over a few thousand values. How can this be achieved in ODM without duplicating the data and restrictions on the size? Any suggestions or help is highly appreciated.

Thanks,

Your can implement a ValueProvider extension to query your external reference data like in https://www.ibm.com/docs/en/odm/8.10?topic=ebvt-example-implementing-city-by-state-value-provider-in-rule-designer

Hi... Thanks for your response. The example in the link provided is very abstract. Where are the states and cities stored? How to I connect to that external data source? Can I use the data from an existing table in an external database?

Is there any step by step approach example as the documentation just gives the information but it is not clear as to how to implement it from the scratch. Kindly suggest.

Thanks,

Hi, search in the documentation how to create and integrate a ValueProvider or ValueInfo probably in the section of "Rule Authoring Extensions". You can take the sample that I sent as reference. Just look into the Java class StateCityValueProvider, at the end this is an implementation of the inteface IlrAbstractValueProvider. You can implement in Java as you want. You can use JDBC code to access data in any table. If you want you can make a query, but you will make you BR editor dependent on the availability of the DB because the query is done in-line during the Rule edition.

There is another option as in this other sample: https://www.ibm.com/docs/en/odm/8.10?topic=extensions-data-sources-bom-domains I personally think this is a better and more escalable option. It

requires synchronization and the values deleted in the DB are marked as obsolete.

You can later search for all the rules using obsolete values and remediate. The problem maybe the number of items in the domain. I cannot tell you the limit but I have used with pretty large domains and the product can take it. Give it a try.

Hi... Thanks for your prompt response and really appreciate for your time. Value editors seems to be pretty difficult to implement especially where there is only a high level information. I did try the second option dynamic domains but with excel and it was able to take up to 5k values. My requirement is about 20k values. I will try the domains with database. I have question here....so during the execution/runtime, will there be a call to the database for each attribute to look for the BOMtoXOM mapping value?

Thanks,

No.

The access to the DB or Excel will be only when you do a dynamic domains synchronization in your project either in Decision Center (https://www.ibm.com/docs/en/odm/8.10?topic=artifacts-dynamic-domains) or in Rule Designer (https://www.ibm.com/docs/en/odm/8.10?topic=domains-updating-single-dynamic-domain)