Best practices tHMap lookup values

[kevin5]

Hi,

My case:

i developped a route calling cTalendjob and merging 2 sources : 1 XML and 1 correlation table SQL Server. My final output of this process will be a XML.

My problematic: i want to lookup values from the correlation table (SQL Server). What would be the best practice for that ?

I already tried:

• tHMap multiple input

but i did not succed to have multiple input : XML and Table in the same tHMap

• tHMAP : DatabaseLookup values

I think it will be a good idea but i cannot find where to define the datasource name when i'll deploy into the karaf runtime. May be this functionnality will be deprecated in the future ? (in reference to DatabaseUpdate https://help.talend.com/r/en-US/8.0/data-mapper-functions-reference-guide/databaseupdate-function)

At the moment, i found only one solution to use tRouteInput -> tXMLMap and lookup values from table -> tHMap for the final XML rendering. but it's a bit ugly....

Thank's in advance for sharing your experience

regards

[Anonymous]

Hello,

Here is a KB article about: how to access Talend Data Mapper from within Talend Studio, and explains how to create structures and maps that allow you to parse an XML file.

https://community.talend.com/s/article/Talend-Data-Mapper-Intro-Part-Using-the-Data-Mapper-Usiyf

Feel free to let us know if it helps.

Best regards

Sabrina