The DBAmp application retrieves Salesforce metadata information in two ways:

• by using the SF_Metadata stored procedure. This procedure accesses the Salesforce Metadata API.

• by using tooling tables, which are tables within the Salesforce Tooling API.

If you choose to use the SF_Metadata stored procedure, note the following caveats and requirements:

• Metadata is returned to an XML-type column in Salesforce. You must understand 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.

Note: Before you use the SF_Metadata procedure, you must understand metadata types as they are described in the Salesforce Metadata API Developer Guide.