Configuring the Cache ConnectionCData Power BI Connector for SugarCRM 2019 - Build 19.0.7354
Configuring the Caching Database
This section describes the properties for caching data to the persistent store of your choice.
The CacheLocation property species the path to a file-system-based database. When caching is enabled, a file-system-based database is used by default. If CacheLocation is not specified, this database is stored at the path in Location. If neither of these connection properties are specified, the connector uses a platform-dependent default location.
The CacheConnection property specifies a database driver and the connection string to the caching database.
The CacheProvider property specifies a database driver and the connection string to the caching database.