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.


tTransferDatabase


  • Author: jpcb
  • Categories: Component
  • First revision date: 2012-01-08
  • Latest revision date: 2012-10-26
  • Compatible with: Data Integration releases 5.0.0, 5.0.1, 5.0.2, 5.1.0, 5.1.1
  • Downloads: 659

About: Allows transfer one database engine to another database engine using the library apache ddlutils.

The component supports the following list of database

*DB2
*Firebird
*HSQLDB
*Interbase
*MaxDB
*MySql
*Oracle
*PostgreSQL
*SQL Server
*Sybase

Revision list

expand/collapse all

Revision 1.3 234 Downloads, Released on 2012-10-26
Download revision 1.3

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

*Bugs fixed

Revision 1.2 229 Downloads, Released on 2012-03-15
Download revision 1.2

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Changes:

*Bugs fixed

Revision 1.1 59 Downloads, Released on 2012-03-07
Download revision 1.1

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Changes:

* Refactored code
* Check unique index name
* Fixed some common mistakes

Revision 1.0 137 Downloads, Released on 2012-01-08
Download revision 1.0

Compatible with: 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Release Version

Reviews (1)

 cool By jjzhou on June 7, 2013
cool
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
42

Other Swedish personnummer regexps do not take into account that at Swedish universities, foreigners might get special temporary personnummers with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Regex

Istat Code

4.0 mhallam 2014-07-29
146

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

Regex

Longitude Validation

4.0 mhallam 2014-07-29
218

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code

Regex

Currency 16,3

4.0 mhallam 2014-07-29
58

Currency expression, accepts 4 commas and 4 groups of 3 numbers and 1 number before the first comma, this first number will have to be different from zero. It accepts a number of, two or three decimal. It accepts zero numbers after the point. You can change the number of groups and numbers accespts before and after the point.

Regex

Random email

2.0 scorreia 2014-07-29
153

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
60

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
66

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
114

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
96

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
161

This regular expression not only checks if the postal code is five digits long. The second digit must not be zero, because a postal code like 00123 is invalid.

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
610

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
403

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
742

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1131

Talendshop Demo (Demo Project)


101 ms