tAS400CDC
Addresses data extraction and transportation needs.
tAS400CDC only extracts the changes carried out on the source
operational data and makes them available to the target system(s) using database CDC
views.
By default, this component automatically calls the AS/400-dedicated program RUNCDC to
write the latest update information into a change table (a CDC table) and runs queries
in the same table to read changes.
The RUNCDC program is automatically installed by Talend Studio using a
savf script stored in the following directory:
<Studio_install>pluginsorg.talend.designer.cdc_<version>
esourcefitcdc.savf.
For further information about this fitcdc.savf script
and the command used to install the RUNCDC program, see the section describing how to
set up CDC in Redo/Archive log mode (journal) for
AS/400 in
Talend Studio User Guide.
tAS400CDC Standard properties
These properties are used to configure tAS400CDC running in the Standard Job framework.
The Standard
tAS400CDC 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 |
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 |
Property type |
Either Built-in or Repository |
 |
Built-in: No property data stored |
 |
Repository: Select the repository Warning:
Reset the DB type by clicking the relevant button to |
DB Version |
Select the AS/400 database version you are using. |
Host name |
Database server IP address. |
Database |
Name of the CDC database. Note:
The CDC database in which are stored the modified data must be |
Username and Password |
DB user authentication data. To enter the password, click the […] button next to the |
Schema and Edit |
A schema is a row description. It defines the number of fields |
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 Name |
Short name of the source table where changes made to data should be |
Source Library |
The AS/400 database’s source library. Note:
The library name must not contain more than 10 characters. The |
Subscriber |
Enter the name of the application that will use the change |
Events to catch |
Insert: Select this check box to
Update: Select this check box to catch
Delete: Select this check box catch the |
Member |
Enter the name of the member that holds the desired records. A member |
Advanced settings
Additional JDBC parameters |
Specify additional connection properties for the DB connection you are |
||||
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 from |
||||
Trim column |
Remove leading and trailing whitespace from defined columns. Note:
Deselect Trim all the String/Char |
||||
Disable command |
Select this check box to be able to manually call the RUNCDC program by yourself to write changes |
||||
Customize command |
Select this check box to write custom commands that override the For example, tAS400CDC by default
executes the following command:
This command does not automatically detach a receiver from its
corresponding journal and cannot create and attach a new one to that journal, either. In this situation, you can enter your customized command as follows to automate the detachment and attachment process:
Note that the name of the CDC library is often the name of the CDC |
||||
tStatCatcher Statistics |
Select this check box to collect log data at the component |
Usage
Usage rule |
This component is used as a start component. It requires an output Note that the journal and the receiver required by CDC are typically Because of this behavior updates, since 5.4.2, the tAS400CDC component does not execute the
This command is used to ensure that an older receiver is detached from For further information about how the CDC for AS/400 is handled by the |
Related scenario
For a related scenario, see Retrieving modified data using Oracle CDC Redo log mode.