Own data seeding is the process of populating a Salesforce org with relevant test or sample data to simulate real-world scenarios. It involves carefully selecting, preparing, and loading data sets that closely match production conditions while protecting sensitive information. By using seeded data, teams can thoroughly test features, train end users effectively, and showcase realistic demos without risking production data integrity.
- Chosen approach:
- For now, the data seeding works only for Icare but it is highly recommended to use it also for Core.
- It was decided that the following objects Product, Account and Pricing Campaign have the field "Is Included in Seeding?" that indicates that these objects and its parents and children will have been moved to the new sandbox
- because the tool copies data directly from production, it is impossible to predict if the records chosen by template will not have any data errors ( for example null value for required field e.t.c). Because of that during creation of template we need to keep all automationzation but during sandbox seeding we need to disable all validations
- some objects like ccrz__E_Spec__c and ccrz__E_ProductCategory__c are not related with other objects via lookups or master details relations but via indirect relations (dependencies embedded in trigger or flow logic
- Production contains data that should not be accessible by developes/functionals. To avoid migrate these data to sandboxes the source of data seeding should be UAT env where the data is anonimized - Preparation of Production/UAT
- Records to be included in seeding (field "Is Included in Seeding?" = true) should be chosen by people who knows business and technology (Dina, Ann, Julien, e.t.c). on production and then migated to UAT when the UAT sandbox is refreshed. However for now the script has been prepared that selects these records based on data sheet that used to be used to data seeding https://aodocs.altirnao.com/?locale=en_US&aodocs-domain=solvay.com#Menu_viewDoc/LibraryId_QaWbTYEtjpk7b24jVh/DocumentId_TRPZCls0iRDCvcEAlu/ViewId_QaWbVwAysJMabBxB56 the scrip can be found here:
MarkRecordsToBeSeeding.script
The script mentioned above should be used only in situation when right records were not marked on production
- There is another data model limitation. Cases can be assigned to contracts of the accounts that belong to the same corporate group as the account to which the case is assigned
Because of this approach when we need to download all accounts from a given corporate corporate group to avoid data inconsistencies when we are inserting cases. To achieve that following script was introduced that marks them.MarkSiblings.script