Designing queries to extract data from Salesforce.com

You can create and customize queries to extract data from Salesforce.com.

The Pack for Salesforce.com uses core calls to the Apex Web Services API and the Sforce Object Query Language (SOQL) SELECT statement to query and extract data from Salesforce.com. You can browse and select metadata to automatically generate a SELECT statement, and then edit the command to add WHERE and ORDER BY expressions, and other conditions supported by SOQL.

For details about Salesforce.com core calls and Sforce Object Query Language (SOQL), go to http://www.salesforce.com/us/developer/docs/api/index.htm.

You can design an extraction program that:

• Extracts all data from the objects in your Salesforce organization.
• Extracts only a subset of fields from the objects in your Salesforce organization.
• Extracts only the data that has changed since the last time a particular extraction ID queried the data.
• Extracts only the data that has been deleted since the last time a particular extraction ID queried the data.

Designing queries

You use the Query or QueryAll utility calls to extract all or some of the data from your Salesforce.com organization. You can browse for and select Salesforce.com metadata to automatically generate the SELECT statement used in the query. You can add filtering and sorting to the query by editing the SELECT statement.

Designing delta extractions

You use the getUpdated and getDeleted utility calls to extract only the data that has changed or been deleted in a specified time frame. The default time frame is the period since the last extraction by the specified extraction ID, up to 30 days. You can browse for and select the Salesforce.com object that you want to extract.