Talend Open Studio is the world’s leading open source data integration solution that enables rapid development of data transformation processes using an intuitive drag-and-drop user interface.
Talend Open Studio Cookbook contains a host of techniques, design patterns, and tips and tricks, based on real-life applications, that will help developers to become more effective in their use of Talend Open Studio.
Chapter 1, Introduction and General Principles, introduces some of the key principles for Talend development and explains how to install the provided code examples.
Chapter 2, Metadata and Schemas, shows how to build and make use of Talend data schemas.
Chapter 3, Validating Data, demonstrates different methods of validating input data and handling invalid data.
Chapter 4, Mapping Data, shows how to map, join, and filter data from input to output in both batch and real-time modes.
Chapter 5, Using Java in Talend, introduces the different methods for extending Talend functionality using Java.
Chapter 6, Managing Context Variables, illustrates the different methods for handling context variables and context groups within Talend projects and jobs.
Chapter 7, Working with Databases, provides insight into reading from and writing to a database, generating and managing surrogate keys, and managing database objects.
Chapter 8, Managing Files, covers a mix of techniques for reading and writing different file types including header and trailer processing. It also includes methods for managing files.
Chapter 9, Working with XML, Queues, and Web Services, covers tools and techniques for real-time/web service processing including XML, and reading and writing to services and queues.
Chapter 10, Debugging, Logging, and Testing, demonstrates the different methods for finding problems within Talend code, and how to log status and issues and techniques for generating test data.
Chapter 11, Deployment and Scheduling Talend Code, introduces the Talend executable and parameters, as well as managing job dependencies.
Chapter 12, Common Mistakes and Other Useful Hints and Tips, contains valuable tools and techniques that don’t quite fit into any of the other chapters.
Appendix A, Common Type Conversions, is a useful table containing the methods for converting between Talend data types.
Appendix B, Management of Contexts, is a in-depth discussion as to the pros and cons of the various methods for managing project parameters, and what types of projects the different methods are suited to.
To attempt the exercises in this book, you will need the following software
The latest version of Talend Studio for ESB. At the time of writing, this was 5.3
The latest version of MySQL
Microsoft Office Word & Excel or other compatible office software.
It is also recommended that you find a good text editor, such as Notepad++.
This book is intended for beginners and intermediate Talend users who have a basic working knowledge of the Talend Open Studio software, but wish to know more.
In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.
Talend component names, variable names, and code snippets that appear in text are shown like this: “open the tFlowToIterate component”
A block of code is set as follows:
if ((errorCode & (1<<3)) > 0) {
System.out.println("age is null");
}
if ((errorCode & (1<<4)) > 0) {
System.out.println("countryOfBirth is empty");
}When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:
XMLUtils.addChildAtPath(customerXML, "/customer /orders/order[orderId = "+((Integer)globalMap.get ("order.orderId"))+"]", input_row.itemXML);
New terms and important words are shown in bold.Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: “ Click on Finish to import all the Talend artifacts”.
Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.
To send us general feedback, simply send an e-mail to <[email protected]>, and mention the book title via the subject of your message.
If there is a topic that you have expertise and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.
Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.
You can download the example code files for all Packt books you have purchased from your account at http://www.packtpub.com. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files e-mailed directly to you.
Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.
Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.
Please contact us at <[email protected]> with a link to the suspected pirated material.
We appreciate your help in protecting our authors, and our ability to bring you valuable content.
You can contact us at <[email protected]> if you are having a problem with any aspect of the book, and we will do our best to address it.