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.


tPostgresqlTableTransfer


  • Author: jlolling
  • Categories: Java, Component
  • First revision date: 2012-06-04
  • Latest revision date: 2012-08-25
  • Compatible with: Data Integration releases 4.2.0, 4.2.1, 4.2.2, 4.2.3, 4.2.4, 5.0.0, 5.0.0M1, 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.0M1, 5.1.0M2, 5.1.0RC1, 5.1.1, 5.1.2, 5.1.3, 5.2.0, 5.2.0M1, 5.2.0M2, 5.2.0RC1, 5.2.0RC2, 5.2.1, 5.2.2, 5.3.0, 5.3.0M1, 5.3.0M2, 5.3.0M3, 5.3.0RC2
  • Downloads: 72

About: Let you transfer data from a table or a query into a table in an other database.
The necessary schema (not talend schema) will automaticly retrieved from the query and from the metadata of the target table.
There is not data type conversion necessary.
Read from database and write into database occurse simultaniusly by producer/consumer pattern and multithreaded processing.
Database connection can be established within the component or given by separate connection-components.

Revision list

expand/collapse all

Revision 1.2 50 Downloads, Released on 2012-08-25
Download revision 1.2

Compatible with: 5.3.0, 5.3.0RC2, 5.3.0M3, 5.3.0M2, 5.3.0M1, 5.2.2, 5.2.1, 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 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, 5.0.0M1, 4.2.4, 4.2.3, 4.2.2, 4.2.1, 4.2.0

Bugs fixed:
* where clause can contains the word where (less error prone)
* source table must not set if query is defined
* source connection properties work correctly now

Revision 1.1 22 Downloads, Released on 2012-06-04
Download revision 1.1

Compatible with: 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, 5.0.0M1, 4.2.4, 4.2.3, 4.2.2

Added ability to use external connections

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
Indicator

Frequency table of hours

 2.0 scorreia 2013-04-25
267

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

Indicator

Sample Standard Deviation

 1.1 scorreia 2013-04-25
181

This indicator computes the sample standard deviation of any numerical column

Indicator

Variance

 1.1 scorreia 2013-04-25
172

This indicator computes the variance of numeric columns

Indicator

Trimmed

 1.0 scorreia 2013-04-25
4

evaluate the number of data which are correctly trimmed

Indicator

Week Frequency

 2.0 scorreia 2013-04-25
164

aggregates Date fields into weeks

Indicator

Duplicate Rows

 2.0 scorreia 2013-04-25
564

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.

Indicator

Length Range Frequency

 1.1 scorreia 2013-04-25
36

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

Indicator

Order of Magnitude

 1.1 scorreia 2013-04-25
47

measure the order of magnitude of numerical data

Indicator

phone_area_code_freq

 1.0 scorreia 2013-04-24
2

Area codes of American phone numbers

Indicator

udi_average_yearly_income

 1.0 scorreia 2013-04-24
2

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

Version Author Released on Rating Downloads
Export

DStar

 1.0 ctoum 2010-08-04
1096

D* Industries Demo Model


49 ms