Architecture Overview

This simple diagram shows the various parts of the solution:

Architecture Overview

• SDDMS console application is executed, typically from a scheduled task. What is then processed is determined by the runtime parameters and/or settings in the configuration file.
• Data Export zip files are exported from Salesforce and stored in a known location on the local file system. The zip file contains the CSV Data Files. Salesforce schema is also pulled from Salesforce, to be further used in database generation.
• The Database Generation Application can either interrogate Salesforce through the Partner API for the data schema or use the Salesforce schema pulled while exporting data and then creates a database and populates the database with data from the CSV Data Files in the zip files downloaded.
• The Dynamic Web Application is responsible for providing the Create, Read, Update and Delete functionality to the database.