In my case it turned out that drools workbench was too much for non-tech folks. They were from operations and they felt that guided rule, guided decision tables, etc are something that won’t be comfortable with and cumbersome to work with.
Their job was to add rules and the main problem is that the number of rules was pretty high(~70 rules per project) with 30 projects. These rules should be dynamic, meaning they could change often.
Obviously I don’t need KIE server and drools workbench anymore. Furthermore since the ops were familiar with excel we’ve decided to write these dynamic rules into an excel custom format(not to be confused with drools Spreadsheet Decision Tables).
Let’s try to introduce a simplified example here. We want to be able to delete some items which we specify in that excel format. Now this particular example it’s not sufficient for introducing a feature like this, since it can be easily achieved with Guided Decision Tables or Spreadsheet Decision Tables, but it will prove the point. And my particular situation was much different and more complex than this(it involved merging and average calculations). The custom excel format that we’re gonna use is.
Again this is an oversimplification. The source can be anything(csv, text) and kept anywhere(system, s3, ftp) as long we can read it.