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.


Version Author Released on Rating Downloads
Component

tClickBankOrders

1.1 clickbank 2010-08-25
180

A component to aid in the development of accessing the ClickBank Orders Api. To use the ClickBank api, you must have a vendor or affiliate account at ClickBank, and you must create api developer and clerk keys. The component has all the orders api methods readily available, and allows you to add parameters in a table. The output includes three variables in one row. The first is request body, which is formated in json or xml, depending on which output type you select. The second is an error string if one exists, and the third is the http status code. To learn more about the ClickBank Orders api and the methods available please visit: http://www.clickbank.com/help/account-help/account-tools/clickbank-api/

For a list of methods represented in the Method drop down see:
https://api.clickbank.com/rest/1.2/orders

Component

tClickBankTickets

1.0 clickbank 2010-08-25
55

A component to aid in the development of accessing the ClickBank Tickets Api. To use the ClickBank api, you must have a vendor or affiliate account at ClickBank, and you must create api developer and clerk keys. The component has all the tickets api methods readily available, and allows you to add parameters in a table. The output includes three variables in one row. The first is request body, which is formated in json or xml, depending on which output type you select. The second is an error string if one exists, and the third is the http status code. To learn more about the ClickBank Tickets api and the methods available please visit: http://www.clickbank.com/help/account-help/account-tools/clickbank-api/

For a list of methods represented in the Method drop down see:
https://api.clickbank.com/rest/1.2/tickets

Component

bvrVATNumberCheck

1.0 wbvreeuwijk 2010-08-24
146

This component checks and validates a VATNumber from the following european countries:

AT-Austria
BE-Belgium
BG-Bulgaria
CY-Cyprus
CZ-Czech Republic
DE-Germany
DK-Denmark
EE-Estonia
EL-Greece
ES-Spain
FI-Finland
FR-France
GB-United Kingdom
HU-Hungary
IE-Ireland
IT-Italy
LT-Lithuania
LU-Luxembourg
LV-Latvia
MT-Malta
NL-The Netherlands
PL-Poland
PT-Portugal
RO-Romania
SE-Sweden
SI-Slovenia
SK-Slovakia

The component takes the VATNumber and the country code either in ISO2 or ISO3 code.

Component

hiNameProcessing

2.1 wbvreeuwijk 2010-08-24
293

The Human Inference Name Processing component gives you the ability to split names into their name elements. So the name "ing. Bas W.B. van Reeuwijk" will be split into

QualificationPreceding: ing.
GivenNames: Bas
GivenNamesInitial: W.B.
SurnamePrefixFirst: van
SurnameFirst: Reeuwijk

The component supports the following countries: Netherlands, Belgium, France, Germany and United Kingdom. It allows you to check the gender of a person and whether it is a person or an organisation.

Requirements: Access to a Human Inference server, Human Inference java connector.

Notes on usage:

1) The reliability code gives a reliability status of (1 = correct, 2 = doubtfull, 3 = probably incorrect)
2) The resultcodes of the standardisation are put into a string in the form of
[code1]|[remark1]|[message1];[code2]|[remark2]|[message2];...;[codeN]|[remarkN]|[messageN]; It is therefore recommended to use the tNormalize and tExtractDelimited to get all the details out of the standardisation (see screenshot)
3) Out of one name multiply rows can be generated when the name passed to the component contains more than one name.

Job

tsort_on_disk

0.1 gatigossou 2010-08-10
106

To sort the huge volume of data, you will often need to use the advanced parameters of tsort component to sort data on disk. This job shows an example of configuration to sort about 5 000 000 of records. The jvm arguments are setted to -Xms256M -Xmx1548M

Job

generate_parent_line

01 gatigossou 2010-08-09
121

Suppose you have a certain hierarchy
if XX.YY.ZZ exists, than XX and XX.YY should be there, too.

This job show how to generate parent line.

Job

validateAddress

0.3 mchapman 2010-08-05
245

This is a sample job to use the tValidateAddress component

Component

tValidateAddress

0.3 mchapman 2010-08-05
343

Uses the FREE Postcode Anywhere web service to Validate an Address. This component accepts a full address and returns the Confidence Rank and Confidence rating.

See Postcode Anywhere web site for documenation.

Component

bcAggregateRow

1.0 bcourtine 2010-07-29
138

This component is an evolution of tAggregateRow (from TOS 4.0.2).

It add 3 boolean aggregation functions : AND, OR, XOR. Theses aggregations require that both input and output columns have a boolean type.

Job

IMPORT ORACLE FROM CSV

1.0 mhallam 2010-07-22
268

job import a table in oracle database from flat file CSV
very simple job

tOracleObjectList


  • Author: vstoyak
  • Categories: SQL
  • First revision date: 2011-11-17
  • Latest revision date: 2011-11-17
  • Compatible with: Data Quality releases 4.2.3, 5.0.0, 5.0.0M1, 5.0.0M2, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3
  • Downloads: 96

About: tOracleTableList component has a limitation that it not able to retrieve List of Views, Procedures, etc. tOracleObjectList meant to solve this issue.

Revision list

expand/collapse all

Revision 1.0 96 Downloads, Released on 2011-11-17
Download revision 1.0

Compatible with: 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.3

Initial Version

Reviews (0)

Be the first to review this extension!

 

Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
720

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
458

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
804

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1168

Talendshop Demo (Demo Project)


245 ms