This city hosts the headquarters of many of the world’s largest companies and is one of the fastest growing cities in the United States. The constant drive for streamlined technology brought the city to Salesforce, and utilization of Salesforce solutions continues to increase each year. CapStorm’s partnership supports much of the city’s reporting in order to achieve near real-time Salesforce data insights.
Multiple key Salesforce production organizations support various divisions of this city government. Each Salesforce was structured differently, tailored to the division’s requirements. Data volumes grew rapidly with the introduction of a 311 Citizen service request portal, support for code compliance, and utilization by city management. The data volume and multi-org architecture make the built-in report writers inefficient and cumbersome. Native CSV Salesforce data extract outputs were time consuming and created a data format that was difficult to use. CapStorm enabled near real-time analytics while also adding a layer of data protection to ensure business continuity.
Salesforce data from each Production organization is extracted incrementally to the city’s relational databases in increments as frequent as every 5 minutes. Multiple extraction configurations can be maintained, ensuring that key data is replicated on the city’s defined frequencies, while less critical data is replicated on a slower cadence. The incremental Salesforce data extract uses a minimal number of Salesforce API calls as only the delta data changes are copied.
Each replication copies new and modified Salesforce records along with any structure changes that occurred since the last data extract. This dynamic structure replication includes new Salesforce objects, fields, packages – along with the data. Since the schema is a 1:1 match with Salesforce, the databases create a seamless feed of data into the city’s data lake, to Tableau for data visualization, and to a citizen facing portal.
Each database sits behind the city’s firewall on their own infrastructure. The city maintains control over data access and utilization with total discretion over what Salesforce data is backed up and at what frequency. Each Salesforce data replica also acts as dynamic ransomware protection, ensuring that the city can continue operations in the unlikely event of a Salesforce data breach.
Streamlined reporting with right time, right place data from multiple Salesforce Organizations.
Dependable stability with set-it-and-forget-it solutioning that automatically mirrors Salesforce schema changes.
Increased security with on-premises data replication and controlled data access.