Where Does CopyStorm Keep Salesforce Metadata?

Metadata tables in a CopyStorm database are primarily copies of the equivalent Salesforce metadata calls plus mappings from Salesforce to CopyStorm names for tables and fields. These tables are the “CopyForce” tables found in the CopyStorm database.

CopyForceTable

CopyForceTable maps the Salesforce API table name to the CopyStorm created database table name. It contains the same fields as a Salesforce DescribeSObjectResult. Where possible CopyStorm uses the same name, but there are several reasons why CopyStorm may use a different table name:

  • Names that are the same as reserved words in the target database will be modified.
    • For example, User is renamed to User2 in SQL/Server.
  • Table and column name size limitations in Oracle dictate shortening longer names.

For more information, see https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_describesobjects_describesobjectresult.htm

CopyForceTableField

CopyForceTableField maps table field names to CopyStorm created field names. It contains the same fields as a Salesforce field.

For more information, see: http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_describesobjects_describesobjectresult.htm#i1427375

CopyForceTableChildRelationship

CopyForceTableChildRelationship maps parent table names to child table names. It contains the same fields as a Salesforce ChildRelationship.

For more information, see: http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_describesobjects_describesobjectresult.htm#i1427334