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

  • 625 extensions
  • 944 revisions
  • 302 contributors
  • 161961 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Component

Xmi

EXmi andrymalala 2014-10-27
5

Component

tReplace

tReplace andrymalala 2014-10-27
11

Component

tExecutors

1.0 jpcb 2014-10-26
4

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
695

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

Component

tGoogleAnalyticsManagement

3.1 jlolling 2014-10-22
51

This component uses the Management API to collect all available items for your account like web property, profiles, segments and goals (also with URL destination steps and event conditions).
NEW: provides an output flow with describing information about all available dimensions and metrics (all columns).

Please read the linked documentation to get more information.

Component

tGoogleAnalyticsInput

3.1 jlolling 2014-10-22
149


This component uses the latest Google Analytics API.
Please take a look at the documentation provided as PDF file.
It can use a service account (which is the preferred method to authorise) or a personal account but this needs more manual interaction.
NEW: Provides normalised outputs to support generic jobs for Google Analytics. Please refer to the updated and improved documentation about the details and scenarios.
This new feature allows to ave the report definition in a database table or configuration file.

Component

tFileOutputOdb

0.5 bennatigiuliano 2014-10-17
193

This component allows you to execute an Insert into SQL tables on OpenOffice.org database files (.odb) Adding of functionnalities : Update/Delete based on keys columns to define Sql Where clauses, + a cleaning function when .odb file is corrupted by a Sql error.

Component

tMustache

1.0.1 pklalitjha 2014-10-13
84

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

tJobInstance* component collection

3.4 jlolling 2014-10-11
141

These 4 components:
- tJobInstanceStart
- tJobInstanceEnd
- tJobDataRangeScanner
- tJobInstanceLiveCheck
are dedicated to manage job monitoring.
These components provides following features:
* Creates an job instance Id to mark the datasets for data lineage
* holds all necessary information about a job run in a table
* keeps all context variables in a table (at the job start and its end)
* keeps as much as needed counters from the job
* provides incremental loads
* provides a lot of key figures about the last job run
* keeps the error messages from the job in the status table
* enables Log4J for the job with various outputs
* Provides maximum memory usage tracking

Please refer the linked documentation
The release 3.0 needs slightly changed tables!
Please contact me in case of questions and do not use the rating function to post questions.

Component

tUniservCDHResynchronise

2.4.0 dqsh_uniserv 2014-10-10
6

tUniservCDHResynchronise allows Talend jobs to read modified records from Smart Customer MDM that has previously been loaded using tUniservCDHOutputBulk in order to resynchronise your data source.

Uniserv Smart Customer MDM combines technologies, processes and services to provide a 360° customer view covering all areas and channels. By matching the customer data existing in each part of your systems, identifying and removing duplicates, and forming a Golden Record we create a comprehensive, unambiguous, and absolutely up-to-date view of your customers.

To be able to use the tUniservCDHResynchronise component, the Smart Customer MDM software must be configured.

The component has its own GUI and requires an additional plugin. Please contact Uniserv for download information.

For more information on Smart Customer MDM, visit http://www.uniserv.com/en/solutions/smart-customer-mdm/

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
11

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
156

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
334

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
126

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
124

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
132

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
351

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
209

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
111

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
83

match regular text with punctuation correctly placed.

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
647

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
427

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
769

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1147

Talendshop Demo (Demo Project)


57 ms