JDBC Driver for Microsoft SharePoint

Build 22.0.8462

AuthScheme

The scheme used for authenticating to SharePoint.

Possible Values

AzureAD, AzurePassword, OAuthJWT, AzureMSI, PingFederate, ADFS, OneLogin, Okta, OAuth, SharePointOAuth, NTLM, Basic, Negotiate, None

Data Type

string

Default Value

"NTLM"

Remarks

If authenticating to Sharepoint On-Premise instance, together with Password and User, this field is used to authenticate against the server. NTLM is the default option. Use the following options to select your authentication scheme:

  • NTLM: Set this to use your Windows credentials for authentication.
  • Negotiate: If AuthScheme is set to Negotiate, the driver will Negotiate an authentication mechanism with the server. Set AuthScheme to Negotiate if you want to use Kerberos authentication.
  • None: Set this to use anonymous authentication; for example, to access a public site.
  • Basic: Set this to use HTTP Basic authentication.
  • ADFS: Set this to use Single Sign-On authentication with ADFS.

If authenticating to Sharepoint Online, OAuth is the default option. Use the following options to select your authentication scheme:

  • AzureAD: Set this to perform Azure Active Directory OAuth Authentication.
  • AzurePassword: Set this to authenticate using OAuth with Password GrantType.
  • OAuthJWT: If AuthScheme is set to OAuthJWT, the driver will try to connect with a self signed certificate with Azure AD.
  • PingFederate: Set this to use Single Sign-On authentication with PingFederate.
  • ADFS: Set this to use Single Sign-On authentication with ADFS.
  • OneLogin: Set this to use Single Sign-On authentication with OneLogin.
  • OKTA: Set this to use Single Sign-On authentication with OKTA.
  • OAuth: Set this to use OAuth 2 authentication with GrantType CODE or PASSWORD.
  • AzureMSI: Set this to automatically obtain Managed Service Identity credentials when running on an Azure VM.
  • SharePointOAuth: Set this to use OAuth authentication with Sharepoint APP for Client Credentials.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462