Pan

Contents

1 Pendahuluan
2 Syntax Dasar
3 Contoh Penggunaan di Windows

Pendahuluan

Pan digunakan untuk mengeksekusi file transformation yang berekstensi .ktr. Pan sendiri adalah script dalam bentuk file pan.bat (untuk Windows) dan pan.sh (untuk Unix/Linux).

Syntax Dasar

Syntax penggunaan dari pan tanpa menggunakan repository adalah :

pan -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

Untuk Repository

Repository

pan -rep=[NamaRepository] -trans=[NamaTransformation] -user=[NamaUser] -pass=[Password]

Contoh Penggunaan di Windows

Download file contoh.zip dari attachment di bawah atau dari link ini. Isi dari contoh.zip ini adalah file transformasi baca_propinsi.ktr dan satu contoh data propinsi.cvs.
Ekstrak isi file zip ini ke folder c:\contoh_kettle
Jalankan command prompt (Start | Run | ketik cmd | klik OK)
Masuk ke folder Kettle dan jalankan transformation baca_propinsi.ktr

Contoh Perintah :

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

C:\Kettle>pan -file=c:\contoh_kettle\baca_propinsi.ktr -level=detailed
Contoh rincian tampilan setelah eksekusi dari perintah di atas

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

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

C:\Kettle>pan -file=c:\contoh_kettle\baca_propinsi.ktr -level=detail
INFO 24-08 19:29:42,625 (LogWriter.java:println:406) -Pan - Logging is at leve
l : Basic logging
INFO 24-08 19:29:42,640 (LogWriter.java:println:406) -Pan - Start of run.
2008/08/24 19:29:47:843 ICT [INFO] DefaultFileReplicator - Using "C:\DOCUME~1\Fe
ris\LOCALS~1\Temp\vfs_cache" as temporary files store.
INFO 24-08 19:29:49,031 (LogWriter.java:println:406) -baca_propinsi - Dispatch
ing started for transformation [baca_propinsi]
INFO 24-08 19:29:49,031 (LogWriter.java:println:406) -baca_propinsi - Nr of ar
guments detected:0
INFO 24-08 19:29:49,031 (LogWriter.java:println:406) -baca_propinsi - This is
not a replay transformation
INFO 24-08 19:29:49,109 (LogWriter.java:println:406) -baca_propinsi - This tra
nsformation can be replayed with replay date: 2008/08/24 19:29:49
INFO 24-08 19:29:49,109 (LogWriter.java:println:406) -baca_propinsi - Initiali
sing 3 steps...
INFO 24-08 19:29:49,140 (LogWriter.java:println:406) -Text file output.0 - Ope
ning output stream in default encoding
INFO 24-08 19:29:49,281 (LogWriter.java:println:406) -CSV file input.0 - Start
ing to run...
INFO 24-08 19:29:49,296 (LogWriter.java:println:406) -Modified Java Script Val
ue.0 - Starting to run...
INFO 24-08 19:29:49,312 (LogWriter.java:println:406) -CSV file input.0 - Finis
hed processing (I=34, O=0, R=0, W=33, U=0, E=0)
INFO 24-08 19:29:49,312 (LogWriter.java:println:406) -Text file output.0 - Sta
rting to run...
INFO 24-08 19:29:50,546 (LogWriter.java:println:406) -Modified Java Script Val
ue.0 - Finished processing (I=0, O=0, R=33, W=33, U=0, E=0)
INFO 24-08 19:29:50,546 (LogWriter.java:println:406) -Text file output.0 - Fin
ished processing (I=0, O=34, R=33, W=33, U=0, E=0)
INFO 24-08 19:29:50,625 (LogWriter.java:println:406) -baca_propinsi - Transfor
mation ended.
INFO 24-08 19:29:50,625 (LogWriter.java:println:406) -Pan - Finished!
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -Pan - Start=2008/08/24 1
9:29:48.390, Stop=2008/08/24 19:29:50.640
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -Pan - Processing ended a
fter 2 seconds.
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -baca_propinsi -
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -baca_propinsi - Process
CSV file input'.0 ended successfully, processed 0 lines. ( 0 lines/s)
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -baca_propinsi - Process
Modified Java Script Value'.0 ended successfully, processed 33 lines. ( 16 lines
/s)
INFO 24-08 19:29:50,640 (LogWriter.java:println:406) -baca_propinsi - Process
Text file output'.0 ended successfully, processed 33 lines. ( 16 lines/s)

C:\Kettle>
Pada folder C:\contoh_kettle akan terbentuk satu file baru : propinsi.txt
Selesai