• August 29, 2023
  • Case Studies

Research University Gains Access to Historical Reporting Data

Download Case Study

CapStorm Helped a Research University Create an Operational Archive

This public, land-grant research university offers over 100 undergraduate and dozens of master’s and doctoral degree programs. Its state legislature legally designated it as a research university in 2003. 

Graphic of a cog in the CapStorm blue color.

Industry

  • Education
Icon of a person's silhouette in CapStorm blue.

Company Size

  • 1,000+ employees
Puzzle piece icon in the CapStorm blue color.

Specialities

  • Research
  • Administration
  • Community Service
Icon representing tech stacks in the CapStorm blue color.

Tech Stack

  • Salesforce
  • SQL Server
Blue, black and white cubes floating and falling.

Problem

The university had two Salesforce orgs and needed to utilize one for an operational database.

The university was looking for a way to have an operational archive for backup and restore for historical reporting. Along with the archive, they needed to maintain their current processes to verify Salesforce data discrepancies, and make updates to the Service Cloud. With the high volume of data they worked with, the university wanted a way to weed out the data they were not using on a daily basis, while keeping the ability to view the historical archive for a specific object or individual. 

Solution

    1. Verification & Accessibility

      CopyStorm’s solution gave the research university the ability to view data that doesn’t live inside their Salesforce orgs.

    2. Data Extraction

      CopyStorm’s ETL capabilities helped facilitate the Salesforce extract the  university uses to solve for its data visibility issues. 

    3. Leveraging Imported Data

      The CS:Enable product allows the research university to import non-Salesforce data directly into their Salesforce instance.

Graphic of white, black and CapStorm blue colored cubes stacked on each other.

Outcome

Checkmark inside of a white circle.

The research university gained an operational database that mirrors their Salesforce orgs.

Checkmark inside of a white circle.

With their new ability to process records faster, the research university has gained a higher development efficiency.

Checkmark inside of a white circle.

By accessing data from their SQL service backup, the university's leadership is now equipped with historical reporting analytics to drive improved business decisions.

Want results like this?

Schedule a Demo
Contact Us
Become a CapStorm Insider

Subscribe to the CapStorm Forecast

Name
This field is for validation purposes and should be left unchanged.