tFileExcelWorkbookSave

This component is designed to work with tFileExcelWorkbookOpen and tFileExcelSheetOutput.
This component writes a workbook into a output file.
This happens after finish writing in several sheets by tFileExcelSheetOutput.
*NEW*: Can delete sheets (usually used as templates before)

tLDAPSearch

tLDAPSearch allow you to connect your search to an existing LDAP connexion with possibility to modify the Base DN
You can also :
- Modifier the scope of the search
- Enables/disables link dereferencing during the search
- Enables/disables returning objects returned as part of the result

tRedirectOutput

This component can be used to redirect all the output sent to System.out and System.err to 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/

tOpenERPInput

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/

Only alphabetical characters not empty

Only alphabetical characters not empty.
And at least one (empty forbidden)

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