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.


tFileOutputOdb


  • Author: bennatigiuliano
  • Categories: Java, Component
  • First revision date: 2011-08-29
  • Latest revision date: 2012-03-14
  • Compatible with: Data Integration releases 4.1.2, 4.2.3, 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.2
  • Downloads: 151

About: This component allows you to execute an Insert into SQL tables on OpenOffice.org database files (.odb) Adding of functionnalities : Update/Delete based on keys columns to define Sql Where clauses, + a cleaning function when .odb file is corrupted by a Sql error.

Revision list

expand/collapse all

Revision 0.4 39 Downloads, Released on 2012-03-14
Download revision 0.4

Compatible with: 5.0.0

This component allows you to execute an Insert, Update/Delete (based on keys columns to define Sql Where clauses) into SQL tables on OpenOffice.org database files (.odb), + a cleaning function when .odb file is corrupted by a Sql error.
This minor correction giving an increase of line\'s number written in .odb from 200 lines/sec to 8000 lines/sec.

Revision 0.3 48 Downloads, Released on 2011-10-20
Download revision 0.3

Compatible with: 5.0.2, 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.3

This component allows you to execute an Insert into SQL tables on OpenOffice.org database files (.odb) Adding of functionnalities : Update/Delete based on keys columns to define Sql Where clauses, + a cleaning function when .odb file is corrupted by a Sql error.

Revision 0.2 42 Downloads, Released on 2011-09-12
Download revision 0.2

Compatible with: 4.1.2

This component allows you to execute an insert into SQL tables on OpenOffice.org database files (.odb)

Pease, set schema columns number to your targeted tables

Revision 0.1 22 Downloads, Released on 2011-08-29
Download revision 0.1

Compatible with: 4.1.2

tFileOutputOdb : The tFileOutputOdb component allows you to perform delete* then insert into SQL tables on OpenOffice.org database files (.odb)

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
Regex

US Zipcode Validation

 3.1.2 mhallam 2009-07-07
83

matches only if 5 numerics are presentnot matches if less than 5 numerics
Zipcode should be of 5 numerics

Regex

Swedish personnummer with accepted foreigners

 3.1.2 mhallam 2009-07-07
67

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

Swedish Personal Nr (Personnummer)

 3.1.2 mhallam 2009-07-07
65

Simple regex for the Swedish personal number. It's in the form: YYMMDD-xxxx where xxxx is an arbitrary number from 0000-9999.

791231-1234

Regex

UK Vehicle Registration Plate Number Plate

 3.1.2 mhallam 2009-07-07
52

AB12 RCY|||CD07 TES|||S33 GTT|||Y999 FVBab12 rcy|||CD07 TIS|||S34 GTT|||Z999 FVB

UK Vehicle Registration Plate / Number Plate format as specified by the DVLA. Accepts both "Prefix" and "New" style. Allows only valid DVLA number combinations as not all are supported. Registration number must be exactly as is displayed on car, hence all letters must be in uppercase and a space seperating the two sets of characters.

Regex

Phone Brazil

 3.1.2 mhallam 2009-07-07
56

011 5555-1234|||(011) 5555 1234|||(11) 5555.1234|||1155551234(011 5555-1234|||(01) 5555 1234|||(11) 0555.1234|||(11) 5555 abcd


Matches Brazilian phone numbers, includes DDD (long-distance call) with or without 0. Accepts characters -, . and [space] as separators.

Regex

No special chart

 3.1.2 mhallam 2009-07-07
32

QDE|||QDE#RF

Allow only 3 charcters or number without any special characters

Regex

Mobile number of India

 3.1.2 mhallam 2009-07-07
38

This expression will be useful to check mobile
number of India. This expression will check
various types of number like number in local
format or international number separated by
hyphen(-) or not.

Regex

International phone number

 3.1.2 mhallam 2009-07-07
61

Matches most international formated phonenumber.

Regex

International Passport

 3.1.2 mhallam 2009-07-07
34

? 9 characters made up of a combination of numbers and/or letters. Where less than 9 characters it will be padded out to the right with chevrons (

Regex

ISBN Checker

 3.1.2 mhallam 2009-07-07
53

Expression to check for a valid ISBN number

Version Author Released on Rating Downloads
Export

DStar

 1.0 ctoum 2010-08-04
1096

D* Industries Demo Model


49 ms