2
  1. What is the best way to implement a Batch process between MS-SQL and Salesforce?
  2. How to get the data from MS-SQL to Salesforce using any tool or webservice?

Are there any materials to learn about these topics?

closed as too broad by Samuel De Rycke, Sergej Utko, Keith C, Alex Tennant, Chris Duncombe Sep 15 '14 at 13:28

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What do you have on top of the MS-SQL database? If it's a .NET site then maybe this will help - developer.salesforce.com/page/… ? – Boris Bachovski Sep 15 '14 at 6:38
  • Thanks for your comment @Bachovski, I need a SQL Server Integration with Salesforce materials..Because I am a newbie for this topic so kindly help on this.. – Venkatsforce Sep 15 '14 at 6:44
  • 1
    Your question is too broad, please try to narrow it, add some code samples, what you tried, where you read, etc.. as it stands, it is flagged for closure, please try to edit it, and improve it. – Saariko Sep 15 '14 at 11:26
1

There are many ways of achieving that, it really depends on your requirements and complexity. There is a similar question asked on this site previously, so hopefully one of the answers will give you a starting point of how you can proceed.

Other tools that you can use apart from JitterBit and Informatica are Pervasive, Zapier and I guess there are many more, so it's really up to you which one you're going to chose.

  • Thanks for your support @Bachovski, Now I get some ideas about this topic. – Venkatsforce Sep 15 '14 at 6:59
1

I've used DBAmp in the past. It got the job done, but as the integration got more complete over time parts became less ideal.

For future integration projects I went with a .NET service working directly with the Salesforce APIs that could move the data as required. I found this easier to handle the sessions, map the data and handle exceptions that might occur. It was particularly important to consider how many API calls were occurring and how this would scale with the number of records being synced.

0

You can use Informatica Cloud or Bhoomi or a similar Integration service provider. Informatica Cloud worked well for me. You can also roll out a custom service written in Java or .NET built on top of Salesforce SOAP API + Bulk API.

Not the answer you're looking for? Browse other questions tagged or ask your own question.