The type of authentication to use when connecting to remote services.
The following options are generally available to all connections:
- None: Uses no authentication.
- Basic: Uses Basic authentication with User and Password.
- Auto: Determines the right type of authentication to use based on the service. Local files and HTTP will use None.
The following options are available when URI refers to a web service:
- Digest: Uses HTTP Digest authentication with User and Password.
- NTLM: Uses NTLM authentication with User and Password set to your Windows credentials.
- Negotiate: Negotiates with the server to determine an authentication scheme. Typically used with Kerberos, which requires KerberosKDC, KerberosRealm and KerberosSPN.
- OAuth: Uses either OAuth1 or OAuth2, with the specific flow being determined by the OAuthGrantType. OAuthVersion must be set to determine what version of OAuth is used.
- SSL: Uses SSL client certificates to authenticate. Requires that URI be set to an HTTPS URL and that SSLClientCert and SSLClientCertType be set.
The following options are also available when URI points to an Amazon service:
- AwsRootKeys: Set this to use the root user access key and secret. Useful for quickly testing, but production use cases are encouraged to use something with narrowed permissions.
- AwsIAMRoles: Set to use IAM Roles for the connection.
- AwsEC2Roles: Set this to automatically use IAM Roles assigned to the EC2 machine the CData ADO.NET Provider for Excel is currently running on.
- AwsMFA: Set to use multi factor authentication.
- AwsOKTA: Set to use a single sign on connection with OKTA as the identify provider.
- AwsADFS: Set to use a single sign on connection with ADFS as the identify provider.
- AwsTempCredentials: Set this to leverage temporary security credentials alongside a session token to connect.
- AwsCredentialsFile: Set to use a credential file for authentication.
The following options are also available when URI points to an Azure service:
- AzureAD: Set this to perform Azure Active Directory OAuth authentication.
- AzureMSI: Set this to automatically obtain Managed Service Identity credentials when running on an Azure VM.