Inserting data into the source table

Change Data Capture

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Data Services Platform
Talend Data Integration
Talend Data Fabric
Talend Big Data
Talend Big Data Platform
Talend Data Management Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Quality and Preparation > Third-party systems > Database components > Change Data Capture
Data Governance > Third-party systems > Database components > Change Data Capture
Design and Development > Third-party systems > Database components > Change Data Capture
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tFixedFlowInput to open its Basic settings view.
  2. Click the [...] button next to Edit schema to open the schema editor.
    Click four times the [+] button to add four columns: id and age of the integer type, name and sex of the string type.
    Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.
  3. Select Use Inline Content(delimited file) in the Mode area, and then enter the following input data in the Content field:
    1;Ford;Male;25
    2;Rose;Female;30
    3;Sabrina;Female;28
    4;Teddy;Male;32
    5;Kate;Male;35
  4. Double-click tOracleOutput to open its Basic settings view.
  5. Set Property Type to Repository and select the connection metadata corresponding to the Oracle database on which the XStream outbound server is configured, Oracle12_XStreamOut in this example. The connection type, database version and other connection details information will be completed automatically.
  6. In the Table field, enter the name of the table into which the input data will be inserted. In this example, it is PERSON.
  7. Click the [...] button next to Edit schema to open the schema editor to ensure the schema has been synced up.