Kitchen

Contents

1 Pendahuluan
2 Syntax Dasar
3 Contoh Penggunaan di Windows

Pendahuluan

Kitchen merupakan utilitas command line yang digunakan untuk mengeksekusi file job Kettle / Pentaho Data Integration ( .kjb ) atau job yang tersimpan di repository.

Kitchen sendiri adalah file dalam bentuk script dengan nama kitchen.bat untuk lingkungan Windows dan kitchen.sh untuk lingkungan Unix/Linux.

Dengan penggunaan Kitchen maka kita dapat melakukan scheduling / penjadwalan jalannya script di background process tanpa melalui GUI. Penjadwalan di Linux dapat menggunakan cron job dan di Windows menggunakan Task Sheduling.

Syntax Dasar

Syntax penggunaan dari kitchen tanpa menggunakan repository adalah :

kitchen -file=namafile [-version] [-log=namafilelog][-level=logging level]

Untuk logging level dapat dimasukkan nilai berikut :

Error    : Hanya menunjukkan error
Nothing : Tidak menghasilkan output apapun
Minimal : Menggunakan log yang minimal
Basic    : Merupakan nilai default dan berisi log yang dasa
Detailed : Memberikan output yang terinci
Debug    : Output debug, sangat rinci
Rowlevel : Log pada level baris data, dapat menghasilkan data yang sangat besar

Contoh Penggunaan di Windows

Download file buat_file.kjb dari attachment di bawah atau dari link ini. File job digunakan untuk membuat 2 file, yaitu Hello.txt dan Indonesia.txt
Tempatkan file ini ke folder c:\contoh_kettle
Jalankan command prompt (Start | Run | ketik cmd | klik OK).
Masuk ke folder Kettle dan jalankan job buat_file.kjb.

Contoh Perintah :

C:\Documents and Settings\Feris>cd c:\Kettle

C:\Kettle>kitchen -file=c:\contoh_kettle\buat_file.kjb -level=detailed
Contoh rincian tampilan setelah eksekusi dari perintah di atas

C:\Kettle>kitchen -file=c:\contoh_kettle\buat_file.kjb -level=detailed
INFO 25-08 09:07:11,328 (LogWriter.java:println:406) -Kitchen - Logging is at
level : Detailed logging
INFO 25-08 09:07:13,750 (LogWriter.java:println:406) -Kitchen - Start of run.
INFO 25-08 09:07:14,250 (LogWriter.java:println:406) -org.pentaho.di.core.util
.ResolverUtil@153f67e - Scanning for classes in [file:/C:/Kettle/lib/kettle-engi
ne-3.0.jar] matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@15b
dc50
INFO 25-08 09:07:17,843 (LogWriter.java:println:406) -StepLoader - Looking for
plugins in directory: plugins\steps
INFO 25-08 09:07:17,890 (LogWriter.java:println:406) -org.pentaho.di.core.util
.ResolverUtil@18d7ace - Scanning for classes in [file:/C:/Kettle/lib/kettle-engi
ne-3.0.jar] matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@179
953c
2008/08/25 09:07:19:671 ICT [INFO] DefaultFileReplicator - Using "C:\DOCUME~1\Fe
ris\LOCALS~1\Temp\vfs_cache" as temporary files store.
INFO 25-08 09:07:21,062 (LogWriter.java:println:406) -SharedObjects - Reading
the shared objects file [file:///C:/Documents and Settings/Feris/.kettle/shared.
xml]
INFO 25-08 09:07:21,437 (LogWriter.java:println:406) -Thread[buat_file (buat_f
ile (Thread-1)),5,main] - exec(0, 0, START.0)
INFO 25-08 09:07:21,468 (LogWriter.java:println:406) -buat_file (buat_file (Th
read-1)) - Sleeping: 0 minutes
INFO 25-08 09:07:21,468 (LogWriter.java:println:406) -buat_file - Starting ent
ry [Create Hello.txt]
INFO 25-08 09:07:21,468 (LogWriter.java:println:406) -Thread[buat_file (buat_f
ile (Thread-1)),5,main] - exec(1, 0, Create Hello.txt.0)
INFO 25-08 09:07:21,484 (LogWriter.java:println:406) -Create Hello.txt - File
[file:///c:/contoh_kettle/Hello.txt] created!
INFO 25-08 09:07:21,500 (LogWriter.java:println:406) -buat_file - Starting ent
ry [Create Indonesia]
INFO 25-08 09:07:21,500 (LogWriter.java:println:406) -Thread[buat_file (buat_f
ile (Thread-1)),5,main] - exec(2, 0, Create Indonesia.0)
INFO 25-08 09:07:21,515 (LogWriter.java:println:406) -Create Indonesia - File
[file:///c:/contoh_kettle/Indonesia.txt] created!
INFO 25-08 09:07:21,515 (LogWriter.java:println:406) -buat_file - Finished job
entry [Create Indonesia] (result=true)
INFO 25-08 09:07:21,515 (LogWriter.java:println:406) -buat_file - Finished job
entry [Create Hello.txt] (result=true)
INFO 25-08 09:07:21,515 (LogWriter.java:println:406) -Kitchen - Finished!
INFO 25-08 09:07:21,531 (LogWriter.java:println:406) -Kitchen - Start=2008/08/
25 09:07:20.812, Stop=2008/08/25 09:07:21.531
INFO 25-08 09:07:21,531 (LogWriter.java:println:406) -Kitchen - Processing end
ed after 0 seconds.

C:\Kettle>
Pada folder C:\contoh_kettle akan terbentuk dua file baru : Hello.txt dan Indonesia.txt
Selesai