I just create a button that make an SQL SELECT string. And I want to use a registered PDI Kettle transformation as datasource to execute it.

  1. how to pass my SQL string created in JS button to the parameter of my PDI Ketle transformation registered as datasource in CDE
  2. execute it in ajax
  3. get the result in json callback.

That I do :
a) My Pentaho PDI / Kettle transformation is here and registered in Pentaho CDE. I want to use :

Name:  523146pdi01.jpg
Views: 945
Size:  34.5 KB

Name:  276929pdi02.jpg
Views: 732
Size:  20.6 KB

b) That’s the button and the begininng of the function : js button, js button in CDE, and the beginning of the code...

Name:  699004pdi03x.jpg
Views: 919
Size:  8.7 KB

Name:  387970pdi03.jpg
Views: 685
Size:  22.9 KB

Name:  315255pdi04.jpg
Views: 685
Size:  21.6 KB

..) How to do the excute this SQL SELECT statement passing by my datasource PDI (Kettle) registered as ktr_get_data, and result in callback (for create an excel for example) ?

Thanks for help.