Migrating from DatabaseLookup to tHMap - 7.2

Data mapping

EnrichVersion
7.2
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
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
If you have Jobs that use the DatabaseLookup function, you can migrate these to use the multi-input feature of tHMap.

Prerequisites

This procedure provides you an example of how you import Oracle databases to Talend Studio and create input connections to the tHMap component.

  • You have a Talend Data Mapper Structure created from a database connection.
  • You have a Talend Data Mapper Map, where the output element is the output of a DatabaseLookup using the database tables imported in Talend Data Mapper. See the following example:
  • If you wish to use the attached sample project from the Downloads tab, you need to create databases using the sample database scripts in your local server.