Migrating the Job - 7.3

Data mapping

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Processing components (Integration) > Data mapping
Data Quality and Preparation > Third-party systems > Processing components (Integration) > Data mapping
Design and Development > Third-party systems > Processing components (Integration) > Data mapping
Last publication date
2024-02-21

Add the databases to the tHMap as output connections.

Procedure

  1. Right-click Metadata > Db Connections and select Create connection to add a new database connection.
  2. Right-click the newly created database connection and select Retrieve Schema. Import the necessary schemas.
  3. In the existing Job, drag-and-drop the database connection and select the connection component. In this example, use tOracleConnection and connect using the Trigger > On Subjob OK connection:
  4. Drag-and-drop the database tables in the Job and select its corresponding output component. In this example, use tOracleOutput.
  5. Connect each output component using the Row > Main connection. For the output name, enter the same database table name from the Talend Data Mapper Map's Output Structure.
    When you open the tHMap Map Editor, note that there are no synchronization checks or proposals provided even after adding the output connections. To synchronize the database table's schema update on the Structure, see Syncing Database Table Schemas.
  6. Add tOracleCommit and connect it to the tHMap using the Trigger > OnComponentOk.
  7. Run the Job and check the data of the database tables accordingly.