Hi, We are trying to integrate our home grown application based on Sql Server 2000 database to Salesforce CRM application.As of now we are in premilinary phase and have just started the mapping of some of the fields that we have on both the systems.
1. In Salesforce there are some fields called as ID, AccountNumber which are 18 digits hexadecimal and are random generatred number. i.e If a record is created, a new 18 digit hex ID number and new Account number is generated for that pariticipant. In our home grown application we dont have those fields but we have a ID for each unique participant.
Question
What I need to know is the when I tried doing the test load of one record from my system into salesforce, it successfully inserted one record and automatically created an ID, AccountNumber both 18 digits for the record.But when I tried doing an update on this record, it didnt allow me to do that showing the error that the ID and Account Number field in my system cannot be null as I was passing null values in this fields(because our system does not have those fields).
Can anybody help me out as to how can we do a regular update of data from our system into salesforce without running into these issues? Any suggestions how can we map the ID number in our system with the ID and Account number of Salesforce?
We are trying to implement our Salesforce application.But before that we need to figure out a few things.
1.Which is best possible way to pull data from Salesforce Application to Sql Server 2000 database and vice versa.How do we go about it ? Please let us know if you have more than one options.
2.Should we go for a third party software which acts as a integrating tool for real time load of data bidirectionally.If so, do you have any recommendation.
3.Can we create triggers on salesforce application events which would automatically update
the Sql Server database fields.
Please let us know if anybody has had prior experience of the given situation.
