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
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
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!
Warning : implode() [
function.implode ]: Invalid arguments passed in
/home/www/talendforge.org/exchange/tos/include/functions.multi.inc.php on line
1182
Warning : implode() [
function.implode ]: Invalid arguments passed in
/home/www/talendforge.org/exchange/tos/include/functions.multi.inc.php on line
1223
Version
Author
Released on
Rating
Downloads
number1-10
3.2.3
mhallam
2010-01-27
69
top
(0 votes, average 0 out of 5)
35
match 1 .. 10
semester
3.2.3
mhallam
2010-01-27
68
top
(0 votes, average 0 out of 5)
22
1 or 2
Quarter
quarter
mhallam
2010-01-27
66
top
(0 votes, average 0 out of 5)
32
accept only 1 or 2 or 3 or 4
French vehicle registration plate number
0.1
mgainhao
2009-10-28
64
top
(0 votes, average 0 out of 5)
65
French vehicle registration plate number Match : AA-098-BA
not match : A2-093-BB, AB-09G-CD, AR-93-BB ...
Random email
1.0
scorreia
2009-10-22
62
top
(0 votes, average 0 out of 5)
131
detect random emails
hotmail email
1.0
scorreia
2009-09-02
59
top
(0 votes, average 0 out of 5)
274
filters email from hotmail.com
Numeric
1.0
scorreia
2009-08-12
55
top
(0 votes, average 0 out of 5)
372
Matches all numbers
Longitude Validation
3.1.2
mhallam
2009-07-07
52
top
(0 votes, average 0 out of 5)
193
-98.092391 Longitude validation (similiar to Latitude Validation) and inspired by the same code
Istat Code
3.1.2
mhallam
2009-07-07
51
top
(0 votes, average 0 out of 5)
116
22.12.0|18.24.C||22.12_D|12.56| 1A.56.1 This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004
Valid UK Post Codes Upper and Lower Case
3.1.2
mhallam
2009-07-07
50
top
(0 votes, average 0 out of 5)
102
SW112LE | SW11 2LE | sw112le12CR0LE | 12CR 0LE | SWLE05 Matches valid UK post codes in both upper and lower case, allowing for one or zero spaces between outcode and incodes.
Version
Author
Released on
Rating
Downloads
Product Demo
3.0
ctoum
2012-05-31
7
mdm
(3 votes, average 3.67 out of 5)
427
Product & families, with Cafepress pictures.
Clinical Trials: Janus Model Basics
1.0
jaymce
2010-11-22
6
mdm
(0 votes, average 0 out of 5)
283
This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm
D* Demo Model
1.0
ctoum
2010-08-13
4
mdm
(1 vote, average 4.00 out of 5)
512
Model used in the D* Demo.
Talendshop Demo
1.0
ctoum
2010-08-04
3
mdm
(0 votes, average 0 out of 5)
1062
Talendshop Demo (Demo Project)