Who would have thought that one day a global pandemic will force every single nation in the world to put its entire focus on only one industry which is healthcare & pharmaceutical in literally no time? Healthcare & pharma has been a dynamic industry & perhaps one of those very few industries which demand consistent innovations & enhancements. The industry has endured massive developments specifically in the last few years & undoubtedly the most transformed system in history.
The customer is the undisputed leader of pharma with over 7 billion people accesses to its high-quality medicines. They have an aggressively growing portfolio of 7500+ products with a gigantic footprint in over 165 countries.
The new generation of healthcare services & drug development requires the power of technology. Technology makes the entire process streamlined & fast. To drive intelligent engagement in the era of Cloud computing, our customer was using the world’s #1 life science CRM Veeva to deliver best-in-class customer engagement along with personalized customer experience across channels. Offering integration with the Salesforce platform, Veeva today has a strong 800+ customers from healthcare, life science & pharma verticals.
After entirely reviewing the customer org & their data system, we identified the objects that are the primary sources of their data growth & prepared a complete archiving roadmap with the implementation milestones. Here are some of the impediments that we experienced while jotting down the implementation plan.
Veeva comes with an extremely complex object model (Many-to-many Junction Object Model, Self Lookups). So the archiving action is required to take care of the data integrity, object hierarchy without losing any data.
The customer org has two types of records: Locked & Unlocked. Archiving action can only be performed on the records which are unlocked. In order to archive the records which were locked, it was required to change the status to unlock & run the archiving action. The entire process required automation from the archiving solution end.
There were around 30 child objects in the customer org including Call Detail, Call Discussion, Event, Note, Medical Discussion, Task, Survey Questions, Event Attendee, Supervisor Comment which were required to bypass the archival action due to various custom/packaged triggers & validation rules against delete.
Due to the large business unit & teams, the customer org has a long parent-child object hierarchy. The archiving batch size was a big concern as there were high possibilities of hitting Salesforce governance limits. Any archiving action might result in governance violation as well as shattered data integrity.
After identifying the challenges, our Salesforce platform & data management experts rolled out the implementation strategy by taking care of each of the above-mentioned road blockers.
How? Let’s have a sneak peek.
To understand the business, org data systems, data dependencies, future data goals, archival needs, and object configurations better; our account managers & solution engineers associated with 20 stakeholders from multiple departments for requirement gathering. The sole objective was to offer the best solution which can meet the exact archival goals.
With our certified & highly experienced Salesforce platform & data management experts, we took the entire ownership of the end-to-end project management & delivery starting from requirement gathering to planning, execution, customization, performance & control, test & GO LIVE. The entire implementation across 3 orgs took 12 weeks.
With additional customization on top of the AppExchange package, using a flag-based mechanism and archiving API, we were able to maintain the complex parent-child object relationships.
Through custom settings in the AppExchange package, the archiving job was not applicable on those child records where custom trigger/validation rules were not permitted to delete records.
With additional customization on the top of the AppExchange package, all the records falling under the archiving filter criteria were unlocked automatically by the app & then the archiving job was executed.
We specified archiving batch size for respective objects (E.g Order – 200, Order line – 200, Medical Event – 100, Event Attendee – 100, Cycle Plan – 5, etc.) in the archiving policy keeping the governance limit in mind.
DataArchiva was indeed a savior. The customer was not only able to quick-fix their Veeva data storage woes, but also meet their complex archiving needs without any hassle. Optimized storage allowed them to save over 85-90% of storage costs, improved the overall application performance & helped them to retain the entire org data to address compliance & other internal data retention policies.
Please ask us about Salesforce or Veeva CRM data management, or discuss your unique use case – our highly skilled data management experts are standing by, ready to help.
DataArchiva is the ONLY Native Data Archiving Solution for Salesforce using Big Objects that help Salesforce application users archive their historical data without losing data integrity.
For more info, please get in touch with us firstname.lastname@example.org
Talk to our Salesforce Data Management Experts about your unique data archiving needs & how to maximize ROI with a modern approach