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

  • 616 extensions
  • 929 revisions
  • 306 contributors
  • 167079 downloads
 

Top Contributors

Version Author Released on Rating Downloads
Component

tNetSuiteInput

0.1 muthu@tooltopia.com 2014-12-16
2

NetSuiteInput

Component

tFileOutputPDF

1.0 muthu@tooltopia.com 2014-12-16
7

FileOutputPDF

Job

JOB_ORACLE_AQ_DEMO

2.0 amallek 2014-12-15
21

Job décrivant la méthode d’utilisation des composant tOracleAQxxxxx.
OracleAQConnection, tOracleAQSubscriber et tOracleAQMessage.

Les composants tOracleAQxxxxx (tOracleAQConnection , tOracleAQSubscriber , tOracleAQMessage) servent à se connecter à une fil d’attente (queue) Oracle et reste à l’écoute de cette dernière en attendant un message.
J’aurais pus créer en une seule composante, mais je l’ai divisé en trois parties pour qu’ils soient utile lors d’une exécution en parallèles, on peut faire plus qu’un seule abonnement à la fois.
J’ai aussi faire des paramètres avancés pour que le composant ne se termine pas en erreur en cas d une anomalie ( connexion à la base par exemple). C’est pour avoir la possibilité de reboucler et de retenter la connexion à la queue comme décri dans le job démo.

Component

tOracleAQReadMessages

1.0 amallek 2014-12-15
1

tOracleAQReadMessages is a component that reads from a subscription to a Queue ORACLE.

Component

tOracleAqConnectionToSubscriber

1.0 amallek 2014-12-15
1

tOracleAqConnectionToSubscriber is a component that connects to the ORACLE waiting Queuq, and it remains to the listening of a subscription of the Queuq

Hadoop Configuration

Cloudera CDH 5.2.X

1.0 rdubois 2014-12-12
4

Custom hadoop configuration which allows connecting to a Cloudera CDH5.2.X cluster.

Component

tGSpreadsheetInput

1.0 igonzals 2014-12-03
11

Component

tDB2TemporalMergeELT+tDB2TemporalDeleteELT

3.0 jlolling 2014-12-02
54

This package contains 2 components:
tDB2TemporalMergeELT
tDB2TemporalDeleteELT

These components supports the ELT usage of the IBM DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.

Please refer to the linked documentation!

tDB2TemporalMergeELT create and updates temporal tables.
tDB2TemporalDeleteELT performs temporal deletes.
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).

tGoogleGeocoder

0.61 llaen 2014-11-24
408

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
19

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.

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
14

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
162

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
353

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
135

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
133

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
138

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
364

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
225

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
118

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
96

match regular text with punctuation correctly placed.

Show

Category
Search
Version
Author
 

Statistics

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

Top Contributors

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
685

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
449

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
787

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1158

Talendshop Demo (Demo Project)


87 ms