This agency protects the state’s most innocent citizens with services supporting children and families. While many similar agencies in other states are operating on antiquated systems, even with manual paper records, this technology driven group adopted Salesforce in order to streamline operations and best support citizens. Fulfilling the agency’s mission requires a veritable mountain of documentation, and it was no easy task to transition from a legacy system into Salesforce. The custom buildout alone of the Salesforce Org took over three years, with scheduled metadata deployments continuing well after go live. CapStorm helped protect this Salesforce Org during the implementation, served as a complement to Salesforce Einstein, and helped enhance analytics with incremental replication of data, metadata, and structure to the agency’s own relational database.
The agency had three key objectives for a solution: (1) protect both the data and metadata of the Salesforce organization against accidental loss or corruption, (2) cleanse sensitive data prior to integration with Salesforce Einstein, and (3) enhance reporting with complex analysis that could not be performed natively in Salesforce. As an added complexity, the data stored in this Salesforce organization is highly sensitive, containing PII for thousands of citizens along with documentation required by both state judicial and federal government. Other integration solutions simply could not handle the high number of custom objects and data volume in this Salesforce environment or meet the federal compliance requirements.
Reduced risk with a secure Salesforce data and metadata backup strategy.
Increased data insights with the ability to integrate into any out-of-the box reporting solution.
Improved efficiency with a set-it-and-forget-it solution that automatically keeps an Oracle database in step with the current state of Salesforce.