This simple diagram shows the various parts of the solution:
Figure 2– 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.