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

email_indicator

 1.0 scorreia 2013-04-24
7

SQL like clause to demo the UDI drill down feature on email columns

Indicator

US_customers_count

 1.0 scorreia 2013-04-24
6

Indicator to count the number of \'USA\' values in country columns

Indicator

ISO Week Number Frequency

 1.0 scorreia 2013-04-08
18

Computes the ISO week number frequency of a given date.
Indicator

EMail validation via mail server

 5.1.3 mzhao 2013-03-01
269

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

ParserRule

parser_rule_for_merge

 5.2.1 mzhao 2013-02-04
21

parser_rule_for_merge

Regex

pattern_for_test_merge

 5.2.1 mzhao 2013-02-04
16

pattern_for_test_merge

Indicator

udi_for_test_merge

 5.2.1 mzhao 2013-02-04
13

udi_for_test_merge

Regex

EmptyTextForTest

 5.2.1 mzhao 2013-02-04
21

EmptyTextForTest

ParserRule

ParserRuleDemoXmi

 5.2.1 mzhao 2013-02-01
36

ParserRule of xmi format, for test only!

SQL

Email_xmi

 5.2.1 mzhao 2013-02-01
74

SQL Pattern of xmi format, for test only!

Version Author Released on Rating Downloads
Export

Product Demo

 3.0 ctoum 2012-05-31
427

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

 1.0 jaymce 2010-11-22
283

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
512

Model used in the D* Demo.

Export

Talendshop Demo

 1.0 ctoum 2010-08-04
1062

Talendshop Demo (Demo Project)


137 ms