Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


Version Author Released on Rating Downloads

tGoogleGeocoder

0.61 llaen 2014-11-24
350

This component takes an address from the input flow and appends lat and lon columns to the output flow for the address. Google\\\\\\\\\\\\\\\'s geocode API is used to look up the latitude and longitude for the address.

Started with the original tGoogleGeocoder component but rewritten for API v3.
It also supports business API (given a client and private key strings).

Instructions:
The input row must have at least one column that contains an address. Select that column in the components \\\\\\\"Address Column\\\\\\\" variable.
The output is the same as the input but with two new columns added (lat and lon) which will contain the latitude and longitude coordinates that Google gave for the input address.

Component

tFileFetchEnhanced

1 Steven_Crawford 2014-11-20
6

This component extends Talend\'s tFileFetch to introduce support for RAW Body types on HTTP POST\'s. (This means you can send JSON, XML, or whatever)

I also exposed the PostMethod and HTTPClient objects as global variables (access with component name with suffix \'_METHOD\' and \'_CLIENT_STREAM\' respectively).
The purpose for this was to provide support for closing the client after finishing with the input. I ran into an issue where the sockets weren\'t closed properly when iterating over hundreds/thousands of API calls.

Component

tOracleAQConnection

1.1 tmallek 2014-11-19
4

tOracleAQConnection est un composant qui se connecte � une queue oracle.

Component

tFileExcelWorkbookOpen

6.6 jlolling 2014-11-17
496

This component open an existing Excel workbook or creates a new one.
This component is the basis for all other tFileExcel* component.
It uses the latest Apache POI API 3.10 final and recognise the kind of workbook by the file name, it is not necessary to decide at start which kind of document you want to load.
The component has an option to use the xml parser already loaded by the JDK or Runtime or the parser shipped with the component (advanced settings). This should solve incompatibility problems.

Component

tFileExcelSheetInput

6.5 jlolling 2014-11-15
247

This component depends on tFileExcelWorkbookOpen.
It can read an excel sheet in a very flexible way:
Configure the column position by a header line (also with regex)
Can auto fill empty cell with the last none empty value
Can read comments and hyperlinks
Can handle formulas correctly
Can use cached values in case of formula evaluation fails (e.g. external files are referenced) -> see in the advanced options

(Please update the component tFileExcelWorkbookOpen if you update this component!)

Component

tMustache

1.0.2 pklalitjha 2014-11-10
103

This component is for using Mustache template in Talend flow. This takes Mustache template (content as String) as argument and uses rows as parameters for template execution.

This applies template on data in rows and outputs template output and all data in row, to continue the flow. Template can be any valid Mustache template, so it can transform rows into HTML, JSON or any other format.

Column names in schema must be same as variables in template.

Mustache template for producing JSON:
{
\"id\":{{id}},
\"key\":\"{{key1}}\",
\"child\":{
\"key\":\"{{key2}}\",
\"grandchild\":\"{{key3}}\",
\"array\":[{{id}},\"{{key4}}\",\"{{key5}}\"]
}
}
And, schema has id, key1, key2, key3, key4 and key5 columns, all randomly generated.

This produced JSON as:
{ \"id\":96, \"key\":\"ZvEWMb\", \"child\":{ \"key\":\"eXIwbJ\", \"grandchild\":\"7DvrDc\", \"array\":[96,\"Kukaxs\",\"Ox1sWo\"] }}

Can write complex Mustache template for complicated output.

Sample usecase can be:
1. Elegant email body.
2. Rich HTML/JSON or other textual format output.
.....
See sample jobs and and tutorial for more detail.

Component

tYoutubeAnalyticsInput

1.4 jlolling 2014-11-04
46

This component collect analytics data for YouTube.
It uses the latest Google API to collect the data.
The setup of the account and authorisation is not trivial.
Please take a look at the documentation linked here.
Many thanks to Alvaro for sharing ideas and test support.

New API revision used
Documentation improved with more information how to configure and hints in case of problems.

Component

Xmi

EXmi andrymalala 2014-10-27
8

Component

tReplace

tReplace andrymalala 2014-10-27
25

Component

tExecutors

1.0 jpcb 2014-10-26
12

About: This is a component for Talend Open Studio to run multiple thread.

Source Code:
https://github.com/jpcb/tExecutors

Report an Issue:
https://github.com/jpcb/tExecutors/issues

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
58

Other Swedish personnummer regexps do not take into account that at Swedish universities, foreigners might get special temporary personnummers with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Regex

Istat Code

4.0 mhallam 2014-07-29
164

22.12.0|18.24.C||22.12_D|12.56| 1A.56.1

This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004

Regex

Longitude Validation

4.0 mhallam 2014-07-29
233

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code

Regex

Currency 16,3

4.0 mhallam 2014-07-29
71

Currency expression, accepts 4 commas and 4 groups of 3 numbers and 1 number before the first comma, this first number will have to be different from zero. It accepts a number of, two or three decimal. It accepts zero numbers after the point. You can change the number of groups and numbers accespts before and after the point.

Regex

Random email

2.0 scorreia 2014-07-29
168

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
72

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
76

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
127

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
109

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
175

This regular expression not only checks if the postal code is five digits long. The second digit must not be zero, because a postal code like 00123 is invalid.

Product Demo


  • Author: ctoum
  • Categories: Export
  • First revision date: 2011-05-18
  • Latest revision date: 2012-05-31
  • Compatible with: Master Data Management releases 4.2.0, 4.2.0M1, 4.2.1, 4.2.2, 5.0.0, 5.0.0M1, 5.0.0M2
  • Downloads: 668

About: Product & families, with Cafepress pictures.

Revision list

expand/collapse all

Revision 3.0 255 Downloads, Released on 2012-05-31
Download revision 3.0

Compatible with: 5.0.0

The MDM Product Demo project can help you start with Talend Master Data Management.
Discover how to setup and configure the features of Talend Master Data Management via meaningful samples.

Revision 2.0 269 Downloads, Released on 2011-07-29
Download revision 2.0

Compatible with: 5.0.0, 5.0.0M2, 5.0.0M1, 4.2.2, 4.2.1, 4.2.0

New revision for 4.2 compatibility

Revision 1.0 144 Downloads, Released on 2011-05-18
Download revision 1.0

Compatible with: 4.2.0M1

Initial revision.

Reviews (3)

 get starting By zaoweiruan on March 25, 2013
thanks for share learning
 Great start By mbalkenende on August 25, 2011
This is a great start with Data Quilty and MDM processes. Make sure you have the recent patches.

MDM 5.0 By  on March 25, 2013
Hi mbalkenende, Will u please guide me for MDM A to Z. bcoz im new to this field. i dowloaded talend MDM 5.0. Thanks in advance.
 sa By jamikorn on July 20, 2011
excellent
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



82 ms