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