tJasperServerFileDelete

This component deletes a file within the JasperServer.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin
email: jan.lolling@cimt-ag.de

tJasperServerFileList

List all content resources in a folder of a JasperServer (optional including sub directories). This component helps to automatically dowload or synchronize files between locale file system and JasperServer. See also the components tJasperServerFilePut and tJasperServerFileGet
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFileGet

Can download content resources from a JasperServer. This component works well together with tJasperServerFileList component.
It can create local file system is needed and rename the content resource.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro)
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFilePut

Lets you upload files on a Jasper Server. This is a replacement for tJasperServerContentResourceUpload component.
This new component has more useful return values.
Tested with JasperServer version 4.2.x up to 5.1 (CE and Pro)
Author: Jan Lolling @ cimt ag Berlin

tJasperServerFileCopy

This component copies files within the JasperServer.
This component is tested with JasperServer 4.2.x up to 5.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin
email: jan.lolling@cimt-ag.de

s

tRunTask

This components runs a task within the Talend Administration Center.
Please refer the PDF documentation linked as resource here.
This component uses only Open Source libraries.
This component helps to create much more sofisticated job chains.
* set context parameters
* configure which task cannot run at the same time
* setup the wait for the end of the job by polling or direct response
* at the moment it is not possible to use the job return code because of a missing feature of the TAC web service (but this gap is recognized and in planning for Talend release 5.4).

tFileExcelWorkbookOpen

This component is the base component for all other tFileExcel-components.
This component use the Apache POI library version 3.9.
This components reads a spreadsheet in a workbook or create a new empty workbook in memory.
This workbook can be filled (with sheets) by the component tFileExcelSheetOutput or can be read by tFileExcelSheetList/Input components.
Finally the component tFileExcelWorkbooksave persists the workbook in the same file as read or in a new file.
The component recognize the file format by the filename extension, it is not necessary to configure it (except if you create a new workbook).
*NEW*: can read and write xlsm files.
Bug fixed: reading rows stops if row is empty or does not exists
*NEW*: Memory saving mode for XSLX type
*NEW*: Can read password protected files
*NEW*: support for IFERROR function added

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.

tmapgly

EMail validation via mail server

This Java UDI check emails by sending a SMTP request to mail server. the code sample can be found at: http://www.rgagnon.com/javadetails/java-0452.html

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