function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kubilaykubilay 

Informatica on Demand Data Loader, Salesforce Custom Objects and Lookup Relationships

 

Hi 

 

I have a data integration question.

 

In Informatica on demand data loader, can I  define multiple sources of different kinds, ie. Salesforce and MS SQL Server as a "source" and then move the joined data from them to the "target" say salesforce?

 

What I would like to do is, to update with "upsert" a table in salesforce on regular basis. But for the initial load I need to get the external_id inserted in the "target" from the salesforce 

account id in the "source". So I can define the relationship. Salesforce defines relationships between objects as a "lookup". 

 

Many thanks for all your help.

 

Kubilay 

 

BoopathyBoopathy

Hi Kubilay,

 

I suppose proper mapping will help you,inserting external_id is not mandatory i think. 

Please correct if i am worng.

 

Thanks,

Boopathy 

Message Edited by Boopathy on 05-26-2009 04:54 AM