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