asked on

Looking for advice on Salesforce.com/SQL Server integration and data replication

I'm looking for some advice from developers/administrators that have used Salesforce as a data replication tool. We are attempting to port over a list of contacts from a vanilla SQL Server instance into Salesforce - the SQL Server instance currently drives a website, stores user preferences, passwords, etc., and Salesforce will be used to carve out contact lists based on demographics and other criteria, and add those users to campaigns.

Currently, our plan is to do a nightly sync of our SQL Server data with Salesforce to update the contact data. Additionally, if a user is added to a campaign through Salesforce, we want to be able to push that data back into our SQL Server instance as well (so the contacts can see what campaigns they've been added to, for instance).

We also have a number of custom tables in SQL Server that we want stored in Salesforce - this will probably be done with a number of custom objects, unless there's a better approach.

Does anyone have any experience with this - data replication back and forth with Salesforce? We've found a product called DBAmp, made by a company called ForceAmp - i don't have any experience with it, but it looks pretty full-featured, and i'm trying out the demo now. Any other suggestions?

Thanks,
Matt

ASKER CERTIFIED SOLUTION

Bill-Hanson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

velir

ASKER

This has generally been our experience with Salesforce so far - we were able to find a third-party Salesforce guru who has been able to provide some guidance. It's unfortunate that the Saleforce documentation isn't more complete, or that this functionality isn't native to Salesforce - seems like a common operation, and something that might be useful to a number of users.

advlgx

dbAmp is the way to go. I've written custom ASP.NET web sites that easily read insert update delete salesforce records using this product. If you know SQL Server it's a simple 2 day learning exercise to get acustomed to using it.

james10004

Has anyone also used Avantia's DBSync

ajshanker

can some post a asp.net code to commnucate between salesforce and sql server

pauldesatadvologixdotcom

dbAmp. Great product, Great price. Great support. If you can write SQL and understand stored procedures(ie. you don't need a pretty GUI point and click interface), it's the way to go.

Used it many times in many situations.

If you're looking for the point and click, try searching at www.appexchange.com for informatica. They have several integration product options, one's even free.