LEADER 04812nam 2200637Ia 450 001 9910786478803321 005 20200520144314.0 010 $a1-283-83673-4 010 $a1-84951-473-9 035 $a(CKB)2670000000278977 035 $a(EBL)1069748 035 $a(OCoLC)818847571 035 $a(SSID)ssj0000791306 035 $a(PQKBManifestationID)11476299 035 $a(PQKBTitleCode)TC0000791306 035 $a(PQKBWorkID)10758615 035 $a(PQKB)10952965 035 $a(Au-PeEL)EBL1069748 035 $a(CaPaEBR)ebr10627286 035 $a(CaONFJC)MIL414923 035 $a(CaSebORM)9781849514729 035 $a(MiAaPQ)EBC1069748 035 $a(PPN)228000467 035 $a(EXLCZ)992670000000278977 100 $a20111102d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aGetting started with Talend Open Studio for dita Integration$b[electronic resource] /$fJonathan Bowen 205 $a1st edition 210 $aBirmingham $cPackt Publishing$d2012 215 $a1 online resource (321 p.) 300 $aIncludes index. 311 $a1-84951-472-0 327 $aCover; Copyright; Credits; Foreword; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Knowing Talend Open Studio; What Talend Open Studio is; Use cases; History of Talend Open Studio; Benefits of Talend Open Studio; Installing Talend Open Studio; Prerequisites; Installation guide; Other useful software; Text editor; MySQL; Sample jobs and data; Summary; Chapter 2: Working with Talend Open Studio; Studio definitions; Starting the Studio; Tour of the Studio; The Repository; The design workspace; The Palette; Configuration tabs 327 $aOutline and Code panelsCreating a new project; Creating an example job; Metadata; Summary; Chapter 3: Transforming Files; Transforming XML to CSV; Transforming CSV to XML; Maps and expressions; Advanced XML output for complex XML structures; Working with multi-schema XML files; Enriching data with lookups; Extracting data from Excel files; Extracting data from multiple sheets; Joining data from multiple sheets; Summary; Chapter 4: Working with Databases; Database metadata; Extracting data from a database; Extracts from multiple tables; Joining within the database component 327 $aJoining outside the database componentWriting data to a database; Database to database transfer; Modifying data in a database; Dynamic database lookup; Summary; Chapter 5: Filtering, Sorting, and Other Processing Techniques; Filtering data; Simple filter; Filter and rejects; Filter and split; Sorting data; Aggregating data; Normalizing and denormalizing data; Data normalization; Data denormalization; Extracting delimited fields; Find and replace; Sampling rows; Summary; Chapter 6: Managing Files; Managing local files; Copying files; Copying and removing files; Renaming files; Deleting files 327 $aTime-stamping a fileListing files in a directory; Checking for files; Archiving and unarchiving files; FTP file operations; FTP Metadata; FTP Put; FTP Get; FTP File Exist; FTP File List and Rename; Deleting files on an FTP server; Summary; Chapter 7: Job Orchestration; What is a subjob?; A simple subjob; On Subjob Error; On Component OK; Run If; Jobs as subjobs; Iterating and looping; Iterate connections; ForEach loop; Loop ""n"" times; Infinite loop; Duplicating and merging dataflows; Duplicating data; Merging data; Summary; Chapter 8: Managing Jobs; Job versions 327 $aExporting and importing jobsExporting jobs; Exporting a project; Exporting a job; Exporting a job for execution; Importing jobs; Importing a project; Importing a job; Scheduling jobs; Summary; Chapter 9: Global Variables and Contexts; Global variables; Studio global variables; User defined global variables; Contexts; Embedded context variables; Repository context variables; External context variables; Complex context variables; Using embedded, repository, and external contexts; Summary; Chapter 10: Worked Examples; Product catalog; Data import from the ERP system 327 $aData iImport from Fabric Fashions 330 $aA practical cookbook on building portals with GateIn including user security, gadgets, and every type of portlet possible. 606 $aData integration (Computer science) 606 $aDatabase management 615 0$aData integration (Computer science) 615 0$aDatabase management. 676 $a005.74 700 $aBowen$b Jonathan$01578609 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910786478803321 996 $aGetting started with Talend Open Studio for dita Integration$93858175 997 $aUNINA