Retrieving Salesforce Metadata

Retrieving Salesforce Metadata

DBAmp retrieves Salesforce metadata information in two ways:

  • SF_Metadata—a DBAmp stored procedure that accesses the Salesforce Metadata API

  • tooling tables—tables within the Salesforce Tooling API

Note that if you use SF_Metadata:

  • The metadata is returned to an XML type column in Salesforce. You must know about the XML column type and be able to use XQuery expressions in SQL SELECT statements.

  • SF_Metadata implements the Salesforce Metadata API LIST and RETRIEVE functions. These functions require specific type and member inputs as defined in the Salesforce Metadata API Developer Guide.

You must have an understanding of metadata types as described in the Salesforce Metadata Developer API Guide.