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.0.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.0.1 (CE and Pro).
Author: Jan Lolling @ cimt ag Berlin
email: jan.lolling@cimt-ag.de

tJasperServerFileDelete

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

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*:
1. 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

tGoogleGeocoder

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 signature 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.

tAdvancedCMISOutput

Component for importing content from a CMIS repository.

CMIS (Content Management Interoperability Services) is an OASIS standard enabling information sharing between different Content Management Systems (CMS, ECM, DAM, ...).

This component is build with the Apache Chemistry OpenCMIS Client API.

For source code and documentation, please visit https://github.com/Ekito/talend-cmis-components.

Please review and rate this component.

tAdvancedCMISInput

Component for exporting content from a CMIS repository.

CMIS (Content Management Interoperability Services) is an OASIS standard enabling information sharing between different Content Management Systems (CMS, ECM, DAM, ...).

This component is build with the Apache Chemistry OpenCMIS Client API.

For source code and documentation, please visit https://github.com/Ekito/talend-cmis-components.

Please review and rate this component.

tLDAPHelper

function Helper to extract id from dn

tIGOutput

For an easy way to start using InfiniteGraph with existing data sets, this connector allows data ingest from a variety of Talend input connectors to an InfiniteGraph database. It allows you to map and define vertices and edges and generates Java class files to use with your application.

For more information see: http://wiki.infinitegraph.com

tOpenERPOutput

the source can be found at https://github.com/baumgaro/OpenERP-Talend-Component.git

read more at http://datenpol.at/unternehmen/blog/datenpol-creates-talend-component-for-openerp/

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