SDDMS Architecture

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 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 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. 

SDDMS Components

The following functions 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.