Re: [JUG-Indonesia] ETL Tool

2010-03-09 Terurut Topik mujoko mujoko
Maksud bro Syaiful baik kok bro :),
and jangan lupa kalo udah pake sendok pake juga panci :) buat manggil si
sendok and lebih lengkap pake dapur :)

On Tue, Mar 9, 2010 at 7:34 AM, Hendry Luk hendrym...@gmail.com wrote:



 Hey syaiful, lu mesti relax dikit mate. Baca lagi semua posting gw,
 requirement apa yg aneh?
 Etl apa ajah yg kalian suggest buat simple tasks? Preferably yg non-xml,
 tapi anything is ok. Ini requirement yg liberal banget if u ask me. Cuma
 friendly poll ajah, gak mesti participate kalo gak mau. What's with the
 hostility sir?

 Many useful inputs here (kettle, jasperjsp, talend), thanks all buat
 suggestionnya. Gw lagi check em out n bakal just pick one yg paling gampang
 buat gw (n team) to get up to speed (can't care less about features :P)

 Syaiful, gw appreciate 5 replies lu, tapi sorry gw gagal nangkep any value
 yg lu add to the discussion so far. Tacky sarcasm isn't exactly what i was
 looking for.

 2010/3/8 sm96 syaiful.mukh...@gmail.com



 mintanya macem-macem dan aneh-aneh..
 semakin gak ketemu aja nih pilihannya...
 bikin aja sendiri.

 2010/3/5 Henry Suryawirawan henry@gmail.com



 mungkin bisa juga cobain JasperETL ato Talend
 walau gue gak pernah cobain buat requirements yg kompleks spt Pak Feris
 ;-)
 ada GUI designer nya juga kok

 2010/3/4 Feris Thia feris.mi...@phi-integration.com



 For this, I think Kettle is very lightweight and will have the jobs done
 perfectly :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them
 across ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang
 didenormalise dulu dari table2 yg terkait
 etc






 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


  




-- 
Mujoko
http://www.linkedin.com/in/mujoko


Re: [JUG-Indonesia] ETL Tool

2010-03-09 Terurut Topik sm96
yah, karena yg lu butuhin sebenarnya udah ketemu. mau cari kemana lagi?
hahahaha

On Tue, Mar 9, 2010 at 7:34 AM, Hendry Luk hendrym...@gmail.com wrote:



 Hey syaiful, lu mesti relax dikit mate. Baca lagi semua posting gw,
 requirement apa yg aneh?
 Etl apa ajah yg kalian suggest buat simple tasks? Preferably yg non-xml,
 tapi anything is ok. Ini requirement yg liberal banget if u ask me. Cuma
 friendly poll ajah, gak mesti participate kalo gak mau. What's with the
 hostility sir?

 Many useful inputs here (kettle, jasperjsp, talend), thanks all buat
 suggestionnya. Gw lagi check em out n bakal just pick one yg paling gampang
 buat gw (n team) to get up to speed (can't care less about features :P)

 Syaiful, gw appreciate 5 replies lu, tapi sorry gw gagal nangkep any value
 yg lu add to the discussion so far. Tacky sarcasm isn't exactly what i was
 looking for.

 2010/3/8 sm96 syaiful.mukh...@gmail.com



 mintanya macem-macem dan aneh-aneh..
 semakin gak ketemu aja nih pilihannya...
 bikin aja sendiri.

 2010/3/5 Henry Suryawirawan henry@gmail.com



 mungkin bisa juga cobain JasperETL ato Talend
 walau gue gak pernah cobain buat requirements yg kompleks spt Pak Feris
 ;-)
 ada GUI designer nya juga kok

 2010/3/4 Feris Thia feris.mi...@phi-integration.com



 For this, I think Kettle is very lightweight and will have the jobs done
 perfectly :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them
 across ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang
 didenormalise dulu dari table2 yg terkait
 etc






 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


Re: [JUG-Indonesia] ETL Tool

2010-03-09 Terurut Topik Ifnu bima
 Syaiful, gw appreciate 5 replies lu, tapi sorry gw gagal nangkep any value yg 
 lu add to the discussion so far. Tacky sarcasm isn't exactly what i was 
 looking for.

Cannot more agree with this ;).


--


http://ifnu.artivisi.com
+62 856 9211 8687
regards


Re: [JUG-Indonesia] ETL Tool

2010-03-08 Terurut Topik sm96
mintanya macem-macem dan aneh-aneh..
semakin gak ketemu aja nih pilihannya...
bikin aja sendiri.

2010/3/5 Henry Suryawirawan henry@gmail.com



 mungkin bisa juga cobain JasperETL ato Talend
 walau gue gak pernah cobain buat requirements yg kompleks spt Pak Feris ;-)
 ada GUI designer nya juga kok

 2010/3/4 Feris Thia feris.mi...@phi-integration.com



 For this, I think Kettle is very lightweight and will have the jobs done
 perfectly :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them
 across ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang didenormalise
 dulu dari table2 yg terkait
 etc



  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


Re: [JUG-Indonesia] ETL Tool

2010-03-08 Terurut Topik agung nugroho
gw ngikut bung Feris d, Kettle - Spoon :)

--- On Mon, 8/3/10, sm96 syaiful.mukh...@gmail.com wrote:

From: sm96 syaiful.mukh...@gmail.com
Subject: Re: [JUG-Indonesia] ETL Tool
To: jug-indonesia@yahoogroups.com
Date: Monday, 8 March, 2010, 10:41 AM







 



  



  
  
  mintanya macem-macem dan aneh-aneh..
semakin gak ketemu aja nih pilihannya.. .
bikin aja sendiri.

2010/3/5 Henry Suryawirawan henry@gmail. com
















 



  



  
  
  mungkin bisa juga cobain JasperETL ato Talendwalau gue gak pernah cobain 
buat requirements yg kompleks spt Pak Feris ;-)ada GUI designer nya juga kok

2010/3/4 Feris Thia feris.milis@ phi-integration. com

















 



  



  
  
  For this, I think Kettle is very lightweight and will have the jobs done 
perfectly :)
Regards,
Feris

2010/3/4 Hendry Luk hendrym...@gmail. com



Btw gw gak butuh full stack BI solution, cuma buat beberapa regular lightweight 
tasks. Task2 semacem.:
- process semua rows dari outgoing sms di database ke file, ftp them across ke 
system laen




- process semua nomer telpon yang diactivate sepanjang hari ke standard IPND 
files buat diprocess for law n regulatory purposes
- process transaction data regularly buat diupdate ke reporting tables
- archive data harian ke database laen di archive box, yang didenormalise dulu 
dari table2 yg terkait




etc




 









  











 









  









-- 
syaiful.mukhlis
gtalk:syaiful. mukh...@gmail. com




 





 



  






  New Email names for you! 
Get the Email name you#39;ve always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

Re: [JUG-Indonesia] ETL Tool

2010-03-08 Terurut Topik Hendry Luk
Hey syaiful, lu mesti relax dikit mate. Baca lagi semua posting gw,
requirement apa yg aneh?
Etl apa ajah yg kalian suggest buat simple tasks? Preferably yg non-xml,
tapi anything is ok. Ini requirement yg liberal banget if u ask me. Cuma
friendly poll ajah, gak mesti participate kalo gak mau. What's with the
hostility sir?

Many useful inputs here (kettle, jasperjsp, talend), thanks all buat
suggestionnya. Gw lagi check em out n bakal just pick one yg paling gampang
buat gw (n team) to get up to speed (can't care less about features :P)

Syaiful, gw appreciate 5 replies lu, tapi sorry gw gagal nangkep any value
yg lu add to the discussion so far. Tacky sarcasm isn't exactly what i was
looking for.

2010/3/8 sm96 syaiful.mukh...@gmail.com



 mintanya macem-macem dan aneh-aneh..
 semakin gak ketemu aja nih pilihannya...
 bikin aja sendiri.

 2010/3/5 Henry Suryawirawan henry@gmail.com



 mungkin bisa juga cobain JasperETL ato Talend
 walau gue gak pernah cobain buat requirements yg kompleks spt Pak Feris
 ;-)
 ada GUI designer nya juga kok

 2010/3/4 Feris Thia feris.mi...@phi-integration.com



 For this, I think Kettle is very lightweight and will have the jobs done
 perfectly :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them
 across ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang
 didenormalise dulu dari table2 yg terkait
 etc






 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com
  



Re: [JUG-Indonesia] ETL Tool

2010-03-05 Terurut Topik Hendry Luk
Hmm ok.. kalimat gw misleading. It should read: gw gak familiar sama
options yg ada di java, karna itu gw survey kemari buat nyari tau tool yg
mainstream di kalangan jugger, instead of nyari2 sendiri di google n end up
dengan random tool yg nyeleneh n gak ada yg pake.

Dan lightweight as in gw gak perlu tool yg overkill karna cuma buat simple
tasks ajah. Mainly karna susah for a team to justify masukin another weapons
grade toolset buat ke dalem project cuma buat ngetackle trivial tasks.

And thanks anyway buat suggestionnya pake kettle.

On Thu, Mar 4, 2010 at 11:07 PM, Feris Thia feris.mi...@phi-integration.com
 wrote:



 Lightweight = 2KB, 10MB, 20MB in package size ? Non Java ? Mainstream ?
 Atau non XML ?

 Requirementnya keren juga ya. how about creating your own ETL ? Or
 using Unix batch script ? Or Windows Power Shell ? Comes out of the box with
 the OS :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Not sure kalo kettle is lightweight enough buat dipake tanpa bring along
 the whole pentaho stack. Kinda keen buat tau option laen yg ngetop di
 kalangan Jugger. Gw gak familiar sama stacks di java... n gw gak mo pake
 random tool yg gw ketemu di google n pake non-mainstream tool yg gak ada
 orang laen yg pake.


  



Re: [JUG-Indonesia] ETL Tool

2010-03-05 Terurut Topik Henry Suryawirawan
mungkin bisa juga cobain JasperETL ato Talend
walau gue gak pernah cobain buat requirements yg kompleks spt Pak Feris ;-)
ada GUI designer nya juga kok

2010/3/4 Feris Thia feris.mi...@phi-integration.com



 For this, I think Kettle is very lightweight and will have the jobs done
 perfectly :)

 Regards,

 Feris

 2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them
 across ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang didenormalise
 dulu dari table2 yg terkait
 etc


  



Re: [JUG-Indonesia] ETL Tool

2010-03-04 Terurut Topik Hendry Luk
I think lu got it all wrong...  :P
I said gw benci SSIS so much, n at no point would I consider ssis enak
dipake, dan to be honest, i dont give a shit about its graphical tool ;)

Dan gw sekarang lagi nyari etl tool buat java platform, bukan ms.

Xml.., well, kayak di original question, gw *prefer* kalo ada yg non-xml
(e.g. python) tapi gak ketemu so far, makanya gw nanya kemari, karna gw
assumed non-xml was default preference buat most people. Well, kalo emang
cuma xml yg available, tool apa yg kalian prefer so far?
From the tone of ur post, gw assume lu suggest kettle.

Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
lightweight tasks. Task2 semacem.:
- process semua rows dari outgoing sms di database ke file, ftp them across
ke system laen
- process semua nomer telpon yang diactivate sepanjang hari ke standard IPND
files buat diprocess for law n regulatory purposes
- process transaction data regularly buat diupdate ke reporting tables
- archive data harian ke database laen di archive box, yang didenormalise
dulu dari table2 yg terkait
etc

Not sure kalo kettle is lightweight enough buat dipake tanpa bring along the
whole pentaho stack. Kinda keen buat tau option laen yg ngetop di kalangan
Jugger. Gw gak familiar sama stacks di java... n gw gak mo pake random tool
yg gw ketemu di google n pake non-mainstream tool yg gak ada orang laen yg
pake.

2010/3/3 sm96 syaiful.mukh...@gmail.com



 kalo gak mau ada xml, jangan pernah pake kettle atawa pentaho data
 integration.
 padahal performa kettle sendiri untuk transformasi yg lumayan kompleks
 lumayan bagus, even dia pake xml.
 apalagi kalo maunya pake tools m$ punya, SSIS, graphical toolnya bagus, dan
 enak banget dipakenya,
 tapi jangan lupa, dia ini bagus-bagus juga tetep pake xml, dan performanya
 juga bagus.
 jangan pake barang ginian juga, karena dia masih pake xml.
 bagaimana yg lain? ternyata masih pake xml.
 aku sedang ngelirik spring batch mungkin bisa diadaptasi untuk etl tools.
 kalo saran saya, jangan pake spring batch juga, seperti kita tahu, spring
 batch sendiri configure masih pake xml.
 jadi yah, jangan pake spring batch juga, karena dia pake xml.
 
 
 ...



 On Tue, Mar 2, 2010 at 7:00 PM, Hendry Luk hendrym...@gmail.com wrote:



 Well, bukan requirement sih, tapi which one yg provide the most pleasing
 experience in term of nulis ETL scriptnya. It's quite unbelievable bahwa
 mereka semua milih pake XML, considering XML is possibly the worst way ever
 buat ngescript ETL logics (loop, condition, etc), dibanding misalnya pake
 python script ato java code.
 Ok, given the limitation of xml, dari sekian banyak etl tools yg
 available, so far yang mana yg kalian biasa pake, yg ringkas n gampang buat
 dipake n dimanage? In short, yg mana yg kalian suggest?


 Well OOT regarding sentimen gw against xml yg mungkin perlu gw clarify...
 In general gw prefer tool/framework stack yg minim xml-config karna xml is a
 big mess to work with. Misalnya ant/maven, terlalu banyak noise-per-signal
 dibanding rake/bake script yg jauh lebih ringkas n manageable. Ato IoC
 config, ringkas pake binsor ato fluent-interface yg cuma butuh few lines
 dibanding berlembar2 xml config di spring. JSTL n velocity juga bikin gatel
 dibanding templating engine laen kayak plain jsp ato brail. Dan finally,
 ETL, pas di .net gw ada HORRENDOUS experience dengan SSIS! Yang setelah itu
 hidup gw jauh lebih indah dengan Rhino-ETL yang pake phyton-like script.
 Dan kalo gw mesti pick 3 areas dimana xml mesti dijadiin crime adalah:
 rule-engine, build-tool, dan ETL... karna naturenya yang lebih cocok ditulis
 sebagai script daripada sebagai xml structure. Xml-config cuma ok pas
 mulai2, terus selalu degrade jadi unmanageable mess kalo dah mulai grow
 dengan berbagai deep conditional logic dan iterations :(
 The world would be a much wonderful place without nuclear weapon and xml
 config.

 On Mon, Mar 1, 2010 at 1:39 PM, sm96 syaiful.mukh...@gmail.com wrote:



 kalo requirementnya seperti itu,
 berarti tidak ada.
 sementara etl tools ada banyak sekali.

 On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak
 involve XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml
 dimana2 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta




 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com





 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com
  



Re: [JUG-Indonesia] ETL Tool

2010-03-04 Terurut Topik Feris Thia
Lightweight = 2KB, 10MB, 20MB in package size ? Non Java ? Mainstream ? Atau
non XML ?

Requirementnya keren juga ya. how about creating your own ETL ? Or
using Unix batch script ? Or Windows Power Shell ? Comes out of the box with
the OS :)

Regards,

Feris

2010/3/4 Hendry Luk hendrym...@gmail.com

 Not sure kalo kettle is lightweight enough buat dipake tanpa bring along
 the whole pentaho stack. Kinda keen buat tau option laen yg ngetop di
 kalangan Jugger. Gw gak familiar sama stacks di java... n gw gak mo pake
 random tool yg gw ketemu di google n pake non-mainstream tool yg gak ada
 orang laen yg pake.


Re: [JUG-Indonesia] ETL Tool

2010-03-04 Terurut Topik Feris Thia
For this, I think Kettle is very lightweight and will have the jobs done
perfectly :)

Regards,

Feris

2010/3/4 Hendry Luk hendrym...@gmail.com

 Btw gw gak butuh full stack BI solution, cuma buat beberapa regular
 lightweight tasks. Task2 semacem.:
 - process semua rows dari outgoing sms di database ke file, ftp them across
 ke system laen
 - process semua nomer telpon yang diactivate sepanjang hari ke standard
 IPND files buat diprocess for law n regulatory purposes
 - process transaction data regularly buat diupdate ke reporting tables
 - archive data harian ke database laen di archive box, yang didenormalise
 dulu dari table2 yg terkait
 etc



Re: [JUG-Indonesia] ETL Tool

2010-03-03 Terurut Topik sm96
kalo gak mau ada xml, jangan pernah pake kettle atawa pentaho data
integration.
padahal performa kettle sendiri untuk transformasi yg lumayan kompleks
lumayan bagus, even dia pake xml.
apalagi kalo maunya pake tools m$ punya, SSIS, graphical toolnya bagus, dan
enak banget dipakenya,
tapi jangan lupa, dia ini bagus-bagus juga tetep pake xml, dan performanya
juga bagus.
jangan pake barang ginian juga, karena dia masih pake xml.
bagaimana yg lain? ternyata masih pake xml.
aku sedang ngelirik spring batch mungkin bisa diadaptasi untuk etl tools.
kalo saran saya, jangan pake spring batch juga, seperti kita tahu, spring
batch sendiri configure masih pake xml.
jadi yah, jangan pake spring batch juga, karena dia pake xml.


...


On Tue, Mar 2, 2010 at 7:00 PM, Hendry Luk hendrym...@gmail.com wrote:



 Well, bukan requirement sih, tapi which one yg provide the most pleasing
 experience in term of nulis ETL scriptnya. It's quite unbelievable bahwa
 mereka semua milih pake XML, considering XML is possibly the worst way ever
 buat ngescript ETL logics (loop, condition, etc), dibanding misalnya pake
 python script ato java code.
 Ok, given the limitation of xml, dari sekian banyak etl tools yg available,
 so far yang mana yg kalian biasa pake, yg ringkas n gampang buat dipake n
 dimanage? In short, yg mana yg kalian suggest?


 Well OOT regarding sentimen gw against xml yg mungkin perlu gw clarify...
 In general gw prefer tool/framework stack yg minim xml-config karna xml is a
 big mess to work with. Misalnya ant/maven, terlalu banyak noise-per-signal
 dibanding rake/bake script yg jauh lebih ringkas n manageable. Ato IoC
 config, ringkas pake binsor ato fluent-interface yg cuma butuh few lines
 dibanding berlembar2 xml config di spring. JSTL n velocity juga bikin gatel
 dibanding templating engine laen kayak plain jsp ato brail. Dan finally,
 ETL, pas di .net gw ada HORRENDOUS experience dengan SSIS! Yang setelah itu
 hidup gw jauh lebih indah dengan Rhino-ETL yang pake phyton-like script.
 Dan kalo gw mesti pick 3 areas dimana xml mesti dijadiin crime adalah:
 rule-engine, build-tool, dan ETL... karna naturenya yang lebih cocok ditulis
 sebagai script daripada sebagai xml structure. Xml-config cuma ok pas
 mulai2, terus selalu degrade jadi unmanageable mess kalo dah mulai grow
 dengan berbagai deep conditional logic dan iterations :(
 The world would be a much wonderful place without nuclear weapon and xml
 config.

 On Mon, Mar 1, 2010 at 1:39 PM, sm96 syaiful.mukh...@gmail.com wrote:



 kalo requirementnya seperti itu,
 berarti tidak ada.
 sementara etl tools ada banyak sekali.

 On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta




 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


Re: [JUG-Indonesia] ETL Tool

2010-03-03 Terurut Topik Feris Thia
Yup... setuju,

Jangan pake Kettle deh... karena dengan Kettle kita bisa :
1. Belajar I/O dengan sangat baik, bagaimana mengelola / meng-scale dari
mulai Harddisk I/O, RDBMS engine tuning, memory tuning, dll. Load balancing
antara semua aspect tersebut lah :)
2. Menghasilkan throughput 24.000-an record/ second dari transformasi dan
kejadian locking yang sudah sangat kompleks dengan memanfaatkan penuh
kemampuan driver. Yap, Anda tidak salah dengar !!! Driver sangat berpengaruh
!! Bahkan sampai 8-folds !
3. Bisa generate nested ETL script, dan demikian mampu menghasilkan
transformasi yang sangat sulit dilakukan dengan hanya design by the book /
standard.
4. Membantu melakukan simple forensik data dengan cepat karena banyaknya
steps yang included

Regards,

Feris

2010/3/3 sm96 syaiful.mukh...@gmail.com

 kalo gak mau ada xml, jangan pernah pake kettle atawa pentaho data
 integration.
 padahal performa kettle sendiri untuk transformasi yg lumayan kompleks
 lumayan bagus, even dia pake xml.



Re: [JUG-Indonesia] ETL Tool

2010-03-02 Terurut Topik Hendry Luk
Aah, graphical tool.. Will check that out thanks.
Kadang kalo terlalu banyak choice (di google) jadi bingung milih. So just
wanted buat nyari tau, de-facto conventionnya most jugger pada prefer pake
yg mana berdasarkan past experience.
Cheers

2010/3/1 Feris Thia feris.mi...@phi-integration.com



 Yup. Hanya Kettle jg berbasis XML jadi ga masuk hitungan kali. hehehe

 Bingung juga kok ada req seperti itu ya? Di PHI kita bisa memecahkan
 masalah ETL yang sangat sulit dengan cara ETL generate ETL dan
 kemudian dieksekusi on the fly :)

 Regards,

 Feris


 On 3/1/10, Ifnu bima ifnub...@gmail.com ifnubima%40gmail.com wrote:
  Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak
 involve
  XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
  like we were in 1990s.
  ETL apa yg u would suggest?
 
  Kettle, bagian dari pentahoo, ;)
 
  http://pentaho.phi-integration.com/kettle
 
 
  --
 
 
  http://ifnu.artivisi.com
  +62 856 9211 8687
  regards
 
  



Re: [JUG-Indonesia] ETL Tool

2010-03-02 Terurut Topik Hendry Luk
Well, bukan requirement sih, tapi which one yg provide the most pleasing
experience in term of nulis ETL scriptnya. It's quite unbelievable bahwa
mereka semua milih pake XML, considering XML is possibly the worst way ever
buat ngescript ETL logics (loop, condition, etc), dibanding misalnya pake
python script ato java code.
Ok, given the limitation of xml, dari sekian banyak etl tools yg available,
so far yang mana yg kalian biasa pake, yg ringkas n gampang buat dipake n
dimanage? In short, yg mana yg kalian suggest?


Well OOT regarding sentimen gw against xml yg mungkin perlu gw clarify... In
general gw prefer tool/framework stack yg minim xml-config karna xml is a
big mess to work with. Misalnya ant/maven, terlalu banyak noise-per-signal
dibanding rake/bake script yg jauh lebih ringkas n manageable. Ato IoC
config, ringkas pake binsor ato fluent-interface yg cuma butuh few lines
dibanding berlembar2 xml config di spring. JSTL n velocity juga bikin gatel
dibanding templating engine laen kayak plain jsp ato brail. Dan finally,
ETL, pas di .net gw ada HORRENDOUS experience dengan SSIS! Yang setelah itu
hidup gw jauh lebih indah dengan Rhino-ETL yang pake phyton-like script.
Dan kalo gw mesti pick 3 areas dimana xml mesti dijadiin crime adalah:
rule-engine, build-tool, dan ETL... karna naturenya yang lebih cocok ditulis
sebagai script daripada sebagai xml structure. Xml-config cuma ok pas
mulai2, terus selalu degrade jadi unmanageable mess kalo dah mulai grow
dengan berbagai deep conditional logic dan iterations :(
The world would be a much wonderful place without nuclear weapon and xml
config.

On Mon, Mar 1, 2010 at 1:39 PM, sm96 syaiful.mukh...@gmail.com wrote:



 kalo requirementnya seperti itu,
 berarti tidak ada.
 sementara etl tools ada banyak sekali.

 On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta




 --
 syaiful.mukhlis
 gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com
  



Re: [JUG-Indonesia] ETL Tool

2010-03-02 Terurut Topik sm96
pake kettle, biarpun pake xml, tapi gak pernah sentuh sama sekali itu xml
files.
why bother with xml?

2010/3/1 Feris Thia feris.mi...@phi-integration.com



 Yup. Hanya Kettle jg berbasis XML jadi ga masuk hitungan kali. hehehe

 Bingung juga kok ada req seperti itu ya? Di PHI kita bisa memecahkan
 masalah ETL yang sangat sulit dengan cara ETL generate ETL dan
 kemudian dieksekusi on the fly :)

 Regards,

 Feris

 On 3/1/10, Ifnu bima ifnub...@gmail.com ifnubima%40gmail.com wrote:
  Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak
 involve
  XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
  like we were in 1990s.
  ETL apa yg u would suggest?
 
  Kettle, bagian dari pentahoo, ;)
 
  http://pentaho.phi-integration.com/kettle
 
 
  --
 
 
  http://ifnu.artivisi.com
  +62 856 9211 8687
  regards
 
  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


Re: [JUG-Indonesia] ETL Tool

2010-03-01 Terurut Topik sm96
ini masalah pribadi, gak ada hubungannya dengan teknologi.
silahkan aja, suka-suka masing-masing pribadi anda-anda semua.
hehehe

2010/3/1 dir dir sikerasa...@gmail.com



 Boleh tanya mengapa anda benci XML dalam kaitan nya dengan
 ETL? apa problem yang anda hadapi sampai anda tidak menyukainya?

 Dir


 On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta


  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com


Re: [JUG-Indonesia] ETL Tool

2010-03-01 Terurut Topik Feris Thia
Yup. Hanya Kettle jg berbasis XML jadi ga masuk hitungan kali. hehehe

Bingung juga kok ada req seperti itu ya? Di PHI kita bisa memecahkan
masalah ETL yang sangat sulit dengan cara ETL generate ETL dan
kemudian dieksekusi on the fly :)

Regards,

Feris

On 3/1/10, Ifnu bima ifnub...@gmail.com wrote:
 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?

 Kettle, bagian dari pentahoo, ;)

 http://pentaho.phi-integration.com/kettle


 --


 http://ifnu.artivisi.com
 +62 856 9211 8687
 regards



[JUG-Indonesia] ETL Tool

2010-02-28 Terurut Topik Hendry Luk
Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
like we were in 1990s.
ETL apa yg u would suggest?
Ta


Re: [JUG-Indonesia] ETL Tool

2010-02-28 Terurut Topik Ifnu bima
 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve XML 
 (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2 like we 
 were in 1990s.
 ETL apa yg u would suggest?

Kettle, bagian dari pentahoo, ;)

http://pentaho.phi-integration.com/kettle


--


http://ifnu.artivisi.com
+62 856 9211 8687
regards


Re: [JUG-Indonesia] ETL Tool

2010-02-28 Terurut Topik dir dir
Boleh tanya mengapa anda benci XML dalam kaitan nya dengan
ETL? apa problem yang anda hadapi sampai anda tidak menyukainya?

Dir


On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta
  



Re: [JUG-Indonesia] ETL Tool

2010-02-28 Terurut Topik sm96
kalo requirementnya seperti itu,
berarti tidak ada.
sementara etl tools ada banyak sekali.

On Mon, Mar 1, 2010 at 7:31 AM, Hendry Luk hendrym...@gmail.com wrote:



 Guys, ada yang bisa suggest ETL tool di java? Preferably yang gak involve
 XML (I hate XMLs). Gw baru checked out scriptella, tapi pake xml dimana2
 like we were in 1990s.
 ETL apa yg u would suggest?
 Ta
  




-- 
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com gtalk%3asyaiful.mukh...@gmail.com