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

tFileInputTextFlat

3.4 jlolling 2014-12-27
103

This component is dedicated to read text files.
Advantages:
* reads fields with gaps between them
* can configure the columns by the header line (also with regex)
* reduced byte code foodprint
* can apply regex expressions to the field content
* translates the numbers for any country formats
* Can read the field extraction configuration from an external config file.

Component

tGoogleAnalyticsUnsampledReports

1.1 jlolling 2014-12-24
2

This component managed un-sampled reports for Google Analytics.
It can only be used with a Google Analytics Premium Account.
It is recommended to take care the reports needs to be treated this way because the quotas for un-sampled reports are much lower than for normal reports.
It is a good practice to run the report first as normal reports with tGoogleAnalyticsInput and check the sampling state and decide which reports needs to run as un-sampled reports.
Un-sampled reports are treated in an asynchronous process. Everything whats necessary to do the steps are build-in in this component, except the download of the files. Please us the new component tGoogleDrive to do this.

Please read the linked documentation. The procedure is a bit complex!

In case of questions feel free to contact me: jan.lolling@gmail.com

Component

tGoogleAnalyticsManagement

4.1 jlolling 2014-12-24
107

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

4.1 jlolling 2014-12-24
240


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

tGoogleDrive

1.2 jlolling 2014-12-23
7

This component manages files and folders on a Google Drive.
It has various operational modes to:
- upload a file (also with set permissions to other users)
- download a file
- list files (with filtering)
- get the properties of a file/folder
- move files
- delete files

Especially for the usage in conjunction with tGoogleAnalyticsUnsampledReports this component provides the same authentication methods as for the Google Analytics and is able to work directly with file-Ids.

Please refer the linked documentation.
For questions and suggestions please contact me: jan.lolling@gmail.com
Please do not use the rating function to post questions.

Component

tNetSuiteInput

0.1 muthu@tooltopia.com 2014-12-16
6

NetSuiteInput

Component

tFileOutputPDF

1.0 muthu@tooltopia.com 2014-12-16
22

FileOutputPDF

Job

JOB_ORACLE_AQ_DEMO

2.0 amallek 2014-12-15
21

Job décrivant la méthode d’utilisation des composant tOracleAQxxxxx.
OracleAQConnection, tOracleAQSubscriber et tOracleAQMessage.

Les composants tOracleAQxxxxx (tOracleAQConnection , tOracleAQSubscriber , tOracleAQMessage) servent à se connecter à une fil d’attente (queue) Oracle et reste à l’écoute de cette dernière en attendant un message.
J’aurais pus créer en une seule composante, mais je l’ai divisé en trois parties pour qu’ils soient utile lors d’une exécution en parallèles, on peut faire plus qu’un seule abonnement à la fois.
J’ai aussi faire des paramètres avancés pour que le composant ne se termine pas en erreur en cas d une anomalie ( connexion à la base par exemple). C’est pour avoir la possibilité de reboucler et de retenter la connexion à la queue comme décri dans le job démo.

Component

tOracleAQReadMessages

1.0 amallek 2014-12-15
2

tOracleAQReadMessages is a component that reads from a subscription to a Queue ORACLE.

Component

tOracleAqConnectionToSubscriber

1.0 amallek 2014-12-15
1

tOracleAqConnectionToSubscriber is a component that connects to the ORACLE waiting Queuq, and it remains to the listening of a subscription of the Queuq

Average Length With Null For SQL Server Storing Large


  • Author: yyi
  • Categories: Indicator
  • First revision date: 2012-06-12
  • Latest revision date: 2012-06-12
  • Compatible with: Data Quality releases 5.0.0, 5.0.0M2, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.0.1, 5.0.2, 5.1.0, 5.1.0M2, 5.1.0RC1, 5.1.1
  • Downloads: 22

About: Computes the average length of the field, counting null data as zero length values, the text filed type should be ntext or text in Microsoft SQL Server.

Revision list

expand/collapse all

Revision 1.0 22 Downloads, Released on 2012-06-12
Download revision 1.0

Compatible with: 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2

Related to http://jira.talendforge.org/browse/TDQ-5030

Reviews (0)

Be the first to review this extension!

 

Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
686

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
449

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
787

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1158

Talendshop Demo (Demo Project)


81 ms