CredentialsLocation
The location of the settings file where MFA credentials are saved.
Data Type
string
Default Value
"%APPDATA%\\CData\\Excel Data Provider\\CredentialsFile.txt"
Remarks
MFA credentials are short-lived and typically expire after an hour. At that point, you must specify a different MFAToken to continue connecting. MFA tokens only work once, so in the case of multi-threaded or multi-process applications, the credentials must be centrally located and shared to avoid problems. When MFAToken is not specified, this property does nothing.
If left unspecified, the default location is "%APPDATA%\\CData\\Excel Data Provider\\CredentialsFile.txt" with %APPDATA% being set to the user's configuration directory:
Platform | %APPDATA% |
Windows | The value of the APPDATA environment variable |
Mac | ~/.config |
Linux | ~/.config |