Blog

Q. What is the full name of Talend? Talend Open Studio Q. What is Talend Open Studio? Talend Open Studio for Data Integration is an open source data integratio…

My tab is missing If you find that, say, your Run job or context tab has gone missing, perhaps as a result of you accidentally closing them, then there are two…

Processing multiple files at once Often, with batch processes, it is required that multiple FILES are processed by the same job in a single tranche. This examp…

Adding a HEADER AND TRAILER to a file Let us look at how to add a custom header, footer to file. This is often required for file processing and validation. Re…

Printing your input query If your result set isn’t as expected and you are struggling to understand why, then it is really useful to be able to see the QUERY t…

The database support allows you to read and write from databases using a map. To use the database support, you must first import the database using the Import m…

Using contexts and variables Variables represent values which change throughout the execution of a program. A global variable is a system variable which can be…

Creating a context group A context group is a set of (usually) related context variables for use within a project. This recipe shows how to create a new contex…

Creating PSEUDO COMPONENTS using tJavaFlex Function tJavaFlex enables you to enter a personalized code in order to integrate it in TALEND program. With tJavaFl…

Filtering : Function tFilterRow filters input rows by setting conditions on the selected columns. Purpose tFilterRow helps parameterizing filters on the sourc…

Using the TERNARY OPERATOR : tMap expression cannot be more than a single line of Java code. This means that we cannot use the normal if-then-else logic to tes…

Creating validation rules for more complex requirements Validation rules restrict what users can enter in a given field, and also help ensure that your databas…

Often, when running a schedule, it is necessary to execute a mixture of TALEND AND NON-TALEND OBJECTS, such as database scripts, batch files, or shell scripts. …

Returning a value from a child Job to the parent Job You may need to return a value or rows from a child Job to the parent Job for certain use. Let us see the …

Deployment & Scheduling Now that you’ve written your Job and executed it within the Talend Designer, it’s time to DEPLOY YOUR JOB to Test or Production (depend…

Testing Logic is probably the most-used job design in TALEND PROGRAMMING, and is used to ensure that a snippet of new code is not influenced by external factors…

Creating simple test data using tRowGenerator This recipe shows how tRowGenerator allows dummy data to be created for test purposes. Getting ready Open the…

Printing out the context Getting ready Open the jo_cook_ch10_0080_tContextDump job. How to do it… The steps for printing out the context are as follows: …

Using the Talend debug mode – row-by-row execution This recipe will show how we can find Talend data issues by watching the data as it flows between components…

Introduction When our code eventually runs as a production job, it is expected that it will be robust, reliable, and bug free. For this to happen, it will usua…

Calling a WEB SERVICE In this article, we will show the following two use cases of how to call a Web service using a tWebserviceInput component Calling a pu…

Working with XML XML is the eXtensible Markup Language and is both human and machine readable. XML is a form of Electronic Data Interchange. Here, let us creat…

Moving, copying, renaming, and deleting FILES AND FOLDERS As well as reading from and writing to files, TALEND has a set of components that allow developers to…

This segment contains recipes that show some of the techniques used to read and write data to files. It also contains recipes that show techniques to MANAGE FIL…

Managing database sessions DATABASE SESSIONS allow the developer to control how and when the data is committed to a database. This recipe shows how this is ach…

This segment contains recipes that show some of the techniques used to read and write data to databases. It also contains recipes that show techniques to manage…

When developing jobs in Talend, it’s sometimes necessary to run them on different environments. For other business cases, you need to pass values between multip…

Java is a hugely popular and incredibly rich programming language. Talend is a Java Code Generator which makes use of many open source Java libraries, so this m…

Joining data using tMap tMap is more powerful in terms of FUNCTIONALITY. 1. tMap can have many outputs links. 2. With tMap we can use the expression on the co…

The tMap component Function tMap is an advanced component, which integrates itself as plugin to Talend Studio. Purpose tMap transforms and routes data from si…

Talend Open Studio for Data Quality enables you to analyze the content of one or multiple columns and execute the created analyses using the Java or the SQL eng…

Data integration is an urgent challenge for today’s businesses, driven by sharp growth in the volume and diversity of data generated by daily operations and by …

This segment contains a detailed discussion about METADATA AND TALEND SCHEMAS and recipes that highlight some of the less used / less known features associated …

Introduction to Talend Talend is an open source software for Data Integration that is quickly becoming an alternative to expensive ETL tools in the BI space. T…

This tutorial gives you an overview and talks about the fundamentals of Talend. WHAT IS TALEND? Today’s IT landscape is increasingly complex, with enterprise …