Hi Nikita,

Salesforce.com is a CRM application that is widely used by many corporations to manage their data and run their businesses. Connecting to Salesforce through Datastage can be done in different ways. The one im going to explain here is how to use the webservice stage and connect to the Salesforce API.

One major useful site that I found that gives a list of all the salesforce operations with the soap message structures was the developer force wiki site.

Lets take an example of the ‘upsert’ operation in the Salesforce API.  The first major task you have to do is to log into the web service by using the username and password provided. Once you call the login operation though the web service call you will get a session id and server url as a result. This will be used to connect to the API for all future activities till a logout call is issued.

You can use the xml output stage to prepare your xml message. Now one thing you have to remember is that the Salesforce Api does have some record restrictions. For example it won’t allow you to upsert more than 200 records in a call. Another example is that you wont be able to retrieve more than 2000 records using the query call. You will have to use the queryMore call to retrieve records if the result is more than 2000.

Coming back to the upsert call, you will first have to prepare the xml message(s). Now if there are more than 200 records that you need to upsert you will have to introduce some sort of batch variable to group your data into batches.

Please see the link below

http://www.dstagebox.com/2011/04/interfacing-salesforce-using-datastage-webservice-and-xml-stages/#more-8

Best Regards
Naga Kiran