SF-DB2

Anonymous — Sat, 16 Nov 2024 03:01:35 GMT

Hi All, I'm new to talend and have a complex functionality to be build. I want to query some tables from Salesforce(Account, Contact, CustomObject1, Opportunity, CustomObject2). 1. An Account may have multiple contacts. 2. CustomObject1 Has a lookup to account and may have multiple Opportunities as well as multiple CustomObject2 records) need to query the data of all these objects where the opp.stageName = 'closed won'. And then need to insert all the data into 5 SQL tables. Assuming that i would need to have 3 queries( 1. on Opportunity fetching the opp/Account/CustomObject1 data, 2. On Contact to extract contacts of the queried accounts 3. On customObject2 to get records based on CustomObject1 as the parentId) I want to have the flow in a way that 1. For each CustomObject1 : Insert 1 customObject1 record 2. then insert all CustomObject2 records 3. Then insert other child records. Stuck with how to iterate and combine the tmaps.

Re: SF-DB2

Anonymous — Thu, 12 Mar 2020 07:34:29 GMT

Hi
To achieve the task, I think you need to do some iteration and inner join or left outer join using tMap, I would suggest you to learn the tFlowToIterate component and read this article about how to doing inner join on tMap.
https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta-p/21572

Please learn the scenarios and do some exercises, let me know if you have any questions.

Regards
Shong

topic Re: SF-DB2 in Talend Studio

SF-DB2

Re: SF-DB2