CopyStorm/Director Database
CopyStorm/Director manages data about CopyStorm jobs in a relational database. Managed data includes:
- Schedules of which jobs should run.
- Status of running jobs.
- Log files and status of completed jobs.
The relational database type can be any supported by Capstorm.
See below for all tables in the CopyStorm/Director database:
| Table | Description |
|---|---|
| ApplicationCredential | Stores credential information for Salesforce and databases. Passwords are encrypted. |
| Authorities (Platform Only) | Defines the relationship between application users and permissions assigned. |
| CapStormPlatformConfig | Contains configuration information for the application. |
| CapStormPlatformDatabase | Metadata and connection information for CopyStorm and tracker databases. |
| CapStormWizardConfig | Best practice wizard state and information for creating CopyStorm jobs. |
| ConfigurationFile | Metadata about configuration files used by CapStorm products. |
| ConfigurationFileAdminLog | Information on who made configuration file changes and when. |
| ConfigurationFileVersion | Individual versions of saved configuration files. |
| CopyStormJob | Login credentials for Salesforce instances and their corresponding backup databases. |
| CopyStormGlobalConfig | Information about where to find CopyStorm and CopyStorm/Medic installations. This table also contains the location of CopyStorm configuration files. |
| CopyStormJobSequence | Supports a database-independent approach for generating integer sequence values. |
| CopyStormTask | A description and schedule for each CopyStorm or CopyStorm/Medic task contained within a parent CopyStormJob record. |
| CopyStormTaskFamily | Registered names used to group CopyStormTask records. |
| CopyStormTaskLog | Status and Log file for a single run of a CopyStormTask. This table can be used to determine which tasks have run, which tasks are running, and which tasks are orphaned. |
| CopyStormTaskLogFile | Segmented job log file information for efficient storage. |
| Group_Authorities (Platform Only) | Defines authorities assigned to specific groups. |
| Group_Members (Platform Only) | Links individual users to specific groups in the system. |
| Groups2 (Platform Only) | Stores distinct groups within the system. |
| UserPreferences (Platform Only) | Stores custom properties associated with individual users. |
| Users (Platform Only) | Stores authentication details for system users. |