Best practices tHMap lookup values

kevin5 — Fri, 15 Nov 2024 23:21:41 GMT

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

Re: Best practices tHMap lookup values

Anonymous — Mon, 17 Jan 2022 09:05:56 GMT

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

topic Re: Best practices tHMap lookup values in Talend Studio

Best practices tHMap lookup values

Re: Best practices tHMap lookup values