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
Routine

BRules

1.6 walkerca 2014-07-30
853

A collection of Java routines for validation, formatting, and logic for use in Talend Open Studio

Software license: Apache License, Version 2.0

http://www.apache.org/licenses/LICENSE-2.0

Component

Elasticsearch Indexing

1.0.3 pklalitjha 2014-07-29
183

Elasticsearch Indexing Talend Custom Component
================================================
Often, we need full text search support in our application along with analytics. Having a component will allow indexing created/updated along with
data loaded in warehouse. So, I have created a component for indexing (create/update) for Elasticsearch. Elasticsearch, is distributed, open source,
full text engine built on top of Lucene. It is well documented, supports REST API over JSON and many other native language API for indexing and querying.

NOTE: To support add or update, at least one field in schema must be designated as key to identify rows as unique. Multiple columns can be designated as key (in case of composite primary keys).

Updated extension to fix compatibility issues with 1.x version of Elasticsearch. Removed dependent jars (lucne-core and elasticsearch), so now need to add them from Elasticsearch distribution. Also reduced download size from 10MB to 15KB.

Elasticsearch v1.2+ works with JDK 7+, so if elasticsearch version is 1.2+ then use JDK 7 u25/55/65 (recommended by ES) as this component is using elasticsearch Java API and corrosponding lucene core jar.

Added support for configuring cluster name in v1.0.3

Component

tGanttChart

0.2 bennatigiuliano 2014-07-24
4

This component allows you to generate a Gantt Graph.

Component

tJobInstanceStart+tJobInstanceEnd+tJobDataRangeScanner

3.0 jlolling 2014-07-20
13

These 3 components 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
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

tFileExcelSheetOutput

6.4 jlolling 2014-07-14
45

This component depends on tFileExcelWorkbookOpen.
It can create/fill sheets on a very flexible way:
It can set the header with self defined content
It can write columns with gaps
It can copy styles, conditional styles, row height
It can reconfigure written tables to update pivot tables
Please take a look in the documentation linked here. This component is very powerful while using excel templates.

Component

tPLotChart

0.1 bennatigiuliano 2014-07-11
5

This component allows you to generate Plot Graph.

Component

tUnpivotRow

1 wzawwin 2014-07-09
28

tGoogleGeocoder

0.6 llaen 2014-07-07
274

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

tFileExcelSheetCellOutput

6.3 jlolling 2014-07-03
18

This component writes into referenced cells in a sheet.
It depends on the component tFileExcelWorkbookOpen and tFileExcelWorkbookSave.
The component takes the cell reference and the values / comments from an input flow (simplest way is using a tFixedFlowInput if the reference are fix.

Component

tCalendar

1.1 jlolling 2014-07-01
33

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.

Version Author Released on Rating Downloads
Regex

Istat Code

4.0 mhallam 2014-07-29
139

22.12.0|18.24.C||22.12_D|12.56| 1A.56.1

This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004

Regex

Longitude Validation

4.0 mhallam 2014-07-29
210

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code

Regex

Currency 16,3

4.0 mhallam 2014-07-29
50

Currency expression, accepts 4 commas and 4 groups of 3 numbers and 1 number before the first comma, this first number will have to be different from zero. It accepts a number of, two or three decimal. It accepts zero numbers after the point. You can change the number of groups and numbers accespts before and after the point.

Regex

Random email

2.0 scorreia 2014-07-29
143

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
52

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
57

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
104

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
89

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
154

This regular expression not only checks if the postal code is five digits long. The second digit must not be zero, because a postal code like 00123 is invalid.

Regex

Training export

0.1 cathyc 2014-06-10
9

Training export

Product Demo


  • Author: ctoum
  • Categories: Export
  • First revision date: 2011-05-18
  • Latest revision date: 2012-05-31
  • Compatible with: Master Data Management releases 4.2.0, 4.2.0M1, 4.2.1, 4.2.2, 5.0.0, 5.0.0M1, 5.0.0M2
  • Downloads: 595

About: Product & families, with Cafepress pictures.

Revision list

expand/collapse all

Revision 3.0 219 Downloads, Released on 2012-05-31
Download revision 3.0

Compatible with: 5.0.0

The MDM Product Demo project can help you start with Talend Master Data Management.
Discover how to setup and configure the features of Talend Master Data Management via meaningful samples.

Revision 2.0 250 Downloads, Released on 2011-07-29
Download revision 2.0

Compatible with: 5.0.0, 5.0.0M2, 5.0.0M1, 4.2.2, 4.2.1, 4.2.0

New revision for 4.2 compatibility

Revision 1.0 126 Downloads, Released on 2011-05-18
Download revision 1.0

Compatible with: 4.2.0M1

Initial revision.

Reviews (3)

 get starting By zaoweiruan on March 25, 2013
thanks for share learning
 Great start By mbalkenende on August 25, 2011
This is a great start with Data Quilty and MDM processes. Make sure you have the recent patches.

MDM 5.0 By  on March 25, 2013
Hi mbalkenende, Will u please guide me for MDM A to Z. bcoz im new to this field. i dowloaded talend MDM 5.0. Thanks in advance.
 sa By jamikorn on July 20, 2011
excellent
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



55 ms