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

3.1 jlolling 2014-10-22
40

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.

Component

tGoogleAnalyticsInput

3.1 jlolling 2014-10-22
136


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

Component

tFileOutputOdb

0.5 bennatigiuliano 2014-10-17
188

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.

Component

tMustache

1.0.1 pklalitjha 2014-10-13
76

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

tJobInstance* component collection

3.4 jlolling 2014-10-11
133

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

tUniservCDHResynchronise

2.4.0 dqsh_uniserv 2014-10-10
4

tUniservCDHResynchronise allows Talend jobs to read modified records from Smart Customer MDM that has previously been loaded using tUniservCDHOutputBulk in order to resynchronise your data source.

Uniserv Smart Customer MDM combines technologies, processes and services to provide a 360° customer view covering all areas and channels. By matching the customer data existing in each part of your systems, identifying and removing duplicates, and forming a Golden Record we create a comprehensive, unambiguous, and absolutely up-to-date view of your customers.

To be able to use the tUniservCDHResynchronise component, the Smart Customer MDM software must be configured.

The component has its own GUI and requires an additional plugin. Please contact Uniserv for download information.

For more information on Smart Customer MDM, visit http://www.uniserv.com/en/solutions/smart-customer-mdm/

Component

tUniservCDHOutputBulk

2.4.0 dqsh_uniserv 2014-10-10
3

tUniservCDHOutputBulk allows Talend jobs to initial load the data into the Uniserv Smart Customer MDM.

Uniserv Smart Customer MDM combines technologies, processes and services to provide a 360° customer view covering all areas and channels. By matching the customer data existing in each part of your systems, identifying and removing duplicates, and forming a Golden Record we create a comprehensive, unambiguous, and absolutely up-to-date view of your customers.

To be able to use the tUniservCDHOutputBulk component, the Smart Customer MDM software must be configured..

The component has its own GUI and requires an additional plugin. Please contact Uniserv for download information.

For more information on Smart Customer MDM, visit http://www.uniserv.com/en/solutions/smart-customer-mdm/

Component

tUniservCDHOutput

2.4.0 dqsh_uniserv 2014-10-10
3

tUniservCDHOutput allows Talend jobs to update an existing Smart Customer MDM that has previously been loaded using tUniservCDHOutputBulk by inserting data for new customers, deleting existing customer entries or modifying the attributes for existing customers.

Uniserv Smart Customer MDM combines technologies, processes and services to provide a 360° customer view covering all areas and channels. By matching the customer data existing in each part of your systems, identifying and removing duplicates, and forming a Golden Record we create a comprehensive, unambiguous, and absolutely up-to-date view of your customers.

To be able to use the tUniservCDHOutput component, the Smart Customer MDM software must be configured.

The component has its own GUI and requires an additional plugin. Please contact Uniserv for download information.

For more information on Smart Customer MDM, visit http://www.uniserv.com/en/solutions/smart-customer-mdm/

Component

tUniservCDHInput

2.4.0 dqsh_uniserv 2014-10-10
6

tUniservCDHInput allows Talend jobs to read Golden Records from Smart Customer MDM that has previously been loaded using tUniservCDHOutputBulk.

Uniserv Smart Customer MDM combines technologies, processes and services to provide a 360° customer view covering all areas and channels. By matching the customer data existing in each part of your systems, identifying and removing duplicates, and forming a Golden Record we create a comprehensive, unambiguous, and absolutely up-to-date view of your customers.

To be able to use the tUniservCDHInput component, the Smart Customer MDM software must be configured.

The component has its own GUI and requires an additional plugin. Please contact Uniserv for download information.

For more information on Smart Customer MDM, visit http://www.uniserv.com/en/solutions/smart-customer-mdm/

Component

PDFTextStream

2.7.0 kirby1971 2014-10-08
23

PDFTextStream

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
55

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
160

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
229

-98.092391

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

Regex

Currency 16,3

4.0 mhallam 2014-07-29
67

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
160

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
67

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
73

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
122

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
104

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
171

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: 420

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 420 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:*



60 ms