Excel Add-In for MySQL

Build 25.0.9434

AuthScheme

Specifies the authentication scheme used to connect to the data source. This determines how the user or application credentials are validated. Choose an option supported by your MySQL server database.

Possible Values

Password, NTLM, AzureAD, AzurePassword, AzureMSI, AwsIAMRoles, AwsEC2Roles, LDAP

Data Type

string

Default Value

"Password"

Remarks

This property controls how authentication is performed. The following authentication schemes are supported:

  • Password: Basic authentication using a username and password. This is the default and most widely supported method.
  • NTLM: Windows-integrated authentication for environments that use Active Directory.
  • AzureAD: Authenticates using Azure Active Directory's device code or interactive flow. Suitable for client-side applications without needing a username/password.
  • AzurePassword: Authenticates with Azure AD using a username and password (requires app registration with proper permissions).
  • AzureMSI: Uses Azure Managed Identity (MSI) for authentication, allowing applications running in Azure (for example, VMs or App Services) to authenticate without secrets. Requires platform support.
  • AwsIAMRoles: Authenticates via AWS IAM Role assumption using configured credentials or profiles. Suitable for secure, temporary access within AWS environments.
  • AwsEC2Roles: Automatically uses the IAM role assigned to an EC2 instance for authentication. Ideal for serverless and cloud-native applications.
  • LDAP: Authenticates against an LDAP server using standard LDAP credentials (username/password). Often used in enterprise environments.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434