Talend Tutorial

This Talend tutorial provides basic information about installing the data integration tool, designing Talend jobs, and utilizing Talend components. Please use hyperlinks in this Talend tutorial page to see the example of each element along with the screenshots.

Talend has various software products that offer data integration, cloud integration, data governance, big data, etc. Talend is most famous for its open-source data integration platform, also called the Talend Open Studio for Data Integration.

Generally, the company won’t get the data in the required format to make any decision against that. So, they need a tool to clean or transform the data to make business decisions. Talend is one of the most emerging tools to perform all the required operations with hassle-free!. In this Talend tutorial, we cover most of the ETL components to clean or transform the data and store it in a database.

Talend Introduction

This Talend tutorial section covers the User Interface and basics. We also shown the necessary connection required to load or read from SQL Server.

  1. Download and Install Data Integration tool
  2. Create a Business Model
  3. How to create Talend Job
  4. Create a Global Context Group
  5. Connecting to SQL Server
  6. Connect to Database using Context Group

Talend Data Loading

The Talend data integration tool needs some data to perform transformations. In this Talend chapter, we read data from most of the sources that we use in real-time. Furthermore, it covered the ways to export data from Talend to various destinations.

  1. Read Excel File
  2. Read Text File
  3. Load Excel Data into Database Table
  4. Load Text File Data into Database
  5. Export Database Table to Excel
  6. How to export Database Table to JSON
  7. Export Database Table to Text File
  8. Export Database Table to XML

Talend Transformations Tutorial

This Talend tutorial section covers most of the available components.

  1. Talend tSortRow
  2. tAggregateRow
  3. tAggregateSortedRow
  4. tBufferInput and tBufferOutput
  5. tCreateTable
  6. tConvertType – Datatype Conversion
  7. Type Conversion using tMap
  8. tDenormalize
  9. tDBRow – Execute SQL Queries
  10. tFileList
  11. tFilterColumns
  12. tFilterRow
  13. Filter rows using tMap
  14. tFixedFlowInput
  15. tForeach
  16. tFuzzyMatch
  17. tLoop
  18. tMap Joins
  19. tJoin
  20. tMap Lookup
  21. tJava
  22. tJavaRow
  23. tJavaFlex
  24. tMsgBox
  25. tNormalize
  26. Pivot Columns
  27. Parent Child Job
  28. tRowGenerator
  29. tReplace
  30. tReplicate
  31. tRunJob
  32. tSampleRow
  33. tDBSCD – SCD Example
  34. SCD Type 2 Manual
  35. tUnite
  36. tUniqueRow
  37. Capture Rejected Rows
  38. Read Multi-Structured File