Salesforce.com Data Synchronization Tool?
March 30th, 2009
We’ve been using Relational Junction for a couple of years for data replications from Salesforce.com to SQL Server. Even though it works well we’ve been exploring other offerings namely Informatica, Reflection and Apatar. While all of these do a good job at replicating data, we can’t seem to find a service that will provide synchronization between two data stores. Here’s a fictional example of what we are looking for:
Let’s say we replicate some of our Account and Contact data to SQL Server for use on our corporate website. When someone updates a person’s email address in Salesforce.com we’d like the service to make this change in SQL Server. When a change to a person’s email address is made in SQL Server we’d like this change to be reflected in Salesforce.com. Obviously there are issues surrounding which fields are overwritten, but for simplicity we’d like the service to determine which system date is the most recent and then update the other data store with the changes.
Does anyone know of a service that performs this type of functionality?
Related posts:
- Migrating Salesforce.com Configurations with the Metadata API & Force.com Migration Tool
- Modifying Salesforce.com System Fields during Data Migration
- Salesforce Username Tip
- Deploying with the Force.com Migration Tool (ANT)
- Salesforce.com ActionSupport Component Not Calling Setters
Categories: Salesforce
Jeff,
Have you looked at Cast Iron System’s Integration Appliance (www.castiron.com)? It can perform the type of database synchronization you describe as well as tie into other enterprise systems like SAP R/3.
Thanks George! We’ll have a look! We also run multiple versions of SAP so this might come in handy. How does the integration work with with SAP? Web services? BAPIs?
Cast Iron can integrate natively with SAP using RFCs, BAPIs, or IDOCs. They also have the ability to invoke web services, so that option is available as well.
I’m a fan of the solutions from Pervasive. Contact Doug McLean at dmclean@pervasive.com and tell him I sent you. He can handle exactly what you’re talking about.
Absolutely agree with last comment. Pervasive is a cost effective and fully functional tool, we have been working with it for nearly 12 years! So contact Doug… or contact us if you want some pointers… aberger@forefrontcorp.com
This should be possible with informatica’s on demand synchronization tool. I believe they provide a free trial on their website.
Check out DbAmp (http://sites.force.com/appexchange/apex/listingDetail?listingId=a0N300000016bWzEAI). We use it at my client and they love it. It replicates out to SQL Server and we use it for our data loads where our devs load into a SQL Server table specific to that data load (similar in feel to a data loader CSV file, but a table instead) and then they run a process to upsert.