Multnomah County, Oregon Saves the Day with the Help of Own
About Multnomah County, Oregon
The government of Multnomah County provides health and human services, including physical and mental health for seniors and people with disabilities, animal services, assessment and taxation, bridge maintenance, community justice, courts, elections, and a network of 19 libraries, to more than 766,000 residents across the Portland Metro area.
Multnomah County, Oregon moved over to Salesforce as part of its digital transformation strategy, specifically to be able to develop applications much more rapidly. In the last year, they have already built three applications on Salesforce, with the fourth underway. Multnomah County’s Salesforce platform is used by the Health and Human Services and Land Survey departments. The county’s public health team collects information from county partners on the types of services they provide to county residents. For environmental health, the team tracks requests from county residents who want to test for lead in their water. The Land Survey department creates work orders directly through Salesforce.
Salesforce Supports Multnomah County’s Developing Digital Transformation Strategy
Highlights:
- Removing data caused Multnomah County to experience an unexpected cascade of deletions.
- Multnomah County discovered that recovering lost data with Salesforce Weekly Export can take weeks.
- See how Own helps Multnomah County speed up its data recovery.
It Took Multnomah County 80 Hours Over 5 Weeks To Restore Using Weekly Export
As part of a data cleanup, the IT team removed historic data. Several days later, they were asked to restore some of the records. By then it was too late to simply restore the data from the Recycle Bin. The cascading deletion had permanently removed thousands of historic records from Salesforce servers. They had no choice but to figure out how to manually restore the lost data using their Salesforce Weekly Export backup files.
The IT team quickly found out that restoring lost data with the Weekly Export would be a time-consuming challenge. Like many teams facing this situation, Multnomah County searched for instructions online. They used Own’s “7 Steps to Restoring Lost Data Using Salesforce Weekly Export” eBook, which guided them through the process of first understanding their Salesforce data schema, understanding the database dependencies of the data within the schema, and documenting the order of operations for data recovery. After almost 80 hours over the course of five weeks, the IT team successfully restored the deleted data and all related records.
Proactive Data Protection Management And Monitoring With Own
Multnomah County’s IT team started searching for a more efficient data protection solution so that they would never have to go through a tedious recovery scenario again. After evaluating multiple companies, Multnomah County chose Own as its backup and recovery vendor because of its fast, easy-to-use, data loss and corruption capabilities.
Another useful capability for Multnomah County is Own Accelerate. The county’s development team frequently creates and deprecates multiple sandbox environments, often with varying object dependencies. Accelerate, a sandbox seeding solution, allows county developers to rapidly evaluate objects and their dependencies and to filter, preview, and replicate the perfect test set data into a target sandbox.
Own Is Not Just A Backup Solution
With Own, Multnomah County’s IT team has sped up their admin and development operations significantly. The following capabilities have been particularly important to Multnomah’s digital transformation success:
- Daily data and metadata backups
- Recover data and metadata at any level of granularity
- Smart Alerts for proactive data monitoring
- Visual data change analysis
- Sandbox Seeding
