Advanced Features
This section details a selection of advanced features of the Microsoft Excel Online provider.
User Defined Views
The provider supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .
SSL Configuration
Use SSL Configuration to adjust how provider handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .
Firewall and Proxy
Configure the provider for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.
Caching Data
Caching Data enables faster access to data and reduces the number of API calls, improving performance. The connector supports a simple caching model where multiple connections can also share the cache over time. When configuring the cache connection, you can specify automatic or explicit data caching.
Query Processing
The provider offloads as much of the SELECT statement processing as possible to Microsoft Excel Online and then processes the rest of the query in memory (client-side).For further information, see Query Processing.