Pharma (Veeva)

Global Pharma Leader Reimagines Next-gen Data Management Experience across 3 Veeva Orgs with Enterprise Archiving

Customer Overview

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.

Leading the Way to Better Healthcare

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.

The Unprecedented Acceleration in Data Generation & Need for Archival

  • The customer has three Veeva Orgs considering their large-scale business units across multiple verticals & continents.
  • After using the Veeva CRM for a certain period of time, the company has started experiencing data growth from multiple objects & it was a warning bell for them looking at storage limitations. 
  • With an extremely complex org having multiple standard & custom objects, junction objects, self-lookups; it was tough to find the best way to optimize the org to maintain performance.
  • Some of the top sources of data growth were (Parent Objects) Call, Sample Limit, Survey, Medical Event, MC Cycle, etc.
  • Finding out the best way to archive old & unused records to secondary storage maintaining the object relationships was the most feasible option & this required a robust solution to do.

The Speed-breakers in the Journey to Efficient Data Management

Our client was making extensive use of the Salesforce Service Cloud to handle their customer service & support. After multiple years of use, their case object had grown exponentially resulting in high Salesforce data growth reaching about 20GB in no time & still growing at a rapid speed.

The Complex Object Relationships in the Veeva CRM

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.

Record Status Based Archiving

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.

How the Complex Object Relationships Were Taken Care of While Archiving?

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.

How the 30+ Child Records were Unscathed While the Archiving Job was Running on Their Parent Records?

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.

A View from the Top: Improving Salesforce Data Management with
Next-gen Archiving Capabilities

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.

How were We Able to Offer What They Want?

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.

From Requirement Gathering to GO LIVE

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.

Archival Action Against a Few Child Objects

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.

Salesforce Governance Limit

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.

How the Locked Records Got Archived?

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.

How the Customer Maintained Salesforce Governance Limits?

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.

On the Right Path

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.

Want to learn more? Weโ€™re more than happy to help you!

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  contact@dataarchiva.com