You can use DBAmp to access Salesforce.com tables as if they were SQL Server tables. This section of the DBAmp documentation deals with querying Salesforce databases. Topics include:

• Querying Basics—basic syntax and operations used in DBAmp, including the four-part naming convention and a discussion of SQL versus SOQL

• More Advanced Topics—more in-depth discussion of querying, including

  • Using DBAmp System Views—you can use system views to view object, field, relationship, and user entity access metadata of a Salesforce object.

  • Retrieving Archived and Deleted Records—typically Salesforce does not return archived or deleted records; this section explains how you can.

  • Using Column Subset Views—working with Salesforce objects that have over 325 columns of data

  • DBAmp and Salesforce API Call Counts—reducing reliance on Salesforce API calls

  • Big Objects Support—managing very large sets of data

  • Platform Events Support—connecting business processes in Salesforce to your applications using real-time event data