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


1.8 jlolling 2014-09-19

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.



2.1 jlolling 2014-09-19

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.



1.2 jlolling 2014-09-17

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.



1.8 jlolling 2014-09-12

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.


tJobInstance* component collection

3.3 jlolling 2014-09-12

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.



1.0 tfoldi 2014-09-11

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



2.1 jlolling 2014-09-09

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



2.4.0 dqsh_uniserv 2014-09-04

todo description



1.0 Lesego 2014-08-28



1.8 jlolling 2014-08-27

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

Average Length With Null For SQL Server Storing Large

  • Author: yyi
  • Categories: Indicator
  • First revision date: 2012-06-12
  • Latest revision date: 2012-06-12
  • Compatible with: Data Quality releases 5.0.0, 5.0.0M2, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.0.1, 5.0.2, 5.1.0, 5.1.0M2, 5.1.0RC1, 5.1.1
  • Downloads: 22

About: Computes the average length of the field, counting null data as zero length values, the text filed type should be ntext or text in Microsoft SQL Server.

Revision list

expand/collapse all

Revision 1.0 22 Downloads, Released on 2012-06-12
Download revision 1.0

Compatible with: 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2

Related to http://jira.talendforge.org/browse/TDQ-5030

Reviews (0)

Be the first to review this extension!


Submit review
Please select your rating*

Version Author Released on Rating Downloads

Product Demo

3.0 ctoum 2012-05-31

Product & families, with Cafepress pictures.


Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22

This is a model of the basic of the Janus Clinical Data Repository.


D* Demo Model

1.0 ctoum 2010-08-13

Model used in the D* Demo.


Talendshop Demo

1.0 ctoum 2010-08-04

Talendshop Demo (Demo Project)

247 ms