23 Oct 2012
21 Sep 2011
Link to this post
I want to keep my products in sync with some other backend system. The other backend system will likely contain a subset of the product fields defined in Sitefinity.
I see some solutions:
1: use some synchronization process in the background (SQL Server replication, Microsoft Sync Framework or whatever). Updates on shared fields would be possible on both sides. Adding new products can be a problem when there are required fields with no defaults on one of the both sides.
2: or created an inherited data provider of OpenAccessCatalogDataProvider. On the CommitTransaction() the appropriate actions should be done on the other backend system. (Is this even possible? What about doing this as one transaction on the 2 databases? In this would be a distributed transaction). This whould imply that the products should be maintained from Sitefinity always.
Any suggestions about a good solution?
Does somebody see other solutions?