tEXATableTransfer – Talend Custom Components

Name: tEXATableTransfer
Icon: tEXATableTransfer
Author: Jan Lolling
Install Instructions:
Example: Coming soon…

* Fast transfer of the data – even from different database types than EXASolution
* Export data in parallel to a bulk input file
* Detects and matches columns to be transferred automatically
* Detect automatically fields which are actually SQL keywords and enclose them automatically.
* Can measure min/max values of configured column to allow incremental load scenarios


This component is dedicated to transfer the table content from one database to an EXASolution database.
The component can truncate the target table before.
This component does not care about schema differences.
All columns existing in source and target table will be transferred, all other ignored. The necessary schema will be created internally, therefore you have to provide only the source and target table name, thats it.
The component uses asynchronous transfer to half the duration because reading and writing can take place at the same time (or overlapping).

The component can also be used to export the data as CSV files dedicated to the bulk import.

You can configure columns as to be excluded from the transfer and as well
you can add aditional columns to the output.

The component can measure for a column the min/max values and return them as return values of this component. This helps to use it in a incremental load scenario.

tEXATableTransfer v_7.2__1
tEXATableTransfer v_7.2__2
tEXATableTransfer v_9.6__3
Release Notes:

Release version: 7.2 – 2019-08-28 18:19:22
* Updated to the generic and prooven procedure of the version 7.2 of the underlaying library.
* Excepts a dedicated source and target connection and will not establish the connection for itself
* Better meta data support
Release version: 9.6 – 2021-12-09 14:20:30
* Fetch column names from select with alias works now correctly
* Set Date typed value for fix column values does not need the manual conversion from java.util.Date to java.sql.Date

  • 6.5 (retired)
  • 7.0 (retired)
  • 7.1 (retired)
  • 7.2
  • 7.3
  • 8.0

Document get from Talend Exchange
Thank you for watching.

Was this article helpful?
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x