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: 902
Size:  34.5 KB

Name:  276929pdi02.jpg
Views: 715
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: 901
Size:  8.7 KB

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

Name:  315255pdi04.jpg
Views: 669
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.