title: Business rule engine to inject to ETL job (Pentaho)
body: <p>We are using Pentaho as ETL tool, database is Oracle.</p>
  
  <p>And we want the give the power of defining business rules to the end user, which will execute the given transformations in selected phases of the ETL.</p>
  
  <p>So a user will define some rules on a UI.  I will create a UI with many dropdowns to define certain type of rules, for ex.:</p>
  
  <p>"Range" rule, a column should be in that range </p>
  
  <p>"Not null" rule: If a  field value is null change it to UNKNOWN or</p>
  
  <p>"Count rule" if a total number of rows increased by given percentage stop the ETL
  etc.
  Those rules  will be injected to the ETL job. We cant hard code rules. </p>
  
  <p>I tried to use Drools under Pentaho but the documentation is almost non-existent (For the use under Pentaho), 
  So I decided  to implement the Rule Engine myself:
  I will create a UI , which basically will allow to define business rules and those will be converted to SQL statements and stored in database.And in Pentaho there is something called Execute Row Script step, which allows to execute sql statements stored in a table.</p>
  
  <p>The idea creating business rules as SQL statements seems not so good but I dont have any other choice based on my research.</p>
  
  <p>Do you know any tool that would create business rules as SQL?  Any advice overall?
  Thanks</p>