Database - eWeek

Database: LABS GALLERY: Talend Open Studio Eases ETL Chores


Talend Open Studio 3.1 is an open-source application that smooths the design and execution of data integration projects. The Talend Open Studio ETL (extraction, trasformation and loading) tool inherits a familiar graphical interface from the Eclipse platform on which it's built, and enables users to get off to a quick start through the provision of a broad range of data source components.

 
  • A Familiar Interface
    Since Talend Open Studio is based on Eclipse, I found its interface familiar from the first time I fired it up.
  • File Metadata
    With the product's New Delimited File wizard, I made short work of mydata-source-tweaking chores.
  • Job Design Canvas
    I dragged my data source and target components onto the product's jobdesign canvas.
  • Job Statistics
    While my jobs ran, I could watch as that product's rows, rows-per-second and elapsed-time indicators marked the flow of my test data.
  • Database Connections
    I could choose from 31 different types of database connections, which included a full range of database products as well as generic ODBC and JDBC connections.
  • Database Settings
    I modified a few settings for the database output element, indicating, for instance, that TOS should create a new table to receive the data.
  • Data in Place
    After importing my campaign data from my CSV files to MySQL, I confirmed that the records had arrived safely.
  • SQL Builder
    I used the product's SQL Builder to pick out subsets of my data for further processing or migration.
  • tMap Element
    The product's tMap component allowed me to map particular columns from my database to a SugarCRM Web service, while transforming certain columns en route.
xڽZ[s۸~~d_nw7ŗXbwIHB ,JVeSjy|8oi&4oAuB>K9lHbc.!KvfzC7o``ƛVYQ|v$UK*7-;RLDL1OwҨxLO^>.B࿎F:|=F#mX021q #yF.#An{R7Yh[((6j{A،LQLDruzH&$fvȿ+|>o~QLg\M<4#9 "L7'f*Ή{'_tt6g4Wln(3сױ1,?ۈnS3aܰ)M)vtZ4ܪwP臑WhNdm\)I;-<><:1)+Vʢ M&x9tKS:f:bLÃnF1>PC ';!{0#p\V5Ra5G\攪1O|؈{G{(a(;}eq+)P0nC-U̥zU\Ɋn'p` Ձ ^2R`-*T հq셜Þݙo&)?>d R_E!*aR= ׼>Iqv* .[1aCuTD,O4͌3Ky W&?׀c:sBrZ)ĺQĴdv-[9Ϛ 7s.9n ٝօrI/ ah~I%_zlgŎvjf]ffSO0[h>\ !I$STؖN ik'?aWyQq& XR?Ó,)uN~t@|@>c/1)rd|>s\MbSH;{$+}7icqD8 +9 (< ^0ZV {7VeLt"dY> "6#h9p\+ɻtqO@"f.[㑙CB0e_.Ն^ovﶍ#+𫄐Х$^Xr:= vA͘wsN%!JfI+knsqeQapS#Z7>g67c 3O#$vjڧDw% vӂֽWˆלWestOuO~)\9c.4ga-q a cp+)=jѤ:>*7p}SUA^8/VK@V ncFјfTT>g_Y#xO3+(XP.u1sgֽ]0? V|țjUxמo4g{l qEig`oiXI%k#׉x`+,B!S]OLmSgNVӪ2讞]BU:m-.U3g`GG*ar;LmTkqء9j[Xo2cQ JvV_ܔ&˼C]`I`z#p7PD'RMApuPy#y&յy8$Pc.kEb oDz j*cnW~#Z3H䈘 M؞(.D-bt7")th8ɗn &5 ;όF)xp98R.'2]([yw~ޑZuU )RX^c݆̪f;OY*@Λ5`(3<>яv&NXyB)@ SPpxdMADfTaz8ak`9 &*nZS4,PB qٓu"fˆI^KerDdTǪl or AmkB Cs.)(iͩu ?YdbPds[6d$ͺ4X9X؅$ wwv3]»C.0x` acmA4sǑg,Rm.!?^>qL玩&G \01cX{}=+rx>qekZFEbp\|rvP~|x{/: L"s}{zap'xtOO{Wp QXa,m7:~y3Ne`)7}x/\t| Zh3Ow?7mXΊF+c+Ѩ~=ŴYI2UeTF,7vZFSƼ ܟ.^: w%16:tq@N㭲P ƫJڄ>,