The user account used to authenticate.

Data Type

string

Default Value

""

Remarks

The name of a user account associated with the Microsoft Excel database you want to connect to.

The User and Password connection properties, if they are applicable to the current ConnectionType and AuthScheme, are used together to authenticate to the service or platform containing your Microsoft Excel files.

This property will refer to different things based on the context, namely the value of ConnectionType and AuthScheme:

• ConnectionType=AmazonS3
  • AuthScheme=ADFS: This refers to your ADFS username.
  • AuthScheme=Okta: This refers to your Okta username.
  • AuthScheme=PingFederate: This refers to your PingFederate username.
• ConnectionType=FTP(S)
  • AuthScheme=Basic: This refers to your FTP(S) server username.
• ConnectionType=HDFS/HDFS Secure
  • AuthScheme=Negotiate: This refers to your HDFS intance username.
• ConnectionType=HTTP(S)
  • AuthScheme=Basic: This refers to the username associated with the HTTP stream.
  • AuthScheme=Digest: This refers to the username associated with the HTTP stream.
  • AuthScheme=OAuthPassword: This refers to the username associated with the HTTP stream.
• ConnectionType=SharePoint SOAP
  • AuthScheme=Basic: This refers to your SharePoint account username.
  • AuthScheme=ADFS: This refers to your ADFS username.
  • AuthScheme=Okta: This refers to your Okta username.
  • AuthScheme=OneLogin: This refers to your OneLogin username.