Dummy

gf

tAsterDataNClusterLoader

The tAsterDataNClusterLoader component helps you to benefit of the nClusterLoader API and Utility to bulk load your data into your AsterData nCluster Database.

HGNC 2 Bio2RDF

http://www.genenames.org/cgi-bin/hgnc_stats.pl

tRESTAuth

This component is an extension of tRest. It allows users to authenticate via HttpBasic.

tFileInputAuthJson

This component is an extension of the component tFileInputJson. It allows to connect via HTTP Basic Authentication.

Data Publica

This component can read data from the API www.data-publica.com
You will have to register first to get a password and an API key.

To use the component go for example on :
http://www.data-publica.com/opendata/13242--vox-twitter-2012#
On API you can see the url to use in the components.
In this case, the reference should be 13242 , the table should be tweets_table.

tTransferDatabase

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

tFileOutputOdb

This component allows you to execute an Insert into SQL tables on OpenOffice.org database files (.odb) Adding of functionnalities : Update/Delete based on keys columns to define Sql Where clauses, + a cleaning function when .odb file is corrupted by a Sql error.

tCmisInput

Component for Content Management Interoperability Services (CMIS) compliant Enterprise Content Management (ECM) Systems. Allows accessing ECM systems via CMIS query language to retrieve documents (content & metadata).

For questions and more information contact me on
gabor.claussnitzer@cimt-ag.de

SAP Connection/Table Metadata Wizard

This Talend plug-in completes the Talend Open Studio with the SAP Connection and SAP Table wizards, allowing smooth metadata handling for SAP Tables. The plug-in also contains the required components to download tables from SAP by RFC_READ_TABLE or PLSAP Connector\'s RFCs.

BenfordLawFrequencyIndicator

This Class provide the function to compute a group of data by Benford\'s Law and output the leading
digits with its distribution in this dataset. Then the user can use it to compare with the standard, to detect
possible cases of Fraud.

Names with unicode characters

Match people names with unicode characters.
Matches Jean-Marc, Jørn, Mc\'Neelan, Pz. López
Does not match I.B.M.

Dutch Phone Number

Phone Number format verfication (Netherlands)

Local: Dutch Phonenumber format is area code (3 or 4 digits), phone number ( 7 or 6 digits) - total length (10 digits)
International: country code 0031 and then remove zero from area code
Matches
0031121234567|+31123123456|0121234567|012-1234567|0123-123456
Non Matches
012 1234567|1234567
match 02.31.23.45.67.22 or 004923123467223

Dutch VAT Number

VAT Number format verification (Netherlands)

Matches
NL123456789B01|NL123456789.B01
Non Matches
123456789B01|NL1234.56.789.B01

Dutch Postal Code

Postal Code format verfication (Netherlands)

Matches
9999AA|9999 AA
Non Matches
9999aa|9999Aa|9999 aa|9999 aA

tOracleObjectList

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

Week Frequency

aggregates Date fields into weeks

Date DD MM YYYY

Date pattern created during Talend Open Profiler training

test parser rule

this is a test only

delimited file format

check whether each row respect a simple delimited file format with 5 columns

Product Demo

Product & families, with Cafepress pictures.

Clinical Trials: Janus Model Basics

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

D* Demo Model

Model used in the D* Demo.

Talendshop Demo

Talendshop Demo (Demo Project)