PMML to SQL and PMML to Java converter nodes

KNIME Analytics Platform
1

Hi,

where can I find the new pmml nodes?

2

It is in the KNIME Labs/PMML translation or something similar feature (and category withing node repository).

3

Hi Gabor,

I couldn't find these new nodes anywhere in the node repository. Is it possible that they are part of the commercial features of Knime?

4

No, I just installed them from the KNIME Labs update category (after updating to KNIME 2.11.1). They are released under GNU GPL. After that, I could find the following nodes: Compiled Model Predictor, PMML Compiler, PMML Compiling Predictor, PMML to SQL. (The last one suggests it works best with MySQL.)

5

Yeah, I got that.

Thanks, Gabor.

6

And where do I get the PMML Basic Compilation license?

7

Dear All,

 

Is there a resource with explicit instructions for implementing the PMML to SQL procedures?  

 

Thanks,

 

Ken

 

8

Hi Ken,

I'm afraid I don't understand what you mean. Do you want to know how to use the node or how it works?

Regards,

Alexander

9

I've attached a workflow that shows how to generate SQL from a PMML Model. It uses SQLite, but should also work with other databases.

Regards,

Alexander

10

Alexander,

Thank you for the response--I'll look into this straight away.

 

Ken