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?
