Business Intelligence Wiki

Business Intelligence Wiki - Kettle invoke its treatment from a web browser ,this question comes up quite regularly: can we start a treatment Kettle stored on a server in a repository (repository) ... not to connect to the same server? (without manually run the kitchen program)


Answer => Yes: Using the Web listener "Card" available as standard in IDPs.
Example (prerequisite: Kettle 5):

Here is an example (simplified) job just sending an email, the recipient is configurable via the task parameter $ {recipient}:

This send_mail job is stored in a repository called Kettle pdi-5.0 in a directory called spots:


Setting the configuration file to map:

In the data-integration directory (where is located carte.bat / sh), create the XML file "carte_config.xml» next:

<slave_config>   <slaveserver> <name>master</name> <hostname>localhost</hostname> <port>8082</port> <master>Y</master> </slaveserver>   <repository> <name>pdi-5.0</name> <username>admin</username> <password>admin</password> </repository>   </slave_config>

Execution card:

Launch carte.bat program (or .sh) command line: carte.bat carte_config.xml
Calling the job via a url:

Open a web browser and enter the following url:

http: // localhost: 8082 / kettle / runJob / job=/taches/send_mail&destinataire=osbi.fr@gmail.com?

A username and password, you are requested: enter cluster / cluster (note: this can be changed by editing the file \ data-integration \ pwd \ kettle.pwd)

A message informs you that your job completed successfully: