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.


    • Related Articles

    • Excel Add-ins. Slow Data Extraction (Database Providers)

      This article is for Excel Add-ins (Databases). Navigation: Supported Data Sources → Supported databases: Data loading into Excel may work noticeably slower compared to executing the same query in other tools. Performance can be improved by adjusting ...

    • Loading Data from Excel

      This article is for Excel Add-ins. Excel Add-ins can be used to work with external data sources and update data directly in Excel. A common question is whether it is possible to load arbitrary data from an Excel worksheet into a connected database or ...

    • Excel Automation

      This article is for Excel Add-ins. The scenario involves building an automation system based on Devart Excel Add-ins, with data transfer between different sources, synchronization, and automatic data updates. Solution Devart Excel Add-ins are ...

    • Devart tab disappears in Microsoft Excel

      Microsoft Excel may disable Add-ins automatically if errors occur or if they take too long to finish their operations. However, you can re-enable the Add-ins without needing to restart your operating system. For this, follow the steps below: Open ...

    • How to Enable Logging for SSMS Add-ins Without Built-in Logging

      Logging is essential for diagnosing complex issues and capturing technical details that may not be immediately visible through the user interface. When troubleshooting failures or unexpected behavior in SSMS add-ins that do not provide built-in ...