Vai al contenuto principale della pagina
Autore: | Bowen Jonathan |
Titolo: | Getting started with Talend Open Studio for dita Integration [[electronic resource] /] / Jonathan Bowen |
Pubblicazione: | Birmingham, : Packt Publishing, 2012 |
Edizione: | 1st edition |
Descrizione fisica: | 1 online resource (321 p.) |
Disciplina: | 005.74 |
Soggetto topico: | Data integration (Computer science) |
Database management | |
Note generali: | Includes index. |
Nota di contenuto: | 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 tabs |
Outline 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 | |
Joining 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 | |
Time-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 | |
Exporting 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 | |
Data iImport from Fabric Fashions | |
Sommario/riassunto: | A practical cookbook on building portals with GateIn including user security, gadgets, and every type of portlet possible. |
Titolo autorizzato: | Getting started with Talend Open Studio for dita Integration |
ISBN: | 1-283-83673-4 |
1-84951-473-9 | |
Formato: | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione: | Inglese |
Record Nr.: | 9910786478803321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |