CData Excel Add-In for OData 2019 - Online Help
Questions / Feedback?

Auth Scheme

CData Excel Add-In for OData 2019 - Build 19.0.7354

The scheme used for authentication. Accepted entries are NTLM, BASIC, DIGEST, NONE, NEGOTIATE, or SHAREPOINTONLINE.

Data Type


Default Value



Together with Password and User, this field is used to authenticate against the OData server. NONE is the default option.

  • NTLM: Set this to use your Windows credentials for authentication.
  • BASIC: Set this to use HTTP Basic authentication.
  • DIGEST: Set this to use HTTP Digest authentication.
  • NEGOTIATE: If AuthScheme is set to NEGOTIATE, the add-in will negotiate an authentication mechanism with the server. Set AuthScheme to NEGOTIATE if you want to use Kerberos authentication.
  • KERBEROSDELEGATION: Set this to use delegation through the Kerberos protocol. Set the User and Password of the account you want to impersonate.
  • SHAREPOINTONLINE: Set this to use SharePoint Online authentication.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0