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.


Show

Category
Search
Version
Author
 

Statistics

  • 627 extensions
  • 952 revisions
  • 304 contributors
  • 164539 downloads
 

Top Contributors

Version Author Released on Rating Downloads

tGoogleGeocoder

0.61 llaen 2014-11-24
349

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
3

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

Component

tFileExcelWorkbookOpen

6.6 jlolling 2014-11-17
491

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
245

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
99

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
43

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
10

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

Show

Category
Search
Version
Author
 

Statistics

  • 143 extensions
  • 207 revisions
  • 38 contributors
  • 18792 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Indicator

EMail validation via mail server

5.4/5.3 mzhao 2013-06-03
687

This Java UDI check emails by sending a SMTP request to mail server. the code sample can be found at: http://www.rgagnon.com/javadetails/java-0452.html

Indicator

Frequency table of hours

2.0 scorreia 2013-04-25
428

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Indicator

Sample Standard Deviation

1.1 scorreia 2013-04-25
338

This indicator computes the sample standard deviation of any numerical column

Indicator

Variance

1.1 scorreia 2013-04-25
308

This indicator computes the variance of numeric columns

Indicator

Trimmed

1.0 scorreia 2013-04-25
102

evaluate the number of data which are correctly trimmed

Indicator

Week Frequency

2.0 scorreia 2013-04-25
338

aggregates Date fields into weeks

Indicator

Duplicate Rows

2.0 scorreia 2013-04-25
920

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Indicator

Length Range Frequency

1.1 scorreia 2013-04-25
178

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Indicator

Order of Magnitude

1.1 scorreia 2013-04-25
176

measure the order of magnitude of numerical data

Indicator

phone_area_code_freq

1.0 scorreia 2013-04-24
67

Area codes of American phone numbers

Show

Category
Search
Version
Author
 

Statistics

  • 5 extensions
  • 7 revisions
  • 4 contributors
  • 4170 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
668

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
435

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
775

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1152

Talendshop Demo (Demo Project)


54 ms