topic MSSQL to Salesforce (Lookups) in Talend Studio

MSSQL to Salesforce (Lookups)

Anonymous — Sat, 16 Nov 2024 04:11:15 GMT

Hi!

So I've run into a roadblock.

I have a MSSQL input > output salesforce object (account)

But i want to run a lookup to get the ID of another object (product2) in salesforce depending on the value of MSSQL input to output to salesforce account

How can I do this?

Thank you!

Re: MSSQL to Salesforce (Lookups)

manodwhb — Mon, 04 Nov 2019 06:05:42 GMT

@Zykros ,there are two ways.

1) one way you have to read separately that object using tSalesforceinput and do the lookup in tMap or tJoin ,the primary table would be tMSSQLinput do join and populate to tsalesforceoutput

2) Second way would be , you can do in Relationship mapping for upsert in the advanced setting of tSalesforceOutput,tSalesforceOutputBulk,tSalesforceOutputBulkExec.

Re: MSSQL to Salesforce (Lookups)

Anonymous — Mon, 04 Nov 2019 13:32:32 GMT

Thank you!! @manodwhb

EDIT: Nevermind, figured it out!

Re: MSSQL to Salesforce (Lookups)

manodwhb — Tue, 05 Nov 2019 04:57:34 GMT

@Zykros ,great.