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

  • 608 extensions
  • 920 revisions
  • 295 contributors
  • 157789 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Component

tGoogleAnalyticsMCFInput

1.8 jlolling 2014-09-19
17

This component collects data from the Google Analytics Multi Channel Funnel API.
Please take a look at the documentation inside.
For questions and suggestions please please do not use the rating function. Instead contact me directly or use the Forum.

Component

tGoogleAnalyticsInput

2.1 jlolling 2014-09-19
79

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.

Component

tCalendar

1.2 jlolling 2014-09-17
60

Data warehouses needs a date dimension and this component creates the most of the needed data (also fully localised).
The schema of this component is fully commented.
The main features are:
* creates all possible date categories like day, week, month, year, quarter
* builds integer id for all categories to support a table as dimension
* supports different years (year for the current week and a financial year)
* build automatically a configurable amount of days in the future.

Component

tRunTask

1.8 jlolling 2014-09-12
48

This component can trigger task in the Talend Administration Center.
It helps to create sophisticated job chains because you can detect in the unlimited flexibility the necessary events or parameters to start a task in the TAC.
With the help of this component you can avoid deploying \"monster\" jobs containing all jobs needed in a complex task. You simply deploy all necessary jobs as tasks and starts them with a another job.
You can stop the \"trigger\" job and all currently running task will finishes they work without being interrupted.

Component

tJobInstance* component collection

3.3 jlolling 2014-09-12
51

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

tTableauTriggerSchedule

1.0 tfoldi 2014-09-11
7

This component can trigger Tableau Server\'s schedule directly from any platform. It does not depend on tabcmd and written in pure java.

Component

tDB2TemporalMergeELT

2.1 jlolling 2014-09-09
12

This component is an ELT usage of the DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.
Temporal tables are a native Slowly Changing Dimension Type 2 implementation (with bi-temporal means you have a business time period and a system time period for the validity of your data).
This component create and run all necessary statement to:
create tables (actual data and history data)
create indices
merge or the date from the source table (insert, update and delete)
managing the versioning

Component

tUniservCDHInput

2.4.0 dqsh_uniserv 2014-09-04
6

todo description

Component

tGoogle

1.0 Lesego 2014-08-28
0

Component

tPostgresqlTableTransfer

1.8 jlolling 2014-08-27
7

This component is dedicated to transfer the table content from one database to another database.
The component can truncate the target table before.
This component does not care about schema differences. All columns existing in source and target table will be transferred, all other ignored. The necessary schema will be created internally, therefore you have to provide only the source and target table name, thats it.
The component uses asynchronous transfer to half the duration because reading and writing can take place at the same time (or overlapping).

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
10

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
154

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
324

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
122

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
123

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
129

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
336

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
191

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
100

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
77

match regular text with punctuation correctly placed.

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
629

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
410

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
750

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1133

Talendshop Demo (Demo Project)


97 ms