tFileDigester

Checksum of a file, obtained with the Java MessageDigest.

With a Sun JRE 6, theses digest method are supported :
- MD2
- MD5
- SHA-1
- SHA-256
- SHA-384
- SHA-512

With other JRE versions, you can get a runtime "NoSuchAlgorithmException".

tQuickBooksAdvanced

QuickBooks

tWebDavGet

This component gets a file with webdav protocol. After the downloading/installation you have to restart TOS or TIS.
Created by www.openbizz.fr.

tWebDavPut

This component puts file on a server with webdav protocol.
Created by www.openbizz.fr.

tGroovyRow

This component is similar to the tJavaRow component, except it allows users to write Groovy code.

Component Info:

1. The input and output rows, as well as the context object, are converted to Groovy maps (java.util.HashMap) with all the groovy goodness associated with maps. Primitive types are boxed into their object representations within the script and unboxed upon leaving the script.

2. The groovy script is compiled into a class upon first use.

3. One object of this groovy class is instantiated, stored and reused for each row.

4. Users have access to modify the groovy class via the "Advanced Settings" panel, and are reminded of their responsibility for all the potentially wonderful and horrible results such modification might cause.

test_oracleSP

This job design has three instances of tOracleSP to show how to call a oracle stored procedure.

1) procedure with two input values
2) procedure with one input and one output
3) call the function that is shown in the Component Reference Manual

SQL included in the documentation to create tables and stored procedures

Base64

Base64 functions to encode and decode byte arrays, Strings and files.

Useful if you need to write binary data out to ascii format and read it back in.

MD5 functions

Provides functions that return the MD5 hash of either an input file, string, or byte array.

More information about this class is available from:

http://ostermiller.org/utils/MD5.html

Loop on child job error

This Perl jobs shows how to loop on a child job that fails. The child job performs a tFileFetch that sometimes fails and we want to try 20 times before abandon. 10 seconds pause between each try.

The tricks are:

* in the child job, tDie has a return code set to 0 (so that tRunJob considers the child job has on success)
* in the father job, the condition on the tLoop is "as long as the success file does not exist AND we haven't performed at least 20 tries"
* The 10 secondes pause is performed on the "iteration" expression of the tLoop

tOracleOutputBatch

Optimized version of tOracleOutput using addBatch() and executeBatch(). Support only insert statements.

Frequency table of hours

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Sample Standard Deviation

This indicator computes the sample standard deviation of any numerical column

Variance

This indicator computes the variance of numeric columns

Trimmed

evaluate the number of data which are correctly trimmed

Week Frequency

aggregates Date fields into weeks

Duplicate Rows

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Length Range Frequency

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Order of Magnitude

measure the order of magnitude of numerical data

phone_area_code_freq

Area codes of American phone numbers

udi_average_yearly_income

parses $50K - $70K and return the average value

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)