tInformixCDC
Extracts the data from a source system which has changed since the last extraction
and transports it to another/other system(s).
tInformixCDC only extracts the changes done to the
source operational data and makes them available to the target system(s) using database
CDC views.
tInformixCDC Standard properties
These properties are used to configure tInformixCDC running in the Standard Job framework.
The Standard
tInformixCDC component belongs to the Databases family.
The component in this framework is available in all subscription-based Talend products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Property type |
Either Built-in or Repository. |
 |
Built-in: No property data stored |
 |
Repository: Select the repository Warning:
Reset the database type by clicking the relevant button to |
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection |
Host |
Hostname or IP address of the database server. |
Port |
Listening port number of the database server. |
Database |
Name of the database. |
Schema |
Name of the schema. |
Username and |
Database user authentication data. To enter the password, click the […] button next to the |
Instance |
Name of the Informix instance to be used. This information can |
Schema using CDC and Edit |
A schema is a row description. It defines the number of fields to |
 |
Built-In: You create and store the schema locally for this component |
 |
Repository: You have already created the schema and stored it in the Warning:
Reset the DB type by clicking the relevant button to |
 |
Click Edit
|
Table using CDC |
Select the source table from which changes made to data are to be |
Subscriber |
Enter the name of the application that will use the change |
Use Transaction |
Select this check box when the database is configured in NO_LOG |
Events to catch |
Insert: Select this check box to
Update: Select this check box to
Delete: Select this check box to |
Advanced settings
Additional JDBC Parameters |
Specify additional connection properties for the database |
Keep data in CDC Table |
Select this check box to keep the changes made available to one or |
Trim all the String/Char columns |
Select this check box to remove leading and trailing whitespace |
Trim column |
Remove leading and trailing whitespace from defined Note:
Deselect Trim all the String/Char |
tStatCatcher Statistics |
Select this check box to collect log data at the component |
Enable parallel execution |
Select this check box to perform high-speed data processing, by treating
multiple data flows simultaneously. Note that this feature depends on the database or the application ability to handle multiple inserts in parallel as well as the number of CPU affected. In the Number of parallel executions field, either:
Note that when parallel execution is enabled, it is not possible to use global
|
Global Variables
Global Variables |
NB_LINE: the number of rows processed. This is an After
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
This component is used as a start component. It requires an output |
Related scenario
For a related scenario, see Retrieving modified data using CDC.