tEXATableTransfer – Talend Custom Components

• Documentation (works pretty much like the PostgreSQL edition)
• Source Code

• tEXATableTransfer version 5.4 – Direct download
• tEXATableTransfer version 7.2 – Direct download
• tEXATableTransfer version 9.6 – Direct download

* 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.

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