TIBCO Spotfire Connector for Salesforce only imports 2000 rows from Salesforce Report to TIBCO Spotfire

TIBCO Spotfire Connector for Salesforce only imports 2000 rows from Salesforce Report to TIBCO Spotfire

When opening data in TIBCO Spotfire which is based on the TIBCO Spotfire Connector for Salesforce connecting to a Salesforce Report, a maximum of 2000 rows are returned. A connection to a Salesforce Table does not see this behavior where the rows are truncated. This is due to a limitation in Salesforce.com. See the reference Loading Data from Salesforce.

This is also documented on the SIMBA site:

"* Query processing is not optimal when GROUP BY returns large result sets.

Normally, when a result set exceeds 2000 rows, the driver will use the queryMore() call and a server-side cursor to retrieve additional rows in 1000-row chunks. Doing so allows the query to be processed efficiently. However, if the query contains a GROUP BY clause, then queryMore() cannot be used. In this case, you must change the filtering conditions to query data in smaller chunks."

Additionally, there is an existing enhancement request on the TIBCO Ideas portal that you can vote for:

• https://ideas.tibco.com/ideas/TS-I-6045.

• https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/salesforce/salesforce_loading_data_from_salesforce.com.htm

• http://cdn.simba.com/products/Salesforce/doc/Simba_Salesforce_ODBC_ReleaseNotes.txt

• https://ideas.tibco.com/ideas/TS-I-6045