Salesforce Interface Schema (SFI)
The Salesforce Interface Schema contains objects related to the running of the download. These include:
- sfi_log_execution – log table that is updated once every time a sf_download command is run
- sfi_log_task – log table containing all the tasks carried out during an execution
- sfi_settings – global settings set when the database was initialised. These include the credentials for the source Salesforce Instance
- sfi_object_last_download_v – provides the date each object was last, successfully download to SQL.