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

tOracleAQConnection

1.1 tmallek 2014-11-19
15

tOracleAQConnection est un composant qui se connecte � une queue oracle.

Component

tFileExcelWorkbookOpen

6.6 jlolling 2014-11-17
594

This component open an existing Excel workbook or creates a new one.
This component is the basis for all other tFileExcel* component.
It uses the latest Apache POI API 3.10 final and recognise the kind of workbook by the file name, it is not necessary to decide at start which kind of document you want to load.
The component has an option to use the xml parser already loaded by the JDK or Runtime or the parser shipped with the component (advanced settings). This should solve incompatibility problems.

Component

tFileExcelSheetInput

6.5 jlolling 2014-11-15
310

This component depends on tFileExcelWorkbookOpen.
It can read an excel sheet in a very flexible way:
Configure the column position by a header line (also with regex)
Can auto fill empty cell with the last none empty value
Can read comments and hyperlinks
Can handle formulas correctly
Can use cached values in case of formula evaluation fails (e.g. external files are referenced) -> see in the advanced options

(Please update the component tFileExcelWorkbookOpen if you update this component!)

Component

tMustache

1.0.2 pklalitjha 2014-11-10
128

This component is for using Mustache template in Talend flow. This takes Mustache template (content as String) as argument and uses rows as parameters for template execution.

This applies template on data in rows and outputs template output and all data in row, to continue the flow. Template can be any valid Mustache template, so it can transform rows into HTML, JSON or any other format.

Column names in schema must be same as variables in template.

Mustache template for producing JSON:
{
\"id\":{{id}},
\"key\":\"{{key1}}\",
\"child\":{
\"key\":\"{{key2}}\",
\"grandchild\":\"{{key3}}\",
\"array\":[{{id}},\"{{key4}}\",\"{{key5}}\"]
}
}
And, schema has id, key1, key2, key3, key4 and key5 columns, all randomly generated.

This produced JSON as:
{ \"id\":96, \"key\":\"ZvEWMb\", \"child\":{ \"key\":\"eXIwbJ\", \"grandchild\":\"7DvrDc\", \"array\":[96,\"Kukaxs\",\"Ox1sWo\"] }}

Can write complex Mustache template for complicated output.

Sample usecase can be:
1. Elegant email body.
2. Rich HTML/JSON or other textual format output.
.....
See sample jobs and and tutorial for more detail.

Component

tYoutubeAnalyticsInput

1.4 jlolling 2014-11-04
63

This component collect analytics data for YouTube.
It uses the latest Google API to collect the data.
The setup of the account and authorisation is not trivial.
Please take a look at the documentation linked here.
Many thanks to Alvaro for sharing ideas and test support.

New API revision used
Documentation improved with more information how to configure and hints in case of problems.

Component

Xmi

EXmi andrymalala 2014-10-27
18

Component

tReplace

tReplace andrymalala 2014-10-27
39

Component

tExecutors

1.0 jpcb 2014-10-26
20

About: This is a component for Talend Open Studio to run multiple thread.

Source Code:
https://github.com/jpcb/tExecutors

Report an Issue:
https://github.com/jpcb/tExecutors/issues

Component

tTransferDatabase

1.4 jpcb 2014-10-26
760

Allows transfer one database engine to another database engine using the library apache ddlutils.

The component supports the following list of database

*DB2
*Firebird
*HSQLDB
*Interbase
*MaxDB
*MySql
*Oracle
*PostgreSQL
*SQL Server
*Sybase

Source Code:
https://github.com/jpcb/ddlutils
https://github.com/jpcb/transferdatabase
https://github.com/jpcb/tTransferDatabase

Report an Issue:
https://github.com/jpcb/tTransferDatabase/issues

Component

tGoogleAnalyticsManagement

3.1 jlolling 2014-10-22
103

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

Please read the linked documentation to get more information.

test parser rule


  • Author: scorreia
  • Categories: ParserRule
  • First revision date: 2011-09-01
  • Latest revision date: 2011-09-01
  • Compatible with: Data Quality releases 5.0.0, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.2.0M2
  • Downloads: 131

About: this is a test only

Revision list

expand/collapse all

Revision 0.1 131 Downloads, Released on 2011-09-01
Download revision 0.1

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

this is for test only

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

DStar

1.0 ctoum 2010-08-04
1142

D* Industries Demo Model


54 ms