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

tGoogleAnalyticsManagement

5.1 jlolling 2015-01-24
153

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).

NEW: Provides output flows for the user permissions to accounts, web properties and views.
The schemas has been changed (some additional columns added). Therefore please remove the component from your job and add it again. Unfortunately I do not know any other way to force the Studio to accept a new fixed defined schema.

Please read the linked documentation to get more information.

Component

tVerticaBulkExecAdv

1.0 gpogliani 2015-01-20
12

Component

tVerticaOutputBulkAdv

1.0 gpogliani 2015-01-20
5

Component

tVerticaOutputBulkExecAdv

1.0 gpogliani 2015-01-20
5

Enhancement to standard Talend 5.4.1 Vertica component (designed to work with 6.x version of Vertica) to handle advanced options of COPY function. It uses the driver v7.1.1./n/rThe component is dependent to tVerticaBulkExec and tVerticaOutputBulk components./n/r

Component

tGoogleAnalyticsUnsampledReports

2.0 jlolling 2015-01-18
31

This component managed un-sampled reports for Google Analytics.
It can only be used with a Google Analytics Premium Account.
It is recommended to take care the reports needs to be treated this way because the quotas for un-sampled reports are much lower than for normal reports.
It is a good practice to run the report first as normal reports with tGoogleAnalyticsInput and check the sampling state and decide which reports needs to run as un-sampled reports.
Un-sampled reports are treated in an asynchronous process. Everything whats necessary to do the steps are build-in in this component, except the download of the files. Please us the new component tGoogleDrive to do this.

Please read the linked documentation. The procedure is a bit complex!

In case of questions feel free to contact me: jan.lolling@gmail.com

Component

tGoogleAnalyticsInput

5.0 jlolling 2015-01-18
374

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 have the report definition in a database table or configuration file.

Component

tMustache

1.0.2 gcat 2015-01-16
10

Component

tElasticsearchIndex

1.0.3 gcat 2015-01-16
26

Component

tJobInstance_component_collection

4.1 jlolling 2015-01-15
333

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

tGoogleDrive

1.3 jlolling 2015-01-08
42

This component manages files and folders on a Google Drive.
It has various operational modes to:
- upload a file (also with set permissions to other users)
- download a file
- list files (with filtering)
- get the properties of a file/folder
- move files
- delete files

Especially for the usage in conjunction with tGoogleAnalyticsUnsampledReports this component provides the same authentication methods as for the Google Analytics and is able to work directly with file-Ids.

Please refer the linked documentation.
For questions and suggestions please contact me: jan.lolling@gmail.com
Please do not use the rating function to post questions.

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
70

Other Swedish personnummer regexps do not take into account that at Swedish universities, foreigners might get special temporary personnummers with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Regex

Istat Code

4.0 mhallam 2014-07-29
174

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
248

-98.092391

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

Regex

Currency 16,3

4.0 mhallam 2014-07-29
82

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
183

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
84

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
86

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
139

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
121

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
188

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.

D* Demo Model


  • Author: ctoum
  • Categories: Data-Model
  • First revision date: 2010-08-13
  • Latest revision date: 2010-08-13
  • Compatible with: Master Data Management releases 4.0.2, 4.0.3
  • Downloads: 797

About: Model used in the D* Demo.

Revision list

expand/collapse all

Revision 1.0 797 Downloads, Released on 2010-08-13
Download revision 1.0

Compatible with: 4.0.3, 4.0.2

DStar model

Reviews (1)

 Review By Bernardo Silva on March 25, 2013
Review
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



55 ms