Excel Add-ins. Slow Data Extraction (Cloud Providers)

Excel Add-ins. Slow Data Extraction (Cloud Providers)

This article is for Excel Add-ins (Clouds).

Navigation:  Supported Data Sources → Supported cloud applications:

​

When working with Excel Add-ins connected to cloud sources such as Salesforce or QuickBooks, data loading may be noticeably slower than expected. In many cases, the delay is related to the way queries are processed through cloud APIs. The sections below describe the most common reasons for this behavior and the available configuration options.

1. Some SELECT statements take a long time because the WHERE condition cannot be converted directly to API calls. In such cases, all table data is fetched to the local cache, and the statement is executed locally.
2. Some objects or fields are aggregated. To retrieve them, the connector must perform multiple API requests, each fetching a row, which significantly increases execution time.
3. If values of such fields are not required, exclude them from the query.
4. Due to API limitations, this behavior cannot be improved.

Local SQL Engine option

Cloud connection managers include the Local SQL Engine option (True by default).

1. If set to False, only SQL expressions natively supported by the API are allowed. Such queries execute more efficiently, although the range of permissible expressions is significantly reduced.