MSSQL to Salesforce (Lookups)

[Anonymous]

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!

[manodwhb · Accepted solution]

@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.

[Anonymous]

Thank you!! @manodwhb 

EDIT: Nevermind, figured it out!

[manodwhb]

@Zykros ,great.