You need to sign in to do that
Don't have an account?
How to dump Account, Contact, Opportunity to local database
Hi,
I am new to SalesForce. I know ASP, VBscript, MSSQL db, and some PHP and MySQL. I would like to know if there is a way to dump the Account, Contact, Opportunity to a local MSSQL database? I have been searching for last few days in the forum, but couldn't find any good document show me how to accomblish this. The biggest thing is I have no clue how to connect to SalesForce data, then query Account, Contact, Opportunity, then after that I know to INSERT those data in the local MSSQL database.
Anyone has example if the VBScript, ASP.... anything would help?
Thanks,
Steven
I would start with the getting started guide in the API docs. http://www.salesforce.com/us/developer/docs/api/index.htm
There are also existing tools / products like the Data Loader and ForceAMP that can make this easier (very easy in the case of ForceAMP)
Thanks Simon,
I followed the document and this is where I am stuck. After I clicked "generate Enterprise WSDL". it generates a XML file.
"---------------------------------------------------------------
"---------------------------------------------------------------
Later, it referes to use "Add Web Reference" and point to "enterprise.wsdl" file? I am not sure how to convert the XML file above to "enterprise.wsdl" file?
"
To add a Web reference:
file:///c:\WSDLFiles\enterprise.wsdl
"
Please help,
the XML file you downloaded is the enterprise.wsdl file.
Thanks Simon,
I am using MS Visual Web Developer 2010 express. So i was able to "Add Web Reference", and right-click at the project name, the select Add Reference as instruction below (step# 5), but could find where I can browse to the XML Web Service?
-----------------------------------------
To add a Web reference:
file:///c:\WSDLFiles\enterprise.wsdl
-----------------------------------------
Please help,
Add Reference is not the same as Add Web Reference. In the newer versions of VS, i believe its add Service Reference -> advanced -> add web reference.
Simon, really ppreciated you're helping me on this. I am little confused.
I already "Add Web Reference" and pointed to the enterprise.wsdl file. So in VS Solution Explorer shows, sforce under Web References. According the instruction step# 5, it said I need to add another one using "Add Reference"? or do you think I only need the "Add Web Reference", which I already did?
Thanks again,
You only need to add the web reference.