04812nam 2200637Ia 450 991078647880332120200520144314.01-283-83673-41-84951-473-9(CKB)2670000000278977(EBL)1069748(OCoLC)818847571(SSID)ssj0000791306(PQKBManifestationID)11476299(PQKBTitleCode)TC0000791306(PQKBWorkID)10758615(PQKB)10952965(Au-PeEL)EBL1069748(CaPaEBR)ebr10627286(CaONFJC)MIL414923(CaSebORM)9781849514729(MiAaPQ)EBC1069748(PPN)228000467(EXLCZ)99267000000027897720111102d2012 uy 0engur|n|---|||||txtccrGetting started with Talend Open Studio for dita Integration[electronic resource] /Jonathan Bowen1st editionBirmingham Packt Publishing20121 online resource (321 p.)Includes index.1-84951-472-0 Cover; 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 tabsOutline 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 componentJoining 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 filesTime-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 versionsExporting 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 systemData iImport from Fabric FashionsA practical cookbook on building portals with GateIn including user security, gadgets, and every type of portlet possible.Data integration (Computer science)Database managementData integration (Computer science)Database management.005.74Bowen Jonathan1578609MiAaPQMiAaPQMiAaPQBOOK9910786478803321Getting started with Talend Open Studio for dita Integration3858175UNINA