There is a business need to ensure data in Salesforce can be accessed and used, albeit is a simple form, if a critical event renders Salesforce inaccessible.
This document outlines an implementation strategy to use FuseIT’s SDDMS solution to create web based snapshots of Salesforce data on a local or cloud based server. SDDMS creates a SQL Server database and, optionally, an associated ASP.NET web application for accessing a the snapshot of Salesforce production data extracted through a regular data export. SDDMS is comprised of a console application (FuseIT.SDDMS.exe) that queries a configuration file to determine if one or more of three functions should occur – see the following diagram.
Figure 1– SDDMS Components
The following functions do the following action these processes:
- FuseIT.G4S.DataExport: Pulls data exports from Salesforce.
- FuseIT.SDDMS.DatabaseGeneration: Creates a new SQL Server database and populates it with data in the data export.
- FuseIT.SDDMS.DynamicWebGeneration: Creates a website exposing the data in the SQL Server database for create, read, update and delete operations.
...