Hi,

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.

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

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

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

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