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
  • 951 revisions
  • 304 contributors
  • 164277 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Component

tFileFetchEnhanced

1 Steven_Crawford 2014-11-20
4

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
2

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

Component

tFileExcelWorkbookOpen

6.6 jlolling 2014-11-17
483

This component open an existing Excel workbook or creates an 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
238

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
97

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
41

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
23

Component

tExecutors

1.0 jpcb 2014-10-26
8

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

Component

tTransferDatabase

1.4 jpcb 2014-10-26
736

Allows transfer one database engine to another database engine using the library apache ddlutils.

The component supports the following list of database

*DB2
*Firebird
*HSQLDB
*Interbase
*MaxDB
*MySql
*Oracle
*PostgreSQL
*SQL Server
*Sybase

Source Code:
https://github.com/jpcb/ddlutils
https://github.com/jpcb/transferdatabase
https://github.com/jpcb/tTransferDatabase

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

Show

Category
Search
Version
Author
 

Statistics

  • 143 extensions
  • 207 revisions
  • 38 contributors
  • 18789 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
337

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
  • 4164 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
667

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
433

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
774

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1150

Talendshop Demo (Demo Project)


82 ms