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

tNetSuiteInput

0.1 muthu@tooltopia.com 2014-12-16
2

NetSuiteInput

Component

tFileOutputPDF

1.0 muthu@tooltopia.com 2014-12-16
7

FileOutputPDF

Job

JOB_ORACLE_AQ_DEMO

2.0 amallek 2014-12-15
21

Job décrivant la méthode d’utilisation des composant tOracleAQxxxxx.
OracleAQConnection, tOracleAQSubscriber et tOracleAQMessage.

Les composants tOracleAQxxxxx (tOracleAQConnection , tOracleAQSubscriber , tOracleAQMessage) servent à se connecter à une fil d’attente (queue) Oracle et reste à l’écoute de cette dernière en attendant un message.
J’aurais pus créer en une seule composante, mais je l’ai divisé en trois parties pour qu’ils soient utile lors d’une exécution en parallèles, on peut faire plus qu’un seule abonnement à la fois.
J’ai aussi faire des paramètres avancés pour que le composant ne se termine pas en erreur en cas d une anomalie ( connexion à la base par exemple). C’est pour avoir la possibilité de reboucler et de retenter la connexion à la queue comme décri dans le job démo.

Component

tOracleAQReadMessages

1.0 amallek 2014-12-15
1

tOracleAQReadMessages is a component that reads from a subscription to a Queue ORACLE.

Component

tOracleAqConnectionToSubscriber

1.0 amallek 2014-12-15
1

tOracleAqConnectionToSubscriber is a component that connects to the ORACLE waiting Queuq, and it remains to the listening of a subscription of the Queuq

Hadoop Configuration

Cloudera CDH 5.2.X

1.0 rdubois 2014-12-12
4

Custom hadoop configuration which allows connecting to a Cloudera CDH5.2.X cluster.

Component

tGSpreadsheetInput

1.0 igonzals 2014-12-03
11

Component

tDB2TemporalMergeELT+tDB2TemporalDeleteELT

3.0 jlolling 2014-12-02
54

This package contains 2 components:
tDB2TemporalMergeELT
tDB2TemporalDeleteELT

These components supports the ELT usage of the IBM DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.

Please refer to the linked documentation!

tDB2TemporalMergeELT create and updates temporal tables.
tDB2TemporalDeleteELT performs temporal deletes.
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).

tGoogleGeocoder

0.61 llaen 2014-11-24
408

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

tFileFetchEnhanced

1 Steven_Crawford 2014-11-20
19

This component extends Talend\'s tFileFetch to introduce support for RAW Body types on HTTP POST\'s. (This means you can send JSON, XML, or whatever)

I also exposed the PostMethod and HTTPClient objects as global variables (access with component name with suffix \'_METHOD\' and \'_CLIENT_STREAM\' respectively).
The purpose for this was to provide support for closing the client after finishing with the input. I ran into an issue where the sockets weren\'t closed properly when iterating over hundreds/thousands of API calls.

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
62

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
169

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
238

-98.092391

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

Regex

Currency 16,3

4.0 mhallam 2014-07-29
73

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
171

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
74

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
79

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
131

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
111

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
180

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.

Clinical Trials: Janus Model Basics


  • Author: jaymce
  • Categories: Data-Model
  • First revision date: 2010-11-22
  • Latest revision date: 2010-11-22
  • Compatible with: Master Data Management releases 4.0.2, 4.0.3
  • Downloads: 449

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

Revision list

expand/collapse all

Revision 1.0 449 Downloads, Released on 2010-11-22
Download revision 1.0

Compatible with: 4.0.3, 4.0.2

the basic Janus clinical trials data model

Reviews (0)

Be the first to review this extension!

 

Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



57 ms