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

Top Contributors

Version Author Released on Rating Downloads
Component

tFileFetchEnhanced

1 Steven_Crawford 2014-11-20
3

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
1

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

Component

tFileExcelWorkbookOpen

6.6 jlolling 2014-11-17
479

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
236

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

Top Contributors

Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
13

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
159

validates minutes:seconds format

Validates 3:56, 59:59,...
Does not validate 60:59 or 59:60.

SQL

hotmail email

2.0 scorreia 2014-05-26
346

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
131

Postal Code format verfication (Netherlands)

Matches
9999AA|9999 AA
Non Matches
9999aa|9999Aa|9999 aa|9999 aA

Regex

Dutch Phone Number

2.0 fcweeber 2014-05-26
128

Phone Number format verfication (Netherlands)

Local: Dutch Phonenumber format is area code (3 or 4 digits), phone number ( 7 or 6 digits) - total length (10 digits)
International: country code 0031 and then remove zero from area code
Matches
0031121234567|+31123123456|0121234567|012-1234567|0123-123456
Non Matches
012 1234567|1234567
match 02.31.23.45.67.22 or 004923123467223

Regex

Names with unicode characters

2.0 scorreia 2014-05-26
135

Match people names with unicode characters.
Matches Jean-Marc, Jørn, Mc\'Neelan, Pz. López
Does not match I.B.M.

Regex

FR Phone Number (parenthesis allowed)

2.0 scorreia 2014-05-26
358

match French phone numbers in several format:
matches:
0033 1 47 25 00 00
+33 1 47 25 00 00
(33) 1 47 25 00 00
0033147250000
01-47-25-00-00
01 47 25 00 00
Does not match
0147 250 000

Regex

Email Address (with list of top-level domains)

2.0 mzhao 2014-05-26
215

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
114

match regular text

matches regular text such as \"hello Jean-Baptiste\".
does not match text with any special character such as \"# num\", \"test;\"

Regex

Text

2.0 scorreia 2014-05-26
87

match regular text with punctuation correctly placed.

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)


79 ms