Specifies the path to the cache when caching to a file.
"%APPDATA%\\CData\\ExcelServices Data Provider"
The CacheLocation is a simple, file-based cache. The connector uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR file to the classpath. The JAR file, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.
If left unspecified, the default location is "%APPDATA%\\CData\\ExcelServices Data Provider" with %APPDATA% being set to the user's configuration directory:
|Windows||The value of the APPDATA environment variable|