We have a couple of use cases where we need to sync a subset of the information in one database and mirror it into another.
Been looking at the entity sync capability that is present in ofbiz. Very good start, ability to build a sync set that is a collection of entities to sync (pull or push) between delegators (or service). In my case, I need to create the nest of entities to consider for the sync, but I need to restrict the rows from some starting point. Use case 1: Want to import a collection of parties from one system along with their relationships between the set of parties and their contact info, notes, preferences, etc.... Use case 2: Create a product category, rollups, and then associate products to that category. Want to publish this category, products, and subset of pricing, product content, features, etc.... to other instances. Looks like a modification to entity sync is required to do this? or am i mistaken. Modification involves: - build set of entities in sync group - add condition restrictions on possibly any number of entities for candidate rows. (category_id = 'x') - "soft" inclusion by foreign key reference from a row in the set to one that is not explicit. - alter row for foreign key references outside of entity set to null or to rows that cannot be replicated. I'm sure more precision is needed here and will to do the work. Just wanted to see if others have similar use cases and if so, what they have done. Marc Morin Emforium Group Inc. ALL-IN Software™ 519-772-6824 ext 201 [email protected]
