TIBCO Data Virtualization® Adapter Online Help > Using the Salesforce.com Adapter > Salesforce.com Limitations
 
Salesforce.com Limitations
Query Limitation
Salesforce.com has limitations on queries. Performance issues will occur if you do NOT restrict the number of results.According to the Salesforce.com documentation, the expected limit on query results is 2,000. However, that limit is subject to change with each version of Salesforce.com, you are responsible to determine what the current limit is for your version of Salesforce.com and adjust your query limits as necessary.
Queries to Salesforce need to include a WHERE clause that restricts the number or records to that limit. For example, 2,000. Otherwise, the queries can time out or performance is adversely affected.
Application Views for Salesforce.com
The organization of the pre-built application views and folders in the Salesforce.com Adapter is patterned after the user interface of an uncustomized Salesforce.com account. Each folder within the DataServicesForSalesforce.com folder corresponds to a tab in Salesforce.com. Each view within the folder corresponds to one of the default views in Salesforce.com.
Filter Data from Application Views
There are two ways to filter data from Salesforce.com using application views:
• using a filter provided by Salesforce.com itself
• by filtering within TDV.
For more information about filters, refer to TDV SQL Support for Salesforce.com.