First of all, I am not a software developer. I am making Salesforce.com projects. I used our company’s sales quote data with Knime (Random Forest Learner and predictor) and achieved to make a model which can predict with %72,6 accuracy whether a sales quote will be accepted or not. I just want to use that model for our Sales Reps to see Sales Quote’s consequence before they reach out the customer. Any idea how to extract that model for using with another software and/or software developing using that model?
you can export your Random Forest model to PMML like this:
Please note that the resulting PMML file will be very large because the trees in Random Forests are typically very deep.
yet another possibility is to use the H2O Random Forest Learner from our H2O integration instead of the KNIME Random Forest Learner. You can then export the trained model as H2O MOJO object, which is far more memory efficient than the PMML representation and supposedly easily integrable into Java applications.
Another option ist just to use a decision tree and then convert the PMML to a SQL ruleset. Some other PMML files might also be converted to SQL. The code is not pretty and you might have to tweak it a little bit but is should work. I have used this on occasions when it was not possible to transfer the model in any other way.
Also simple decision trees you can convert to a ruleset you could use to write if then else statements (not pretty I know but at least this would get you a result).
MOJO files also look promising.
Also you could select different ‘flavours’ of SQL.
